How do I stop Excel from using AppData/Roaming for Hyperlinks?

Question

I have an Excel 2013 spreadsheet that resides on a network and all hyperlinks are within folders in the same folder as the spreadsheet.  Excel keeps changing the Hyperlink address to the C:\Users\my name\ AppData/Roaming folder on my local C: drive.  How do I turn this "feature" off? (It is totally contradictory to using hyperlinks.)  Also, I am the only user of this document.

Answer 1

Dear Jon,

Thanks for your updates.

Could you confirm how you insert the links, use the formula like what I showed above or the Link option by clicking on Insert>Link? From your description, there are no links pointing to the document. So it seems that the links in the file are pointing to other files stored on the network. 

Are the file and other files the links are pointed to stored in the same folder in the personal OneDrive online place (www.onedrive.com), the OneDrive for Business library (https://tenantdomain-my.sharepoint.com/personal/username\_tenantdomain\_onmicrosoft\_com/\_layouts/15/onedrive.aspx), a site library in SharePoint Online or a network shared folder on a server? 

If they are stored in SharePoint Online, do you use the OneDrive sync client to sync them to your local sync folder and then add the links in the affected file?

Could you list the detailed steps about how you insert the links in the affected file for us to do the same test as what in your environment and upload some related screenshots about “When an Excel Document is set to ‘Autosave’ it

defaults to the file location users/.../appdata/roaming/Microsoft/ on your hard drive.  By turning off autosave for this folder or directing the autosave to my network folder where my files are located, it does not lose links after

a crash or close without saving.” for our clarification?

Best Regards,

Cliff

Answer 2

Dear Jon,

Could you confirm and provide what I mentioned above if you need further help on this issue?

Best Regards,

Cliff