If you separate the files and need to change the link reference you should
be able to go to

Edit/Links and then select the new file. All of the link references will
then change.

You could also put together a macro that could perform this task every time
the file opens. (or at least provide you with a list of possible files to
choose from)

HTH

PC

"Andibevan" wrote in message
...
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