Broken Links

K

kellonjames

Hello Everyone,
I have one file that has many Vlookup links to three other files.
Whenever I close the source files I get the following errors;
1. #N/A
2. #REF

Once the source files are reopen the values return.
 
D

Dave Peterson

=vlookup() doesn't have trouble with closed workbooks.

But other functions do.

Maybe you used =indirect() in your formula?

You may want to share your current formula to see if anyone has a workaround
that'll help.
 
Top