#How to turn on autosave on excel how to
#How to turn on autosave on excel windows

It is important to select the format that Excel should use when automatically saving your workbooks. Step 3 Check the ‘Keep the Last AutoSave Version’ This will also enable you to do a quick AutoRecover Excel in the event that you lose data suddenly. It will allow you set time limit interval when you want your documents to be automatically saved. Do this by checking the box that is against it. Then select the ‘Save AutoRecover information every’ Option. Once the ‘Excel Option’ opens up, select on the ‘Save’ tab found at the left side of the screen.

#How to turn on autosave on excel windows

Click on the ‘Options’ feature this may, however, be labeled as ‘Excel Options’ in some Windows operating systems. Then check on the left-hand pane to find other functionalities. Once you launch your Excel application, click on the ‘File’ tab. This feature will automatically save any document that was not saved by the user in the event that the computer crashes abruptly. Simply enable AutoSave on your Excel program. You may opt for Excel AutoSave and save yourself the agony of looking through a heap of files for your unsaved document. Well, here’s the kicker you don’t have to wait until you are faced with such an eventuality. If by any means your computer faces a crash problem, just know that you are bound to lose any data or file that you were working on by the time the crash occurred. Likewise, Excel AutoRecover feature steps in place when you switch on your computer, to recover any unsaved and lost file on your machine if you didn’t shut it down correctly. This makes it easy to recover AutoSave Excel if you are still in need of such files. In the event that power goes off or your computer suddenly shuts down without any further warnings, Excel AutoSave will step in and save the document you were working on before your machine went off. Part 1: What Are Excel AutoSave and AutoRecover in Microsoft Office?ĪutoSave and AutoRecover are features that Microsoft Office brings on board to help users easily deal with issues of interruptions while working on their computers. Part 3: How Do I Solve the Issue of AutoSave Not Working?.Part 2: Find and Retrieve “Unsaved” Excel File with AutoRecovery.Part 1: What Are Excel AutoSave and AutoRecover in Microsoft Office?.

#How to turn on autosave on excel how to

If you like this article, check out how to pin individual Excel files to the taskbar and how to open multiple links at once from Excel. If you are stuck or need some help, comment below and I will try to help as much as possible. It is that simple to enable autosave in Excel. For whatever reason, Microsoft chose not to implement the autosave feature in other versions of Office. If you are using any other version, like Office 2013, 2016, 2019, etc., you will not see the autosave option. The autosave option is only available for Office 365 users. From now on, the excel files will be automatically saved to OneDrive in real-time. Here, select the “AutoSave OneDrive and SharePoint online files by default on Excel” checkbox and then click on the “Ok” button. In the “Options” window, select the “Save” tab on the sidebar. From the File menu, select “Options” from the sidebar. After that, click on the “File” option on the Ribbon menu.

With that, autosave is fully enabled in Excel.įirst, open an Excel file of your choice.

Select the “AutoSave OneDrive and SharePoint online files by default on Excel” checkbox.

To turn on autosave in Excel, follow the steps given below. If you are using Excel 2031/2016/2019, etc., you will not see the autosave option. Important note: You should be using Office 365 to use Excel autosave feature. In this quick and simple Excel how-to guide, let me show you the steps to turn on autosave in Excel. All you have to do is enable autosave in Excel and it will do the saving for you. If you forgot to save the file, you might lose precious data in the event of an application or system crash.Īfter all these years, Microsoft finally implemented the AutoSave feature in the newest version of Excel. Though not a big deal for most, constantly pressing the Ctrl + S shortcut can be a pain in the back at times. Without an autosave feature, you have to remember to constantly save the file. In fact, I’ve seen support treads dating as far back as a decade. Excel users have been asking for the autosave feature for a long time now. As good and feature-rich as Excel is, there is one important feature missing for all these years.