Separating excel pages out (2007)

[otuatail]

I have an excel spreadsheet and one of the forms has a page with cell calculations. I hi-lighted a page and copied it (ctrl+c)

When I pace it into a new excel file. it does all this.
Adjust column widths
Copy the font correctly
Put borders around the correct cells
Even background and font colour.

What it fails to do is copy the cell calculations. All I get is the current value in the cell.

This seems stupid. I can't use paste special as there is no option for paste EVERYTHING.