Link (closed)workbook to (open)workbook

Originally Posted by Jón Ingi

But still the reference error is there until I open the source file.

Then I suspect it is not Vlookup() function.

May be something like countif() or sumif() which will show results when the source file is open