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 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
4 Replies
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.
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
https://support.microsoft.com/en-us/help/328440/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.
Nikolino
I know I don't know anything (Socrates)
- Thanks, I will take a look.
