And sometimes, people accidentally close a file without saving.To avoid losing.
#How to turn on autosave in excel 2010 how to#
When you forgot to save your work in case of a power cut or accidentally close your Word/Excel application without saving, there is good chance you can recover your latest contents. How to Enable Autosave in Microsoft Excel.Crashes happen. This will save your work on OneDrive and SharePoint accounts.
![how to turn on autosave in excel 2010 how to turn on autosave in excel 2010](https://i.stack.imgur.com/2XZyD.png)
If you have a OneDrive or SharePoint account, select AutoSave OneDrive and SharePoint Online files by default on Excel. In the menu that opens, select Save on the left. Click OK to save your changes.Īt this point you’ve successfully turned on AutoSave in Word/Excel 2016 – 2007. If you're using Excel 2010 or later, you'll find this menu in the same place. Scroll down to the Save section on the right-side pane and tick the “ Allow background saves” check box. In the minutes box, you can set the time interval at which your document will be saved automatically.Īdditionally, tick “ Keep the last AutoRecovered version if I close without saving” check box. Tick the “ Save AutoRecover information every” check box.
![how to turn on autosave in excel 2010 how to turn on autosave in excel 2010](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/02/autosave-in-excel-example-1.3.png)
Uncheck the box for Save AutoRecover information every x minutes if you wish to disable the AutoRecover feature. AutoSave is a useful feature in Microsoft Office that will automatically save the document you’re working on at certain intervals. How do I turn on AutoRecover Open Word and select File > Options. In the event of a system crash or power loss, you may lost a couple of hours of work as you forgot to save your Word document.