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.
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.