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 working on. With my previous cloud service, everything was working fine. Hyperlinks used relative path, so no matter which PC I used, it all opened nicely.
Now with everything being on OneDrive, excel automatically rewrote all of my hyperlinks (about 2000 of them) to sharepoint. Everything now opens with browser. Filetypes that can't be opened want to be downloaded even though I have them stored offline localy.
Is there a way to stop these hyperlink changes? Excel Options > Trust Center > Trust Center Settings > External Content > "Disable automatic update of Workbook Links" is checked.
When I copy the hyperlinks from the original file, they get automatically changed in the new one. When I re-link in the new file to the local file, it opens the local file and works fine. When I close Excel, open it, link is changed again to sharepoint. This is so frustrating.
I have all my files synced to OneDrive so I too had the same issue of creating a hyperlink and it taking me to my OneDrive directory. Most useless!
I might have found a remedy to this now. I created a link using right link menu option under Bookmarks, when completed the cell hyperlink looked like this #Sheet1!A1, so I stuck that into quotation marks in =HYPERLINK("#Sheet1!A1") and it works as a clickable link. I needed to make A1 dynamic based on a cell where today's date falls, so I can even go one step further with =HYPERLINK("#Sheet1!"&A2) where A2 contains a cell reference of B4 for example so it'll evaluate as =HYPERLINK("#Sheet1!B4") and clicking it take me to cell B4 in Sheet 1.
Darth_Hawk
Disable this settings in OneDrive.It will prevent new file having their relative path changed to the cloud.
If it doesn’t fix your existing files where the relative paths have already been changed, try to reboot the PC and open the file from its local path.
As a last resort solution, to restore the local path from an existing excel file, rename it to .zip. Open the zip and edit the file …\xl\workbook.xml replacing <x15ac:absPath url="https://d.docs.live.net… with your local path. Rezip the content and restore previous extension.
- Maybe you save the file in the wrong file encoding.
I'm sorry for coming here quite late.
One drive back up moves your files to one drive folder, that's why the links are messed up.
In my case, I saved a Project folder in my desktop folder. My excel file is inside this folder and all linked files inside the same folder. After one drive stirred sh1t on it, I just copied back the desktop folder under the c:\users/myname which I noticed the desktop folder disappeared.
Excel links will automatically fix itself.
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.
Any solution to this? I have been working on a huge index to link to various files and all of the links just changed to the sharepoint link. I want to open the local file that I linked to, not some online version through a browser. I put so much work into this index, only to have the whole thing destroyed by this.
don242can unfortunately, I have not seen a resolution to this issue. Sorry to hear it has set you back.
- Fverley1223 thanks for the reply. The links were holding for a few weeks of working on this but suddenly today they all pointed to the sharepoint. Completely defeated now.
- I have the same issue. Even hyperlinks to other Excel workbooks that are OPEN are sent to a browser. Microsoft seems to be completely ignoring the issue. Oh, yes I have the box checked.
Darth_Hawk
Any update on this issue?
Seems like I have the same problem and it's causing us some headaches...Darth_Hawk same issue here. We could use a little help Pernille-Eskebo
- I am having the same problem. Thus, if I use OneDrive it becomes inefficient to use!
Is there ANY help from Pernille-Eskebo ?- None that I've found. In fact, it's only gotten worse since my original post. Now, autosave creates a temporary file that becomes disassociated from its source. Close it and everything is lost. 😡
I have the same problem: I'm creating a spreadsheet with links to documents in a subdirectory. This is all stored in a local OneDrive sync. I would like to be able to zip up the directory and send to an external party and have the links open files in the directory. But Excel keeps changing the local relative links to sharepoint URLs.
I also checked Excel Options > Trust Center > Trust Center Settings > External Content > "Disable automatic update of Workbook Links" with no effect.
