Auto-save not working in Excel

Question

Split from this thread.

I have the exact same issue with Excel 2016 (build 16.0.8326.2096), and it happens even with files that are stored on OneDrive (a OneDrive for Business account, but using the new unified sync client).

I am sure it is not an issue of where the file is stored, because when I open the same workbooks on a different computer using the same version of Excel, I do get an active auto-save toggle, and am able to turn it on and auto-save successfully. Also, auto-save works in PowerPoint 2016 with files in the exact same directories.

I cannot find any reason why auto-save should not be working on that one computer. They are using the same version of Excel and the same version of the OneDrive sync client. The only difference is that the computer where auto-save does not work in Excel, runs Windows 7, while the one where it does work runs Windows 10. No relevant-looking differences in settings, as far as I can tell, but I would appreciate it if you have suggestions for settings that I should check, including using regedit if necessary.

Answer 1

Hello,

It sounds like an issue we have in the Known Issues article. 

https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093

in the section:

Issues affecting Excel features and add-ins

Autosave Is Disabled For OneDrive And SharePoint Locations [Fixed]

Thanks,

Mike

Answer 2

Your answer ignores the complaint that if an Excel file is stored anywhere but a Microsoft oriented or controlled location, the Autosave is not enabled.

This is ignoring a customer complaint and I feel that I am being insulted.

Answer 3

Your answer ignores the complaint that if an Excel file is stored anywhere but a Microsoft oriented or controlled location, the Autosave is not enabled.

This is ignoring a customer complaint and I feel that I am being insulted.

If you don't save the file on SharePoint, your problem will be solved!

Plus, we all know that if SharePoint works Microsoft will start charging for it in a year or so...

Answer 4

Thanks LF,

I will expect to find autosave working after one of the future updates, hopefully in the not to far distant future.

Answer 5

It is supposed to be fixed in Version 1708 (Build 8431.2094).

I updated to Version 1709 (Build 8528.2139), now Autosave just disappeared completely in stead of being disabled.

Am I now affected by "AutoSave is missing from the Office toolbar [FIXED]"?