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