Recover Your Unsaved Work in MS Excel Spreadsheet

Recover Unsaved Changes in MS Excel Spreadsheet / How To Recover A Excel Workbook You Forget To Save Changes To.

Many times you have accidentally closed a Excel workbook without saving changes to it and after that immediately you realized your error. This may happen after you have been working on a new workbook or after you have made changes to an existing workbook and forgot to save it, then what should you to do to recover your work in Microsoft Excel.
 

How to recover a workbook which you forgot to save changes to it?

 

Auto Recover

Excel versions before 2007 and With Excel 2007, situations like these would leave you completely out of luck. Think, If your computer crashed / Shutdown however, there was a possibility that MS Excel would retrieve the last AutoSaved copy of workbooks / Worksheets that were open at the time of the crash or Shutdown and allow you to recover them from the AutoRecover pane, but this was not very reliable. So, frequently saving multiple versions of your work is probably your best defense.

In Excel 2010, a new feature called 'Manage Versions' was introduced. well. However very few Excel users have even heard about it. You now have the ability to recover unsaved files as well as to open earlier versions (a few minutes ago) of a file you are currently working on it. You have to ensure that your versions feature is enabled.

How to check your versions feature is enabled or How to enable you versions feature enable:- 

 

1)- Click File.

2)- Click on Options.

3)- Go to Save tab.
 

Auto Recover Workbook

Make sure that the 'Save AutoRecover information every ....minutes' and "Keep the last autosaved version...' settings are checked.
If not then tick both the options checked. 

Ensure that your microsoft Excel AutoRecover settings are enabled to ensure you are safe from any problem.

Excel 2010 and later, automatically saves a version of the workbook you are working on every 10 minutes. 

How to open a recently autosaved version of your Excel File? 

To open a recently autosaved version of the file you are currently working on follow the given below steps:-
 

1)- Click File
 

2)- Go to Info Tab
 

3)- Choose one of the versions listed.
 

The workbook using a different name, thus allowing you to work back and forth between two versions of the same workbook.
 

How to open previous version of the current workbook in Microsoft Excel? 

Once you save and close a workbook, all of its old autosaved versions are removed.
Excel deletes all versions of the file except for the most recent autosaved version (i.e. Draft Version), if you close a workbook without saving changes. If you have need, you can also open the previous 'unsaved' version, while reopening the last saved version of a workbook.
 

How to open a previously 'unsaved' version of the current workbook? 

1)- Go to File Menu and click on Info Tab.
 

2)- Click Manage Versions.
 

3)- Recover Unsaved Workbooks.
 

Auto Recover Excel

To see all 'unsaved workbooks', from the File menu select Recent and click Recover Unsaved Workbooks on the bottom right of the screen.
 

How to recover unsaved versions of Excel workbooks? 

Excel saves also a draft version of new workbooks you create and work with but never save. These draft versions are saved for 4 days and after that they are deleted.
 

This is a great feature that can save Excel users a lot of rework if they accidentally close a workbook without saving, but only if they know it exists.