Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |