The most important rule is Properly SAVE your Work!  However there are times when:

  • you forget to save a workbook
  • you accidentally save it when you should have saved it as a different name
  • lose work due to  power outage

So DON”T PANIC, you can quickly and easily recover older (unsaved) versions of your workbook.

Excel 2010 saves your unsaved versions of files in a specific folder on your hard drive. Please take note that these are new, unsaved files or temporary files, similar to files that you open from an email or file transfer. Here are the steps to recover the unsaved file:
To recover an unsaved version of a file:

  1. Open Excel 2010 and click on the File tab.
  2. Click Recent on the left, and then click the Recover Unsaved Workbooks button.
  3. In the Open dialog box, you’ll see the contents of your UnsavedFiles folder. For Windows Vista/7, this location is: C:\Users\User_Name\AppData\Local \Microsoft\Office\UnsavedFiles. For Windows XP, the location is: C:\Documents and Settings\User_Name\Local Settings\Application Data\Microsoft\Office\UnsavedFiles.

Note that the files saved in your Unsaved Files folder will no longer be available after four days from the file’s creation or modification.