AutoSave is a really new feature in Microsoft Office programs. That is present in Office Word, Excel, and PowerPoint programs as well. The AutoSave feature automatically saves your documents each and every few seconds, as you work on a file actually. Read this How to Turn Autosave On in Word, Excel, or PowerPoint. Let’s begin!
While the AutoSave feature is fantastic and is turning on via default. Most of the users mostly complain that the AutoSave is disabled or can’t turn on the AutoSave feature in Word, Excel, and PowerPoint programs as well. If you are also not able to turn on the AutoSave feature, then it’s likely due to one of the following reasons too.
How to Turn Autosave On in Word, Excel, or PowerPoint
Check if AutoSave is disabled
It’s a really good idea to start via checking if the AutoSave feature is turned off under settings or not. There is how you can actually do just that.
- Now you guys have to navigate to File > Options. In the resulting dialog, now just switch to the Save tab.
- You have to select the box next to the AutoSave OneDrive and SharePoint Online files by default option. Then click on the OK button.
Yes, the AutoSave feature is also available and automatically turns on only whenever you are working on a file. That is basically saved to OneDrive, OneDrive for Business, or SharePoint Online as well. That is, the AutoSave feature is turn off and cannot turn on whenever you guys are working on a document. Without even saving it to OneDrive or SharePoint Online or when you are working on a document save on your computer or offline.
In short, the AutoSave feature is basically for users who save files to OneDrive actually.
Besides that, the AutoSave is disabling whenever your file is in a local OneDrive folder and synchronization is pausing or disable as well.
NOTE: The AutoRecover feature that is present in Office programs is completely different from the AutoSave. The AutoRecover feature is also available even when you guys are saving files offline or working on a file without even saving it. The AutoRecover feature also helps you recover files in case of a crash. Or even if you accidentally close a file without even saving it.
You guys are using an unsupported file format
The AutoSave feature is not actually available whenever you are working on an older file format such as .doc, .xls, or .ppt. Change the file format to the latest in order to turn on the AutoSave. If you want to check the file format, have a look at the title bar of the program as well. The title bar shows the file name as well as the file format.
Turn off these security features in Excel
If you guys are unable to turn on the AutoSave feature in Excel, then it could be because of the file. That contains features that do not support via AutoSave. You have to turn off Shared Workbook, remove password encryption from the file, delete restricted access, and also turn off Refresh data when opening.
Plus, an add-in might have disabled the AutoSave. Just head to File > Options > Add-ins > Excel Add-ins > Go and then deselect the checkbox for the add-in as well.
Well, I hope you like this article and understand all the steps. However, if you still have any problems and queries related to this article. Then feel free to ask me in the comments section below. I’ll get back to you shortly.