Can anybody help me please?
 

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


--
certain_death
------------------------------------------------------------------------
certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=510589

Can anybody help me please?
 

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"
wrote in message
news:certain_death.22ywqy_1139498103.4175@excelfor um-nospam.com...

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


--
certain_death
------------------------------------------------------------------------
certain_death's Profile:
http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=510589