User Profile
Denis675
Copper Contributor
Joined Jan 11, 2023
User Widgets
Recent Discussions
Re: Excel automatically and randomly changes workbook relative links to absolute links.
Thank you Patrick2788 for your answer. When you mention broken links, do you consider a link that starts (in a VLOOKUP formula for example) with "file:///D:..." as a broken link ? If so, are you aware of any possible solution to fix those links ? Thank you MickThornton for all your input as well !7.9KViews0likes1CommentExcel 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 hoping that all workbook links will follow and refer to the appropriate files in the same drive (relative links). Recently, Excel started randomly changing my relative links to absolute links by adding the mention "file:///" whenever a workbook link appears in a formula. We are talking about hundred thousands of formulas and different links that I can't change manually. Once in a while it works (copying the files all together to a different drive or forder) maintains the relative link but sometimes it doesn't and then, the links change to absolute links in the copied and in the original files. Any idea ? Thanks,9.3KViews0likes7Comments
Recent Blog Articles
No content to show