I have a location on my c drive, c:\mike.
Inside that there are subfolders and documents to which I am hyperlinked in excel.When excel crashes and I have to recover the documents the hyperlinks have all been changed.
The links to the network locations are okay but the links to my c:\mike folder have all been change to a location in users/appdata/roaming/Microsoft.
For Example here is a link to a program I use.
c:\Program Files (x86)\Rosemount Inc\Quotetool\Toolkit.exe
After a crash the hyperlink in the cell has changed to the text below
Why does excel do this and can it be fixed so that it doesn't?