This article explains how to use the AutoSave feature in Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010. It also explains what AutoRecover is, how to recover a file, and what to do if you don't have the AutoSave feature.
How to Enable AutoSave in Excel
AutoSave automatically saves your files to your OneDrive and SharePoint accounts. You need to configure OneDrive or SharePoint to connect them correctly. This feature is only available in Microsoft 365. It also lets you “co-edit” documents with others.
AutoRecover temporarily keeps track of changes to a directory on your computer. Available since Office 2007, it does not automatically save your files. Instead, if your computer crashes or Excel closes without saving, you have the option to recover your work. It saves this information at a set interval, usually 10 minutes, but it is only temporary. If you choose not to recover your data, the data is deleted and you are back where you started.
Since 2010, Excel has made only minor changes to the AutoSave feature. If you are using Excel 2010 or later, you will find this menu in the same place.