Forum Discussion
Sharing Multiple linked Spreadsheets with Multiple users using Google Drive
Thank you for your response. I read the blogpost response you attached but the answer I was looking for "Is there any way relative paths are achieved in excel?". I am not sure why excel team chosen to use base path as "C:/username/folder1/folder2/file.xlsx" instead "./../../folder1/folder2/file.xlsx" approach which makes all links cross platform compatible.
Causes of broken hyperlinks in the cloud
The links change as a result of the copying process.
According to the translation, you have this problem.
If this is correct, here is some information that I was able to find.
This means that my knowing (not knowing) is at the end of the matter.
The result:
the links don't work because the files relatively referenced by Excel are not in the cloud.
In order for the hyperlinks to continue to work, you would have to take over all files and the folder structure online.
Microsoft Excel 2016 - cloud storage bends local link paths
Save absolute paths
It is easier if you get Excel to save absolute paths instead of the relative paths. Y
ou have to do this before you copy the Excel file.
To do this, open the file and navigate to the Backstage view via the file tab.
Now switch to Information / Properties / Advanced Properties.
On the Summary tab, enter a point for the current path in the Link base field.
Now confirm with the OK button - done.
Problems working with absolute paths
When you then save the file, Excel uses the absolute path. However, this setting only applies per file, not globally, so you have to repeat the process for each document.
If the link still cannot be accessed online, the usual suspects such as firewalls and other security mechanisms are not the only options. Rather, the respective cloud provider can also prevent certain hyperlinks or document types from being accessed at any time.
Additional infos:
Mac Excel 2019 hyperlinks (relative path), plain text display and validity check (is in German)
Description of link management and storage in Excel
https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)