How To Recover A Workbook That You Forgot To Save Changes To
by Francis Hayes (The Excel Addict)
How many times have you accidentally closed a workbook without saving changes and immediately realized your error. This may happen after you have made changes to an existing workbook or after you have been working on a new workbook and forget to save it.
Frequently saving multiple versions of your work is probably your best defense. Though I have to be honest with you, I don't always practice what I preach, as I have a very poor habit of infrequently saving my work. But that doesn't mean that you shouldn't.
Recover Unsaved and Previous Versions of a Workbook
Starting with Excel 2010, a new a new feature called 'Manage Versions' was introduced (well. not really 'introduced' because very few Excel users have even heard about it). With 'Manage Versions', you have the ability to recover unsaved files as well as open earlier versions (i.e. a few minutes ago) of a file that you are currently working on.
To ensure that your versions feature is enabled, click File, Options, Save. Make sure that the that the 'Save AutoRecover..minutes' and "Keep the last autosaved version...' settings are checked.
Open an Autosaved Version of the Current Workbook
To open an recently autosaved version of the file you are currently working on, click File, Info and choose one of the versions listed. The autosaved workbook will open with a different name, thus allowing have two versions of the same workbook open.
You will see a message above the formula bar warning that this is not the latest version of the file (see image below). Do not click on Restore unless you want to replace the current version of your workbook with this previous autosaved version. If you DO need to work with both versions (current and previously autosaved) of a workbook, be very careful as both workbooks may look identical and there is a risk that you may accidentally overwrite some of your recent work.
Once you save and close a workbook, all of its old autosaved versions are removed.
Opening a Previous Unsaved Version of a Workbook
If you close a workbook without saving changes, Excel deletes all versions of the file except for the last saved version and the most recent autosaved version. When you re-open the last saved version of a workbook that was last closed without saving it, you will have the option of opening that previous 'unsaved' version.
To open the previously 'unsaved' version of the current workbook, from the File menu click Info and click Manage Versions, Recover Unsaved Workbooks.
Unsaved Workbooks
To see all 'unsaved workbooks', from the File menu click Open, Recent Workbooks and then click Recover Unsaved Workbooks at the bottom of the screen.
Excel even saves a draft version of new workbooks you create and work with but never save. These draft versions are kept for 4 days and after that they are deleted.
Excel User's Don't Know What They Don't Know
These recovery features can save Excel users a lot of work if they accidentally close a workbook without saving...but only if they know the option is available. Please share this tip with every Excel user you know because, chances are, they don't know that this recovery feature is hiding right under their nose.
If you found this tip helpful, please share it with your friends and colleagues.
To get more tips every week like this one...
'Spreadsheet Tips From An Excel Addict'
'Excel in Seconds' & 'Excel in Minutes'
Plus you also get my 'Excel in Seconds' E-book as a BONUS!
(Download it immediately after you sign up)
Copyright Francis Hayes © All Rights Reserved
8 Lexington Place, Conception Bay South, NL Canada A1X 6A2
Phone 709-834-4630
This site is not affiliated with Microsoft Corporation.