Link Data

A

Andibevan

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
 
J

Jamie A Miller

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.
 
P

PC

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
 
A

Andibevan

Jamie - I need the document to remain dynamic and to involve no copying and
pasting but thanks for the suggestion.

Thanks PC - I tend to stear clear of linked documents and wasn't sure
whether it was possible to change the file-name for all links in one go (if
you see what I mean).

Ta



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
 
Top