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...
Two possible solutions to prevent the links from breaking. Note, these solutions will not fix any links that have already broken.
1. Disable 'update links on save'
2. If all the files are pointing to the same directory, you could try setting a hyperlink base:
Work with links in Excel - Microsoft Support See: Set the base address for links in a workbook