Its a terrible waste of time and effort if you mistakenly close an excel sheet without saving which you have been working on for sometime. This may happen by mistake while closing some other sheet or by an abrupt restart of computer because of some reason or some other software which may cause computer to shutdown or restart for whatsoever reasons.
To save your effort and to save you from mess, there is a wonderful feature in MS Excel 2010 which will automatically keep saving your Excel sheet at certain interval of time and will maintain revisions of the same. In this post I will guide you through the settings and use of this feature which may save you big-time in critical situations.
To ensure that Auto Save option is turned on in your MS Excel 2010, just click on the File > Options:
On the Excel Options Window, Click the Save tab at the left hand pane. In the “Save Workbooks” option, ensure that the option “Save AutoRecover information” is enabled. Default time for saving is 10 minutes, you can increase or decrease it as per your needs. Lets assume that you keep it 10 minutes as default value. Now it will keep saving your excel sheet every 10 minutes until you manually save and close the sheet.
When this option is enabled and you have been working on an Excel Sheet for 10 minutes or more and you close it by mistake, you can recover up to last 5 AutoSave revisions of the same.
To recover an AutoSave version of an excel sheet, click File > Info and check out the Version and Manage Version option.
Some important points related to MS Excel AutoSave Feature are:
- Access up to the last five AutoSave versions of your previously saved active workbook. If you save and close your workbook, all AutoSave versions will automatically be deleted. If you close a previously saved workbook without saving, your last AutoSave version is kept until your next editing session.
- Recover workbooks that were never previously saved. Unsaved workbooks are saved for four days before they are automatically deleted.
You can also recover the unsaved workbooks by opening File > Recent and selecting “Recover Unsaved Workbooks”
Hope you find this tutorial useful For more such useful tutorials, check out –