sekrotx.blogg.se

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.