Full File Path in Reference to Another Workbook in Excel
- by SHARIQ MUSANI
I have two Excel files, one on D:\ and the other one on E:\.
I reference one from the other, for example, using vlookup in the E: file to search from the D: file, like that:
VLOOKUP(A1,'D:\SHARIQ\[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE)
As long as D:\SHARIQ\FILE NAME.XLS is open, I get the formula in the E: file displayed like this:
VLOOKUP(A1,'[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE)
Why does it remove the whole path?
