Forum Discussion
Solved
Office / Excel 365 - use relative hyperlinks instead of OneDrive
I've recently been "upgraded" to M365 on my work computer, and it's been .... interesting.... There's a lot of changes, a lot of things have moved around. I'm getting used to it, and finding out how ...
- I got an answer on Stack OverFlow that looks like it is working:
https://stackoverflow.com/a/71576122/2317071
Configure OneDrive to turn OFF "Use Office application to sync Office files" in OneDrive Settings / Office
Perhaps some office Gurus can comment on any side effects of this setting, other that what's shown in the help.
I can't find a way to do it on the first try - adding the anchor pretty much always defaults to OneDrive - BUT if you include a line right after that says "ActiveCell.Hyperlinks(1).SubAddress = target" with "target" being a string to the cell you want to reference in the file you want to get to, it at least works for hyperlinks inside of your current document.