Forum Discussion
Excel rewrites my hyperlinks to sharepoint
Hi, I transfered all my work files to OneDrive and encountered an issue. I use excel spreadsheets for worklist, where I use hyperlinks for pics, drawings etc for each workpiece we are currently w...
hi all, I have encounter the similar issues which is the sharepoint url inside the excel during copy/move around the one drive folder (or SharePoint map folder )become not update accordingly .
Below is the found out from me , hope this help for other.
[below test case is refer to same SharePoint site ( same OneDrive) hyperlink at excel]
- using excel open the file from OneDrive then save to the new OneDrive folder the hyperlink is updated accordingly
- Move the excel file to other location will also updated accordingly
- if you Copy then will facing issues for the SharePoint hyperlink will not updated accordingly .
work around for the copy method :
- make sure the hyperlink at excel is full URL ( example : https:\\ondrive.com\folder\subfolder\file.txt instead of ..\..\file.txt)
- copy the file to local drive (hyperlink will remain original full URL)
- then copy to OneDrive ( in this case the URL will remain as original full URL)
hope this can help.