Broken Links

  • Thread starter Thread starter kellonjames
  • Start date Start date
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.
 
=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.
 

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

Link 2 Excel files 6
Why won't vlookup read newly entered data from a source file? 3
VLOOKUP returns #REF!? 1
Dynamic referencing to files 4
Excel Sumproduct Ref error when table is closed 0
break links not working 39
Links #REF! 4
Wits end wrt automatic linking 3

Back
Top