I have two files, call them FileA.xlsx and FileB.xlsx.
FileA contains VLOOKUP formulas that refer to a range in FileB.
When both files are open, the VLOOKUP formulas work perfectly, returning exactly the expected results.
But when FileB is closed, the VLOOKUP formulas in FileA return a #REF! error.
If FileB is then opened, the VLOOKUP formulas immediately work perfectly again.
Does anyone know why this would occur? Any idea on how to trouble-shoot it or what settings that might be affecting this?
I am using Excel 2016.
Thank you.
FileA contains VLOOKUP formulas that refer to a range in FileB.
When both files are open, the VLOOKUP formulas work perfectly, returning exactly the expected results.
But when FileB is closed, the VLOOKUP formulas in FileA return a #REF! error.
If FileB is then opened, the VLOOKUP formulas immediately work perfectly again.
Does anyone know why this would occur? Any idea on how to trouble-shoot it or what settings that might be affecting this?
I am using Excel 2016.
Thank you.