AutoRecover

If you don't know then I want to tell you that MS Excel periodically save the the file that you have not saved yet. or in  other case if MS excel crashed that closed then it means all of you data has lost but MS Excel Latest version have auto Recovery feature that helps the user to recover the unsaved file.

If MS Excel crashed and you close it. then next time when you open MS excel, it show a recovery panel on left side that have all those files which you had used in you working and never been saved. See below

This is very quick and shortcut way o access your lost and unsaved Excel file.


How to recover the data of a File that was Closed Mistakenly and Data was not saved
Suppose you close the workbook and it asks you to save the data with three option, Saved, Don't Saved and cancel and you have mistakenly click on Dont saved, then how to recover the data of unsaved file

Follow these steps to recover the data.

• Go to File
• Click on INFO
• Go to Manage Version
• Click on Recover Unsaved Workbooks

• Click on Last Autosaved File.

This will appear that file which was not save. click on that file and recover you data.

If you have saved you file at once but you mistakenly clicked Don't Save, 
Follow these steps to recover the data.

• Go to File
• Click on INFO
• Go to Manage Version
• Under this Version, you will see you last once saved file name with time and date etc. click on that name and recover your file data. see below