My formulas such as VLOOKUP refer to cells in other workbook files.
Excel automatically uses the "hardcoded" absolute pathnames to these files.
I need to use a relative pathname so that the set of workbooks are portable.
For example, where I currently have
vlookup(A1,'N:\Groupname\projectA\workbook.xls'!B1:B10,1)
I want
vlookup(A1,'..\workbook.xls'!B1:B10,1)
Is this possible?
Bookmarks