Update link cells without open up source document files

[patty]

I got "#REF!" error messages on linked cells after choosing "update" option
when opening up a file. This error messages will disappear and linked info
updated after source document files are open.
How can linked cells update automatically without opening up source doc files?

Please help. Thanks.

 

[Conan Kelly]

Patty,

Are these linked cells using the INDIRECT() or ADDRESS() functions to
"build" references to external files? If so, I know INDIRECT() needs the
external file open in order for it to "build" the reference and return the
value from the reference. I don't know for sure, but ADDRESS() might behave
the same way. If this is the case, then in order to access data in other
files w/o opening them, you will need to use direct references and not
INDIRECT() or ADDRESS().

HTH,

Conan