paths confused when linked file opened from another computer

[bikefancier]

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?

Thanks

[#2]

@bikefancier 

Have you ever looked in here for information and solutions?

Automatically diagnose and repair Windows file and folder problems

https://support.microsoft.com/en-us/windows/automatically-diagnose-and-repair-windows-file-and-folde...

• 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.

Download

Additional information:

Description of link management and storage in Excel

https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel

File sharing over a network in Windows 10

https://support.microsoft.com/en-us/windows/file-sharing-over-a-network-in-windows-10-b58704b2-f53a-...

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.

Nikolino

I know I don't know anything (Socrates)

[#3]

@bikefancier 

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.

[#4]

Thanks, I will take a look.

[#5]

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.