Forum Discussion
Excel hyperlink changes to local path
Hello all, I have a problem with the path of hyperlinks in an excel file changing. I have a file which has a list of hyperlinks to different drawings, these drawings are stored on the company sharepo...
If all the hyperlinks in the workbook go to the same SP document library, you could use a hyperlink base (Stored in the properties of the workbook so it travels with the worbook):
See: Set the base address for links in a workbook
https://support.microsoft.com/en-us/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
See: Set the base address for links in a workbook
https://support.microsoft.com/en-us/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
I am having the same problem (absolute file paths changed to relative paths) when I save my excel with hyperlinks (added through VBA for excel). This can create problems when I share this file with another user/ when I copy the hyperlinks to another file (I use VBA for excel for the copy).
I do not see any option in the Hyperlinks.Add method to "retain" the absolute path names.
I am using Excel 2019 on am MacBook Pro (M2) with the current/ latest version of the MacOS.
I do not see the options for setting a base address that you mentioned for Excel 2019 on the MacOS version. Also, I'd like to do that through VBA to reduce errors.