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!