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