User Profile
MickThornton
Copper Contributor
Joined Jul 26, 2019
User Widgets
Recent Discussions
Re: Excel automatically and randomly changes workbook relative links to absolute links.
Thanks Patrick2788 for the very useful options tip. I have now made that setting change for the document I fixed about 60 links on and it seems to be working as expected. I love the base address feature and don't remember when that came into Excel. I thought it would work for me, but I found 4 other links to content with different base URLs. 😮7.8KViews0likes0CommentsRe: Excel automatically and randomly changes workbook relative links to absolute links.
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 🙂7.7KViews0likes2Comments
Recent Blog Articles
No content to show