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


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