Hyperlink Preservation

  • 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


    .../../Users/z018780/AppData/Roaming/Users/z018780/AppData/Roaming/Program%20Files%20(x86)/Rosemount%20Inc/Quotetool/Toolkit.exe


    Why does excel do this and can it be fixed so that it doesn't?