It’s often a user’s worst nightmare to find that an important workbook suddenly won’t open, mostly due to the fact that such files are irretrievably corrupted, but there are a few steps you can take before you decide to start over from scratch with your spreadsheet.
Excel generally launches File Recovery mode when a workbook cannot be opened cleanly. This consists of the prompt shown in step 4 of Figure 1. However, you can also manually launch File Recovery Mode for any spreadsheet that you wish, as shown in Figure 1:
- Click once on the affected file within Excel’s Open dialog box.
- Click the arrow at the right-hand side of the Open button to display a menu.
- Choose Open and Repair.
- Choose Repair.