Excel crashing when you open one particular file is a clear sign of workbook corruption. The file’s internal structure has been damaged, causing Excel to fail when trying to read it. This article explains why files become corrupt and provides step-by-step methods to recover your data. You will learn how to use built-in repair tools and manual recovery techniques.
Key Takeaways: Repairing a Corrupt Excel File
- File > Open > Browse > Select File > Open and Repair: Uses Excel’s built-in utility to attempt automatic recovery of the damaged workbook.
- Open the file in Safe Mode: Prevents add-ins and complex calculations from loading, which can sometimes allow a corrupt file to open.
- Extract data via Power Query or as an XML file: Bypasses the standard file open process to salvage raw data from a severely damaged workbook.
Why Excel Files Become Corrupt and Crash on Open
Workbook corruption happens when the file’s binary structure is altered or damaged. This prevents Excel from correctly interpreting the data, formulas, and formatting, leading to an immediate crash. Common causes include sudden system shutdowns during a save, storage media errors, network interruptions when saving to a server, or bugs in Excel or third-party add-ins. The corruption can be in the workbook’s core data, its visual components like charts, or the file header that Excel reads first.
Steps to Repair a Corrupt Excel Workbook
Start with the simplest method and proceed to more advanced techniques if the file remains unopenable.
Method 1: Use Excel’s Open and Repair Tool
- Launch Excel and go to File > Open
Do not double-click the corrupt file. Start Excel first to access the repair menu. - Click Browse and navigate to the corrupt file
In the Open dialog box, find the file that causes Excel to crash. - Click the small arrow on the Open button
Do not click Open directly. Click the dropdown arrow next to it. - Select Open and Repair from the menu
Excel will display a dialog with two options: Repair and Extract Data. - First, click the Repair button
This instructs Excel to try to recover as much of the workbook as possible, including formulas and formatting. - If Repair fails, click Extract Data
This option will recover only the values and formulas, leaving out charts and formatting, which is often the source of the corruption.
Method 2: Open the File in Safe Mode
- Close all Excel windows
Ensure no other workbooks are open. - Hold the Ctrl key and double-click the file
Keep holding Ctrl as you double-click the corrupt workbook icon in File Explorer. - Click Yes to the Safe Mode prompt
A dialog will ask if you want to start Excel in Safe Mode. Click Yes. - Try to save the file immediately
If the file opens, go to File > Save As immediately and save it with a new name. This creates a fresh, uncorrupted copy.
Method 3: Extract Data Using External Tools
- Rename the file extension to .zip
In File Explorer, rename the corrupt .xlsx file to have a .zip extension. Confirm the change when prompted. - Open the ZIP file and navigate to the xl folder
Double-click the new .zip file. Look for a folder named ‘xl’ and open it. - Find and copy the worksheets
Inside the ‘xl’ folder, find a subfolder named ‘worksheets’. It contains XML files for each sheet (e.g., sheet1.xml). Copy these files to a safe location. - Create a new Excel workbook and use Power Query
Open a blank Excel file. Go to Data > Get Data > From File > From XML. Browse to and import one of the copied .xml files. This can extract the raw cell data.
If Standard Repair Methods Fail
Excel Crashes Even in Safe Mode
If the file crashes Excel in Safe Mode, the corruption is severe. Your best option is to use a previous version. Right-click the file in File Explorer, select Properties, and go to the Previous Versions tab. If System Protection was on, you may find an older, uncorrupted version to restore.
File Opens but Formulas and Charts Are Broken
This indicates partial corruption. After using Open and Repair, manually check key formulas. Select a cell with a formula, press F2 to edit it, and then press Enter. This can force Excel to re-evaluate and fix the formula. For broken charts, delete them and recreate them using the recovered data.
You See a “File Format is Not Valid” Error
This error suggests the file header is damaged. Try opening the file in a different application. Open Word or Google Sheets and use their File > Open menu to browse to the Excel file. These programs have different parsers that might read the data, allowing you to copy and paste it into a new Excel file.
Open and Repair vs. Manual Data Extraction: Key Differences
| Item | Open and Repair | Manual Data Extraction |
|---|---|---|
| Primary Goal | Recover the entire workbook with formatting | Salvage raw data when repair fails |
| Best For | Moderate corruption in calculations or styles | Severe structural corruption |
| Data Recovery | Formulas, values, charts, pivot tables | Cell values and text only |
| Complexity | Simple one-click process within Excel | Technical, involves file renaming and XML |
| Time Required | A few minutes | 15-30 minutes per sheet |
You can now diagnose and attempt to fix a corrupt Excel workbook that causes crashes. Start with the Open and Repair feature from the File menu. If that fails, try opening the file in Safe Mode by holding Ctrl. For a more advanced recovery, rename the file to .zip to explore its internal structure and extract data. Regularly use File > Save As to create fresh copies of critical workbooks, which helps prevent corruption from accumulating over time.