Jan 11 2023 03:17 PM
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,
Jan 17 2023 12:34 PM
Jan 17 2023 12:36 PM
Jan 17 2023 01:18 PM
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
Jan 17 2023 06:56 PM
Jan 20 2023 07:23 AM
Jan 20 2023 07:30 AM