Use AutoRecover : AutoRecover « Editing « Microsoft Office Excel 2007 Tutorial






Click the Office button. Click Excel Options.
Click the Office button. Click Excel Options.
Click Save. 
           Select the Save AutoRecover information every x minutes. 
           Enter the number of minutes.
Click Save. Select the Save AutoRecover information every x minutes. Enter the number of minutes.
Specify the complete path for your AutoRecover workbook file.
Specify the complete path to the folder location where you want to save your AutoRecover workbook file.








2.23.AutoRecover
2.23.1.Use AutoRecoverUse AutoRecover
2.23.2.To disable AutoRecover for a specific workbookTo disable AutoRecover for a specific workbook