Link documents
Hi Bogi,
Note that the data retrieved by some formulae (eg formulae using the INDIRECT Function) that can be used for linking will only work
if the source workbook is open; otherwise you'll see #REF displayed.
Also, make sure 'update remote references' is checked, under Tools|Options|Calculation.
--
Cheers
macropod
[Microsoft MVP - Word]
"Bogi" wrote in message ...
I have a document that gets info from another document. My problem is that
the document dosenĀ“t update until I open the referance document. Can somone
help how to update without open the refernce excel document
Thanks
|