Excel file path editing

[Karl Kruger]

I need help editing a file path name. I use hyperlinks in my Excel
databases and several times when an update from Windows happens, my file
paths change and the address is no longer valid and I have to redo all
of my links ones by one. I can only hope that since the file path change
happens in one instance, it could be repaired somewhat the same way.
Here is an example of what I am talking about, the file name was like
this:
E:\hyperlinks\123456 abc.xlsx

after the download it now reads like this:
C:users\kkruger\appdata\roaming\microsoft\excel\hyperlinks\123456
abc.xlsx.

Can anybody tell me how to change this back? I am talking thousands of
hyperlinks that I do not want to have to redo one by one. Then also what
causes this and how to stop it from happening again.

Any help will be greatly appreciated.
Thank you.




--
Karl Kruger