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

Hi Jan,

AutoSave feature can also be disabled if the file is on SharePoint On Premises site or a file server. Old file formats like .xls, .ppt, or .doc can also make the AutoSave feature disabled. You can hover over the AutoSaveswitch and a tooltip will tell you why the said feature is off.

Feel free to post back should you have further concern.

Answer 2

Hi,

I also have problems with AutoSave, and while searching for an answer I keep seeing the statement "You can hover over the AutoSave switch and a tooltip will tell you why the said feature is off."

But my tooltip only say "Automatically Save", so I don't have a clue what the reason is.

Version 1708 (Build 8431.2079)

How do I know if I'm on a SharePoint On Premises site?

Info say its on OneDrive - Company > Foldername

Left click -> Copy path to clipboard gives:

https://company-my.sharepoint.com/personal/user\_company\_no/Documents/Foldername/Filename.xlsx?web=1

I'm starting to suspect it might be on a SharePoint On Premises server...

Answer 3

Hi,

Are you also having an issue with the Auto Save option being disabled? Please be informed that this is a known issue right now and our engineering team is working on a fix. An update will be released as soon as a fix is in place.

We're here if you have more queries.

Regards.

Answer 4

Hi,

Yes, as you can see from the picture in my post, the AutoSave option is disabled. And the tooltip does not tell me the reason for it being disabled.

I'll be patiently waiting for the fix, and will be using the web version in the meantime.

I am willing to test the fix pre release if you need me to.

Answer 5

Same issue here.  AutoSave was working fine until today and suddenly the feature is grayed out.

The file is stored in a synced sharepoint folder on hard drive. Again, until today the sharing and autosave feature worked fine.

Is this a temp known issue?