Forum Discussion
Solved
Reference Data File Paths Change When I Paste Template in New Location
Good Morning, I have searched and am not finding a solution to my problem. Please point me in the right direction if there is a thread for this all ready I'm overlooking. I have a template t...
- By design, paths in Excel formula links are relative. So if you copy a file elsewhere, Excel will try to find the linked file *relative* to the new location.
INDEX MATCH against an external file is a relatively slow process. Given that you stated that you want the path to be absolute, why not add a tab to your file and use Data, Get Data, From File, From Workbook to import the entire table. You can then set that connection to update e.g. on file open. Point your INDEX/MATCH formulas to the new table in your current file.
By design, paths in Excel formula links are relative. So if you copy a file elsewhere, Excel will try to find the linked file *relative* to the new location.
INDEX MATCH against an external file is a relatively slow process. Given that you stated that you want the path to be absolute, why not add a tab to your file and use Data, Get Data, From File, From Workbook to import the entire table. You can then set that connection to update e.g. on file open. Point your INDEX/MATCH formulas to the new table in your current file.
INDEX MATCH against an external file is a relatively slow process. Given that you stated that you want the path to be absolute, why not add a tab to your file and use Data, Get Data, From File, From Workbook to import the entire table. You can then set that connection to update e.g. on file open. Point your INDEX/MATCH formulas to the new table in your current file.
THANK YOU! This thought also occurred to me after posting this. I was in the middle of performing those edits to test. Initial testing just worked!!