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!