Forum Discussion
Excel rewrites my hyperlinks to sharepoint
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.
FredDF I tried editing the XLSX as per your suggestion, but then Excel complains the file is corrupt. Could you be more specific which part needs to be replaced? Only the path in url="..." ?
- Maybe you save the file in the wrong file encoding.
This is crazy, been happening for years, why hasnt MS sorted this out yet? the hours and hours of resolving this issue, including rebuilding files that become corrupt because of it...
Im going to try moving the file and linked files to My PC and out of the cloud folder in hope that it works without anymore issues.. defeats the point of MS cloud... not very clever of MS.
ill just have to copy and paste the files to the cloud every now and again and hope that my PC stays stable.Would be better to use a folder sync to one cloud folder on the pc so the two are not linked my MS.
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.
