Forum Discussion
Solved
Links to workbooks not in same folder are absolute when we want relative
Have a bunch of files in a Cloud environment which uses a Desktop client. If, in an Excel cell, we link to an external workbook which is stored in the same folder, there's no problem. Anyone can t...
- By design, links to workbooks that are in (a subfolder of) the same main folder are relative. All other links will be absolute. That being said, it should not be very hard to write some VBA code that updates the links to your username.
By design, links to workbooks that are in (a subfolder of) the same main folder are relative. All other links will be absolute. That being said, it should not be very hard to write some VBA code that updates the links to your username.
But in my example, the link that becomes absolute IS, I think in a subfolder of the same main folder.
C:\Users\Amy\Cloud\2022\22 Some Branch\filename-wth-link-in-it.xlsx
C:\Users\Amy\Cloud\2022\22 Some Branch\Subfolder\linked-to-file.xlsx