How to Fix Excel Freezing When Multiple Workbooks Are Open
Question details
The user is trying to resolve an issue where Excel becomes unresponsive when multiple workbooks are open and only temporarily unfreezes when pressing Enter or switching to another workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working simultaneously across multiple open Excel workbooks.
- Observed behavior
- Excel freezes and stops responding to clicks or inputs. Pressing the Enter key or switching windows restores responsiveness temporarily.
Before attempting to repair your Office installation, press Ctrl + S in your active workbook to save any recent changes, and ensure you have your Microsoft Office account credentials handy in case you need to sign in again after the repair.
Repair Microsoft Office via Control Panel
Use the built-in Windows repair tool to fix underlying corruption in the Microsoft Office installation that may be causing Excel to freeze.
This freezing issue is often caused by missing or corrupted Microsoft Office installation files. Running the built-in repair tool can safely fix these system files without deleting your personal workbooks or data.
You can choose between a Quick Repair or an Online Repair. It is highly recommended to start with a Quick Repair, and if the issue persists, proceed with the Online Repair.
Click the Windows Start menu, type 'Control Panel' in the search bar, and press Enter to open it.
Under the 'Programs' section, click on 'Uninstall a program' to view the list of installed applications on your computer.
Scroll down the list, locate 'Microsoft Office' (or Microsoft 365), select it, and click the 'Change' button at the top of the window.
Select 'Quick Repair' from the prompt and click 'Repair'. Follow the on-screen instructions. Once completed, restart your computer and test if Excel still freezes.

Install the Latest Office Updates
Ensure your Microsoft Office suite is fully up to date, as Microsoft frequently releases patches to fix known performance bugs and freezing issues.
Experience Stable Spreadsheet Editing with WPS Office
If Microsoft Excel continues to freeze or lock up on your computer, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative designed to handle multiple complex workbooks smoothly without performance drops.
- 1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open Your Workbooks: Launch WPS Spreadsheets and directly open your existing .xlsx files without needing any format conversion.
- 3. Work Without Freezes: Open multiple spreadsheets simultaneously within WPS Office's intuitive tabbed interface and enjoy lag-free performance.

Frequently Asked Questions
Why does Excel randomly freeze when I switch between workbooks?
This can happen due to high CPU usage from complex formulas, incompatible third-party COM add-ins, or corrupted Microsoft Office installation files. Ensuring your software is up to date and running an Office Repair usually resolves this.
Will repairing Microsoft Office delete my Excel files?
No, repairing Microsoft Office through the Control Panel only replaces or fixes the core application files. It does not affect, modify, or delete your personal workbooks, documents, or data.
How do I know if an Add-in is causing Excel to freeze?
You can isolate the issue by launching Excel in Safe Mode (hold the Ctrl key while opening Excel). If Excel operates smoothly with multiple workbooks open in Safe Mode, a third-party Add-in is likely the culprit. You can then disable them one by one via File > Options > Add-ins.
What is the difference between Quick Repair and Online Repair?
Quick Repair runs fast without needing an internet connection, fixing mostly minor local corruption issues. Online Repair takes longer and requires an active internet connection, as it thoroughly downloads and reinstalls Office components to fix deeper system issues.




