The above steps would make sure that your work is automatically saved after every 10 minutes. This option works for Office 365 only and saves your work in real-time (every few seconds)
Check the option – ‘Save AutoRecover information every’ checkbox.
In the Excel Options dialog box, click on the Save option on the left.If you don’t have O365, you can only use AutoRecover.īelow are the steps to turn on Auto-save in Excel: Remember that AutoSave is only available for Office365 users. Once done, this would be turned on for all the workbooks you work on that system. You can enable AutoSave as well as save auto-recover information (i.e., to save files automatically at a certain time interval) in Excel from the Options dialog box. Turn On AutoSave in Excel from the Options Dialog box In this tutorial, I will cover both of these features. In case your system shuts down unexpectedly, you will still be able to recover the temporarily saved file (using the Autorecover feature). With this option enabled, it will keep a temporary copy of your work and keep saving it every 10 minutes. On the contrary, ‘Save AutoRecover Information’ is an option that automatically saves your work every 10 minutes (or whatever time period you specify). Automatically Save File Before Closing using VBAĪutoSave is a new feature in Excel Office 365, while AutoRecover has been in prior versions as well.ĪutoSave allows you to save your work in real-time when you save your Excel files in OneDrive or SharePoint.Using Third-Party Tools such as DropBox or Google Drive.Adding AutoSave to QAT (for Office 365).Turn On AutoSave in Excel from the Options Dialog box.
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. Click OK to save your changes.Īt this point you’ve successfully turned on AutoSave in Word/Excel 2016 – 2007. 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. When the Word/Excel Options dialog box opens, select the Save tab on the left navigation pane.If you’re using Word/Excel 2007, just click the Office button at the top left corner and choose “ Word Options” or “ Excel Options“. On the backstage screen, click Options on the left-hand pane. Open your Word or Excel application, click on the File tab.
#HOW TO TURN ON AUTOSAVE WORD 2016 HOW TO#
How to Turn on AutoSave in Word/Excel 2016 – 2007? In this tutorial we’ll show you how to turn on AutoSave in Word or Excel 2016 / 2013 / 2010 / 2007. AutoSave is a useful feature in Microsoft Office that will automatically save the document you’re working on at certain intervals. 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.
0 kommentar(er)
