Litigation Support Tip of the NIght has been working longer hours this year than he ever has before, so please forgive him if some of the posts on this site are not as detailed as those from past years.
If you find that Excel spreadsheets for which you have added hyperlinks to a network drive using the HYPERLINK formula are inexplicably repointed to the users appdata folder on your C drive, you may be able to prevent this from reoccurring by turning off the AutoSave option. Go to File . . .Options and uncheck the option to autosave the file at ten minute intervals, or the option to autosave the .xlsx file on SharePoint. Also try moving the AutoRecover location to the same directory to the which the hyperlinks are pointed.