=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.

wrote:

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.

--

Dave Peterson