Forum Discussion
Link address keeps changing.
Last week I spend a few days inserting links in my Excel to both photos and .pdf files. This was done by Insert => Link, Links => Insert link. I am taken to Edit Hyperlink dialog box and find the f...
I did some testing over the week and inserted links by using 5 different ways.
1. Insert link => Insert link and changed the Text to display
2. same way, but without changing the Text to display
3. From local folder with images I right clicked image and Copy Link => Ctrl + V in cell
4. Office.com => OneDrive => My Files => [folder location] => photo => more actions => details => More details => Path => copy path => Ctrl V into cell
5. Office.com => OneDrive => My Files => [Folder location] => photo => more actions => Copy link => Ctrl V into cell
After opening and closing work book several time all the 5 ways works.
Looking at your Advanced > Web options =>Files => the Update links on save was checked already.
In other words it works for now, BUT I am delirious about continuing the massive work only to have it wiped out later.
1. Insert link => Insert link and changed the Text to display
2. same way, but without changing the Text to display
3. From local folder with images I right clicked image and Copy Link => Ctrl + V in cell
4. Office.com => OneDrive => My Files => [folder location] => photo => more actions => details => More details => Path => copy path => Ctrl V into cell
5. Office.com => OneDrive => My Files => [Folder location] => photo => more actions => Copy link => Ctrl V into cell
After opening and closing work book several time all the 5 ways works.
Looking at your Advanced > Web options =>Files => the Update links on save was checked already.
In other words it works for now, BUT I am delirious about continuing the massive work only to have it wiped out later.
Glad it's working so far.
BTW - I recommend unchecking the 'update links option'. It seems when links do break they break as the result of being updated on save. That's my theory anyways.
BTW - I recommend unchecking the 'update links option'. It seems when links do break they break as the result of being updated on save. That's my theory anyways.