This article explains you how to auto recover unsaved workbooks in Microsoft Excel.
How to Auto-Recover files in Microsoft Excel ?
Go to the File tab. Choose Info under the file tab.

Click on Manage Workbooks and select Recover Unsaved Workbooks from the drop-down list.

An Open dialog box opens up. Now choose the workbook you want to recover from the list of unsaved workbooks.

Click on Open to open it.
1 Comment
Well i feel the content is not enough about Auto-Recover in Excel.