Forum Discussion
Solved
Absolute links pasted from onedrive share link in excel become relative and break
We have users that paste OneDrive share links in excel documents and then send to multiple external users. I'm aware in windows excel client you can disable 'update links on save' under web options...
The other workaround is to set a hyperlink base in the workbook's properties. This presumes all your links point to the same location and the file names are the only thing that changes.
See: Set the base address for the links in a workbook
The other workaround is to set a hyperlink base in the workbook's properties. This presumes all your links point to the same location and the file names are the only thing that changes.
See: Set the base address for the links in a workbook
Patrick2788 Thanks, it appears one limitation of this is since I am using shared links from onedrive I would have to make sure all shared files reside in the same onedrive user.