Having just moved some of my Excel files into iCloud Drive, the embedded hyperlinks to cells in other excel files only seem to work as absolute paths.
Is there a way that I can change the path so that it only references the iCloud Drive, this way the links will work no matter whether I am accessing the file from my iMac or my MacBook Pro.
Is there a way that I can change the path so that it only references the iCloud Drive, this way the links will work no matter whether I am accessing the file from my iMac or my MacBook Pro.