Fix Excel Becoming Unresponsive During Simple Workbook Operations
Question details
The user needs to troubleshoot an Excel workbook that freezes or takes too long during basic operations.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or working with an Excel workbook and performing simple actions.
- Observed behavior
- Excel stops responding or takes an excessive amount of time to complete basic actions.
Note the Excel version, workbook size, and exact action that causes the freeze. Check whether the same action is slow in a new workbook; the Windows-specific steps below may differ on other systems.
Test Excel add-ins in Safe Mode
Use Safe Mode to check whether an add-in or startup customization is contributing to the freeze.
On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and repeat the action that usually freezes.
If Excel responds normally in Safe Mode, restart it normally and go to File > Options > Add-ins. Select COM Add-ins in the Manage box, choose Go, and clear the enabled add-ins.
In File > Options > Add-ins, select Excel Add-ins in the Manage box, choose Go, and clear the enabled add-ins.
Close and reopen Excel, then repeat the problem action. If performance improves, re-enable add-ins one at a time from the same Add-ins settings to identify the cause.

Reduce workbook calculation and formatting load
Use these checks when the issue appears tied to a particular workbook or persists with add-ins disabled.
Update and repair Microsoft Office
Use these checks if multiple workbooks are slow or the earlier tests do not identify the cause.
Work with Excel-compatible files in WPS Spreadsheets
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working while you investigate the Microsoft Excel issue.

Frequently Asked Questions
How do I tell whether an Excel add-in is causing the freeze?
On Windows, press Windows+R, run excel /safe, and repeat the action. If Excel works normally, disable COM and Excel add-ins under File > Options > Add-ins, then re-enable them one at a time.
Why is only one workbook slow in Excel?
A specific workbook may contain extensive formulas, external links, conditional formatting, hidden objects, or damaged content. Test a copy and review these items before trying File > Open > Browse > Open and Repair.
Will changing Excel to manual calculation affect my formulas?
Yes. Formula results may not update automatically. Press F9 to recalculate, and restore Formulas > Calculation Options > Automatic after your test.
What information should I collect if Excel keeps freezing?
Record the Excel version, operating system, workbook size, and exact action that triggers the freeze. On Windows, also check Event Viewer > Windows Logs > Application for relevant errors.




