#value

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop Command Question 4
Link to Named Range in External File 0
Need to Keeping Same Display Value on 2 Workbooks 1
STOP close button on another workbook 6
Automatically closing slave workbook when main workbook is closed... 0
How to access a function from a different workbook 1
Vlookup or Match VBA 6
Open UserForm From A Different Workbook 17

Top