How to Recover an Excel 2007 File

After an Excel Crash
1. Restart Microsoft Excel 2007. You may also need to restart your computer if you had a system crash or power outage. The document recovery task pane should automatically open on the left side of the screen.
2. Scroll through the documents in the 'Available Files' list. Excel will try to recover up to three versions of the document you were most recently working on.
3. Select a file from the list. Click the down-arrow icon.
4. Click 'Open' to view the recovered document. If you know you want to keep the file, click 'Save as' to rename it. Click 'Delete' if you want to delete the particular file. Save the recovered file that is most useful.
Avoid Losing Data
5. Open Microsoft Excel 2007.
6. Click the 'Microsoft Office Button.'
7. Click 'Excel Options.'
8. Click the 'Save' link.
9. Select 'Save AutoRecover Information Every x Minutes.' Enter the number of minutes in the 'Minutes' list. This will be how often Excel will automatically save your work and program state.