How to Fix an Excel 2007 File That Crashes When Saving

1. Open Excel 2007 and click the 'Microsoft Office Button.'
2. Select 'Open,' and browse to the file you would like to repair.
3. Select the drop-down arrow next to the Open button to view the open options.
4. Select 'Open and Repair' and then 'Repair' if you want to repair as much of the file as possible. Select 'Extract Data' if repairing the file does not work.
5. Click the 'Microsoft Office Button' and then choose 'Excel Options.' Select the 'Save' option and make sure the 'Save AutoRecover Information' box is checked as a pro-active measure against file corruption.
6. Select the 'Microsoft Office Button' and then 'Save As.' Select 'Tools' and then 'General Options.' Check the box 'Automatically Create Backup' as a pro-active measure in the event that your workbook becomes unrepairable.