A
ArcticWolf
Hi,
I have a link in workbook1 from another source in workbook2. When both
files are open the link returns the correct value in workbook1. When I close
workbook2 the link displays #value in workbook1. I've tried updating the
links but to no avail, the status changes to OK but still shows #value, it
only seems to show the correct value when workbook2 is open!
My workbook1 has links to many other workbooks and I don't want to have to
keep them all open, all of the time.
Any ideas on a fix would be appreciated.
Thanks in advance,
AW
I have a link in workbook1 from another source in workbook2. When both
files are open the link returns the correct value in workbook1. When I close
workbook2 the link displays #value in workbook1. I've tried updating the
links but to no avail, the status changes to OK but still shows #value, it
only seems to show the correct value when workbook2 is open!
My workbook1 has links to many other workbooks and I don't want to have to
keep them all open, all of the time.
Any ideas on a fix would be appreciated.
Thanks in advance,
AW