Forum Discussion
Excel automatically and randomly changes workbook relative links to absolute links.
Hi everyone, I am working with sevral large workbooks that are linked together (total over 110 Mb of data). Periodically, I do backups trying to copy all workbooks together to another drive hopin...
Same thing is happening with our Excel files. my users download the excel file locally and all the links to content in SharePoint libraries change to "..\..\..\..\..\:w:\t\CILearningServices\Content\EdXjYZ7J3R9Lgo6N25e2rrMBA8EPk3WBUUVXWrZZokiA4Q?e=YWrAWE". This breaks the links. I've got hundreds of links within my teams various excel files that aren't working. If the Excel file is opened from SharePoint and the link is clicked, it works. When downloaded, the links to SharePoint content break.
We make links to SharePoint content using the copy link feature and using the option of "people with permissions" or "everyone at 'my company'.
Denis675, if you find an answer, please share it back here. Thanks 🙂
We make links to SharePoint content using the copy link feature and using the option of "people with permissions" or "everyone at 'my company'.
Denis675, if you find an answer, please share it back here. Thanks 🙂
Well, they don't change to one single link, the SharePoint links lose the front part of their URL. It's like it becomes relative instead of absolute.
Hey,
let me know if you found a solution to this because i am facing the exact same issue right now.
