Forum Discussion
Hyperlink in Excel with Sharepoint documents.
Hello,
In our company, some users use Excel files with a hyperlink to other Excel files or cells of Excel files. Our users use OneDrive to synchronize libraries, so the (Excel) files are directly in OneDrive. If they open a Excel file from the Sharepoint Explorer, and they create a new link to another Excel file, the link will be like: C:\Users\Test\etc\etc, This is not right, because it is creating a local link and it should be: https://tenant.sharepoint.com/sites/folder/etc/etc. If another user click on the hyperlink, it will try to connect to the local link of the user who set the link.
How can I ensure that I link to an online file instead of a local file?
5 Replies
Hello,
We had this issue and found this is happening only some times if you go back and open some of your files you probably notice some of them has the web path instead of local path.
Here is the solution, they just need to wait until Excel shows Saved, if they close the file in Saving mode local path will be saved.
Also user need to wait until they see the green check mark on their Synced file before reopening the file.
Hope this resolve your issue 🙂
Alireza
Alireza Rahimifarid Thanks for your reply. Strange that when I try to link a recent file, it always takes the web path. As you can see on the screenshots below.
