Forum Discussion

Jean-Paul_Gruffeille's avatar
Jean-Paul_Gruffeille
Copper Contributor
Mar 07, 2023
Solved

How to get the local file name of a linked document?

I want to be able to access linked spreadsheets regardless of the machine and/or folder they have been copied to as long as they are all in the same folder. 

For the time being, I have an error because the file name has changed and includes the full pathname.

How can I achieve this?

Can I pass the filename as a NAME in my formulas? Can I share a list of NAMES between several spreadsheets that can be used in all the formulas?

 

Thank you for your help.

excel
Formulas and Functions
office 365
  • JKPieterse's avatar
    JKPieterse
    Mar 07, 2023
    In theory, as long as the workbooks you link to are either in the same folder, or in sub-folders below the main folder, you should be able to copy those files to another location and keep the links working. As long as you make sure the relative locations are the same (files in same folder, or in same sub-folders)
    However, for files in Sharepoint or OneDrive folders, it seems this principle doesn't (always) apply. The links (may) become permanently tied to the folders the source files are in. For those situations I'm afraid you'll have to go into Data tab, Edit links dialog to change them to the correct files.
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 07, 2023
    In theory, as long as the workbooks you link to are either in the same folder, or in sub-folders below the main folder, you should be able to copy those files to another location and keep the links working. As long as you make sure the relative locations are the same (files in same folder, or in same sub-folders)
    However, for files in Sharepoint or OneDrive folders, it seems this principle doesn't (always) apply. The links (may) become permanently tied to the folders the source files are in. For those situations I'm afraid you'll have to go into Data tab, Edit links dialog to change them to the correct files.

Resources