If you never want to have the formulas update, why not get rid of them. You
can copy all the data on the metrics page and then right click and choose
"paste special." Then choose values. This will give you the values you
want, and eliminate the formulas altogether. This is just an idea.

"Andibevan" wrote:

Hi All,

I have a table in a spreadsheet with a large amount of data in it.

I then have a metrics page that calculates about 200 statistical
calculations.

I would like to seperate the metrics sheet from the main page as when I
update the data, it has to recalculate the metrics page for each change.

What is the best way to seperate the metrics page (I have considered turning
on / off re-calculation but this is not acceptable).

The metrics page utilises dynamic ranges and the name of the data file
changes daily.

I can think of a number of ways to do it but am sure that one is
significantly better than the others - any pointers would be appreciated.

Ta

Andi