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