How to Fix Excel Freezing or Crashing When Opening Older Workbooks
Question details
Users report that Microsoft Excel becomes extremely slow, unresponsive, or crashes entirely when attempting to open historical or older workbook files, typically following a recent system or Microsoft 365 update.
- Product
- Microsoft Excel
- Device & OS
- Windows 11
- Scenario
- Opening historical spreadsheet files (.xls or older .xlsx) after a recent Microsoft 365 or Windows update.
- Observed behavior
- Excel freezes or crashes during the file opening process across multiple user accounts, whereas alternative spreadsheet software can open the same files without issues.
Make sure you have created backup copies of your older workbooks in a separate local folder before performing any repairs, ensuring your historical data remains safe during the troubleshooting process.
Test Excel in Safe Mode and Disable Faulty Add-ins
Running Excel in Safe Mode bypasses custom settings and add-ins, helping you identify if a third-party extension is causing the crash with older files.
Often, legacy add-ins become incompatible after an Office update, conflicting with the rendering engine when older workbooks are accessed.
Press the Windows key + R to open the Run dialog. Type 'excel /safe' and press Enter to launch Excel in Safe Mode.
Use File > Open within Safe Mode to locate and open your older workbook. If it opens smoothly, an add-in is likely the culprit.
Navigate to File > Options > Add-ins. In the 'Manage' dropdown at the bottom, select 'COM Add-ins' and click 'Go'. Uncheck all add-ins, click OK, and restart Excel normally to verify the fix.
Revert to a Previous Microsoft 365 Build
If the freezing started immediately after an update and affects multiple users, rolling back to an earlier stable release is a highly effective workaround until Microsoft releases a patch.
Perform an Online Repair of Office
Repairing the Microsoft Office installation can fix corrupted core application files that may be failing to process legacy workbook components properly.
Open Your Older Workbooks Safely with WPS Office
If Excel is suffering from an unresolved update bug causing it to crash on older files, WPS Office provides a lightweight, highly compatible, and completely free alternative that easily opens historical spreadsheets without freezing.
Frequently Asked Questions
Why does Excel freeze only when opening old files?
Older Excel files (.xls format) rely on legacy rendering components. Recent Microsoft 365 updates can inadvertently introduce bugs that conflict with these legacy components, causing the application to hang or consume excessive system resources when processing them.
Will completely reinstalling Excel fix this freezing issue?
Not necessarily. As reported by multiple IT administrators, if the root cause is a bug in the latest Microsoft 365 build, uninstalling and reinstalling will simply restore the same buggy version. Rolling back to a previous build or using an alternative suite is often a better temporary solution.
How can I update my older workbooks to prevent crashes?
If you can manage to open the files using Excel Safe Mode or via a free alternative like WPS Office, immediately save the file in the modern '.xlsx' format (File > Save As). This updates the internal file structure and typically prevents freezing issues on subsequent attempts.
