paths confused when linked file opened from another computer

Occasional Visitor

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 other folders become confused.  For instance,

As things appear on computer where files are located:

Linked file             C:\Users\Tom\Multiuser\Inventory, Product

Source Data File   C:\Users\Tom\Read Only\Documentation\AHE


As things appear from another computer on the network:

Linked file           \\tom\multiuser\Inventory, Product

Source Data File  \\tom\multiuser\users\Tom\Read Only\documentation\AHE


That path to the source data file is a useless mess. 

I've been searching the web for hours with no answers.  Does anyone know what's casusing this?


2 Replies


Have you ever looked in here for information and solutions?

Automatically diagnose and repair Windows file and folder problems

  • This troubleshooter might be in English only. However, the automatic fix also works for versions of Windows in other languages.

  • If you’re not on the computer that has the problem, save the troubleshooter to a flash drive or a CD, and then run it on the computer that has the problem.



Additional information:

Description of link management and storage in Excel

File sharing over a network in Windows 10


Ps. Is your pc connected to a network or individually with Windows 10?

If so, which version exactly? e.g. Windows 10 Enterprises (2004).
Hope this information will help you.

I would appreciate your feedback.

Thank you for your patience and time.




I know I don't know anything (Socrates)



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.