Quote:
Originally Posted by Luke M[_4_]
It sounds like you are using the INDIRECT function, otherwise this should
not be a problem. If you are, I'm afraid INDIRECT requires the source
document to be open.
--
Best Regards,
Luke M
"TamIam" wrote in message
...
Hi there, is there any way to automatically update linked documents
without
opening the source document? When I leave them closed, my main worksheet
shows #VALUE! in the cell, but when I open the source documents, the value
is
displayed.
Not sure if this can be helped, but I thought I'd ask
--
Thanks for your help!
|
Hi Luke,
sorry for the intervene, when the source is not opened, indirect throws #REF error not #value
Similar Threads
Threaded Mode
