Nov 03 2020 09:09 AM
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
Nov 03 2020 10:07 AM
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?
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Nov 03 2020 01:35 PM
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.
Oct 06 2021 09:13 AM
Oct 06 2021 10:11 AM