Forum Discussion
paths confused when linked file opened from another computer
We have Windows 10 computers running Excel 2010 to 2016. When files on one computer are opened from another, only the links to source data files in the root folder function correctly. Files in othe...
Excel keeps in file relative reference on linked file. As soon as you open it at new location it automatically adds to this relative part full path of the folder there you open the file. More about this here
Description of link management and storage in Excel and Simple Relative References in External Links
The workaround could be to parse path with cell("filename") and generate links based on it.
- I fixed the problem by mapping the drive for the source data file on every computer used to access the linked file. The letter assigned to the mapped drive has to be the same on each computer. It works, but it is a work around that should not be necessary.
