How to retrieve an Excel file crashed due to System Shut down

 If you are in a situation where your computer suddenly switched off and the Excel file you were working on got closed without saving.

Now for the below method to work your need to have "Auto Save" feature turned on in Microsoft Excel 

To check if Auto Save is turned on follow the below path in your Excel

File-->Options-->Save, now on the right hand side tick the "Save AutoRecover information every X minutes and also tick the "Keep the last autosaved version if I close without saving" option.

Now whenever you excel crashes, the most recent version which was autosaved despite you not saving it will be available when you open a blank excel workbook.

If you want see other versions of the crashed workbooks which are not saved. follow below path.

File-->Open-->Scroll till bottom and click on "Recover Unsaved Workbooks"