Forum Discussion
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. Unfortunately that is a local setting specific to my app so doesn't solve the issue for any user that doesn't have the same setting or mac users where they can't even update that setting.
Is there no work around to share links in excel?
They change from http://url/path/tofolder to something like ../../../../../p/.
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.
