How to Fix Excel Freezing or Locking Up on Every Workbook
Question details
The user needs to resolve a persistent issue where Excel freezes or becomes unresponsive whenever any workbook is opened.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening, editing, or interacting with multiple different workbooks in Excel.
- Observed behavior
- The Excel application completely freezes, hangs, or locks up regardless of which file is opened, even after performing a standard Office repair.
Save your work in other applications and ensure you have administrative permissions on your Windows account before modifying application startup folders or system printer settings.
Start Excel in Safe Mode and Disable Add-ins
Use Safe Mode to bypass third-party extensions, allowing you to identify and disable any problematic add-ins causing Excel to freeze.
Often, conflicting third-party add-ins are the primary reason Excel locks up on all workbooks. Starting the application in Safe Mode forces it to load without these add-ins.
Press and hold the 'Ctrl' key on your keyboard, then double-click the Excel shortcut. Click 'Yes' when prompted to start in Safe Mode.
Open a few workbooks while in Safe Mode. If the freezing stops, an add-in is the likely culprit.
Navigate to 'File' > 'Options' > 'Add-ins'. At the bottom of the window, ensure the 'Manage' dropdown is set to 'COM Add-ins' and click 'Go'.
Uncheck all add-ins in the list and click 'OK'. Restart Excel normally and re-enable them one by one to pinpoint the add-in causing the application to freeze.

Clear the Excel Startup Folder
Remove temporary or corrupted files stored in the Excel startup directory that load automatically and cause the application to hang.
Change the Default Windows Printer
Switch your default printer to a virtual driver to prevent Excel from freezing while querying physical printer drivers for page layouts.
Use WPS Office to Edit Spreadsheets Without Freezing
If Microsoft Excel continues to freeze or lock up despite your troubleshooting efforts, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet editor that works seamlessly with your existing workbooks without overwhelming your system resources.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the Software: Run the installer and follow the on-screen prompts to set up WPS Office on your Windows device.
- 3. Open Your Workbooks: Launch WPS Spreadsheet and safely open your existing Excel files without experiencing freezing or crashing.

Frequently Asked Questions
Why does Excel freeze when I open any workbook, even a blank one?
This usually points to an application-level conflict rather than file corruption. Common causes include outdated or incompatible COM add-ins, corrupted files in the Excel startup folder, or problems communicating with the default printer driver.
How do I know if an add-in is causing Excel to hang?
You can isolate add-in issues by launching Excel in Safe Mode (hold the Ctrl key while clicking the Excel shortcut). If the application runs smoothly in Safe Mode, a third-party add-in is likely causing the freeze.
Will repairing Microsoft Office fix persistent freezing issues?
An Online Repair can fix corrupted program files, but it often does not resolve freezing caused by third-party add-ins or printer driver conflicts. If a repair fails, you must manually disable add-ins or clear the startup folder.
Why does changing my default printer stop Excel from locking up?
When Excel launches and opens a workbook, it immediately queries the default printer to render the spreadsheet's page margins and print layout. If the network printer is offline or the driver is faulty, Excel will hang indefinitely waiting for a response.




