Life is memorable. Share your experience. Help others. Return the favor. Terms Of Use    Privacy Policy    About    FAQ    Help   Contact Us  
As an Amazon Associate and affiliate with other third parties, Echofavor earn from qualifying purchases and display advertisements.
0.1933996

Sharepoint Excel hyperlink or links not working - Relative vs Absolute Path

After you upload your Excel files to Sharepoint, you realize later that the hyperlinks in the Excel file are not working for other users.

You go and check the URL, and notice all the paths have been changed to relative path instead. eg. /../../pathname/filename.

There is a setting that you can configure in Excel that might have caused this problem in which Excel changed the absolute hyperlinks to relative hyperlinks:

  • In Excel, go to File -> Options, a new window popups.
  • Go to Advanced -> scroll down and under the "General" section, click on Web Options.  Click on Files tab. Uncheck "Update Links on Save".

Excel - Update links on Save

After updating this configuration, you will have go back and edit each hyperlink and put the absolute path again.

I also encountered issue where some long paths doesn't work. When you paste the URL, it gets cut off.

In this case, I go to the folder or file in Sharepoint, and click on the ellipsis (...), and copy the shorter URL and paste it in for the hyperlink.



  

Copyright © Echofavor 2020. All Rights Reserved. Powered by Echofavor
Copyright © Echofavor 2020. All Rights Reserved.
Powered by Echofavor
Our Cookie Policy

Echofavor and carefully selected third parties use cookies on this site to improve performance, for analytics and to show you offers tailored to your interests on our site and third party sites. By continuing to use our site, you consent to our use of cookies. Privacy Policy