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.

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




"patty" wrote in message
...
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.