How to Fix Excel Crashing When Opening a Specific Workbook
Question details
The user needs to stop Excel from crashing when trying to open one specific 2 MB XLSX file, especially since the file opens without issues on other computers.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a specific Excel workbook (.xlsx file) that works normally on other devices.
- Observed behavior
- Microsoft Excel crashes immediately when attempting to open the specific workbook, despite the user having already tried Safe Mode, repairing the installation, and clearing the cache.
Ensure the problematic workbook is saved locally on your computer's hard drive (like your Desktop or Documents folder) rather than opening it directly from a network drive, email attachment, or cloud storage syncing folder.
Use the Built-in Open and Repair Feature
Microsoft Excel provides a dedicated tool to detect and repair minor corruptions within a specific workbook during the opening process.
Even if the file opens on other computers, minor structural issues or formatting conflicts can trigger a crash on your specific machine. The Open and Repair tool attempts to fix these inconsistencies before rendering the file.
Launch Microsoft Excel first with a blank workbook, rather than double-clicking the problematic file.
Click on 'File' in the top-left corner, select 'Open', and then click 'Browse' to locate your downloaded local copy of the XLSX file.
Click once on the file to highlight it. Instead of clicking the main 'Open' button, click the small dropdown arrow next to the 'Open' button and select 'Open and Repair...'.
When prompted, click 'Repair' to recover as much of your work as possible. If a previous repair attempt failed, repeat the process but choose 'Extract Data' to salvage values and formulas.

Resave the Workbook from a Working Computer
If the file opens successfully on another computer, saving a fresh copy can overwrite problematic background metadata causing the crash.
Compare Add-ins Across Computers
Discrepancies in installed Excel add-ins between computers can cause a file with specific data connections or macros to crash on one machine but not another.
Open Your XLSX Workbooks Safely with WPS Office
If Microsoft Excel continues to crash when opening your workbook despite troubleshooting, try WPS Office. It is a free, lightweight, and highly stable alternative that effortlessly handles standard Office files without the crashing issues sometimes found in MS Office.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open WPS Spreadsheets: Launch the WPS Spreadsheets application from your desktop.
- 3. Open the problematic file: Simply drag and drop the crashing XLSX file into the WPS workspace. The file will load seamlessly.

Frequently Asked Questions
Why does a specific Excel file crash on my computer but work on others?
This usually happens due to local environment differences. The crashing computer might have conflicting Excel COM add-ins, outdated Office versions, corrupted local caching, or specific printer spooler issues that the working computers do not have.
Will the 'Open and Repair' tool change my Excel data?
The 'Open and Repair' tool attempts to recover as much data as possible. While standard formulas and text are usually preserved, heavily corrupted cell formatting, custom views, or complex charts might be removed to stabilize the file.
What should I do if 'Open and Repair' fails to fix the crash?
If the built-in repair fails, try using the 'Extract Data' option when prompted by the repair tool. Alternatively, you can open the file in a different, highly compatible spreadsheet program like WPS Office to safely view and extract your data.




