View Single Post
  #1   Report Post  
Jack
 
Posts: n/a
Default ** 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 File2 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