Forum Discussion
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 beca...
- 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.
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.
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.
- Hi,
Thank you very much. Indeed my problems occur with OneDrive.
