Forum Discussion
bsim365
Sep 27, 2024Brass Contributor
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...
- Sep 27, 2024
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
Sep 27, 2024Silver Contributor
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
bsim365
Sep 30, 2024Brass Contributor
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.