Can anybody help me please?

C

certain_death

Hi,

I have a workbook that links to other files in other locations by form
of lookups.
When I open my workbook the cells which have the link in say "#VALUE"
until I open the workbooks it is linked to and then it updates
properly.
Why is this? It is a perfectly legitimate formula.
Can anyone shed some light on it please?
Thanks
Mark
 
B

Bob Tarburton

Try going to Tools/Options on the Calculation tab, chack the boxes for
update remote references and save external link values.
When you open the file it should ask if you want to update, say no, unless
the files with liks are open.

"certain_death" <[email protected]>
wrote in message
news:[email protected]...
 
Top