** Links don't update UNLESS source file is open
 

Hi,


I have 10 or so links from File1 used in File2. When both files are
open everything works well.


However, when File1 is closed and I open File2 I get the error:
"The workbook contains one or more links..." and does not update.


When I open File2 and try to use the Edit/links option to Update the
links it does not open File1 and update.


It only seems to update when the source file is already open.

Is there any way around this?

Thanks,
Jack


Reply

Jack schrieb:
Hi,


I have 10 or so links from File1 used in File2. When both files are
open everything works well.


However, when File1 is closed and I open File2 I get the error:
"The workbook contains one or more links..." and does not update.


When I open File2 and try to use the Edit/links option to Update the
links it does not open File1 and update.


It only seems to update when the source file is already open.

Is there any way around this?

Thanks,
Jack


Reply