Why do my hyperlinks in Excel change to a roaming folder?

There is a very simple to fix this "Hyper-Loss" problem. Either turn off "Autosave" or go to Options/Save and direct the autosave to default to the location that the files reside in. For some reason, your file is auto saved every 10 minutes to a folder on your hard drive named user/appdata/roaming/Microsoft/Excel by default and if that your file is accidentally closed and the autosaved version pops up; it will have the new hyperlink location as you hover. Turn off auto save and just hit save every now and then: Easier headache than replacing 50 hyperlinks like I had to do.