What to do When Excel Is Not Responding
- Aug 1
- 3 min read
Updated: Aug 6
When Excel freezes and shows "Not Responding" in the title bar, it can feel like everything you were working on is about to disappear.
Contents:
Quick Answer
When Excel shows "Not Responding," it means the program's main thread is busy and can't accept new input. This is almost always caused by a heavy calculation, a very large file, or a problem add-in. In most cases, waiting 30-60 seconds is enough for Excel to finish and come back on its own.
Why Excel Stops Responding
Heavy Calculations or Large Files
Excel runs calculations on a single thread by default. If you paste a large block of data, open a file with thousands of complex formulas, or trigger a workbook-wide recalculation, Excel locks the UI while it works. The "Not Responding" label doesn't mean it has crashed, it means it's busy.
Volatile functions like RAND, OFFSET, and INDIRECT recalculate every time anything in the workbook changes, which can compound the problem on large sheets.
Add-Ins Causing a Conflict
COM add-ins and third-party plugins run inside the Excel process. A poorly written or outdated add-in can hang Excel completely, especially on startup or when opening a specific file type.
The File Is Corrupt
A damaged .xlsx file can cause Excel to freeze during the open or save process. This is more common with files that have been passed around many times, or that were saved improperly after a previous crash.
How to Fix Excel When It Is Not Responding
Wait It Out First
Before doing anything drastic, give Excel a full minute. If a large calculation is running, the status bar at the bottom of the window will show "Calculating: X%" while it works. Let it finish. Forcing a close mid-calculation can corrupt the file.
Disable Add-Ins
If Excel freezes every time you open it, a bad add-in is the most likely cause. To check, open Excel in Safe Mode first by holding Ctrl while you click the Excel icon. Safe Mode loads Excel without any add-ins.
If Excel opens fine in Safe Mode, one of your add-ins is the problem. Go to File > Options > Add-Ins, select COM Add-ins from the Manage dropdown, and click Go. Uncheck them one at a time to find the culprit.
Repair the File
If a specific file always causes a freeze, try letting Excel repair it on open. Go to File > Open, browse to the file, click the small dropdown arrow next to the Open button, and choose Open and Repair.
Recover Unsaved Work
If you had to force-close Excel, go to File > Info > Manage Workbook and look for any autosaved versions. Excel's AutoRecover feature saves a temporary copy every 10 minutes by default, so you likely haven't lost everything.
How to Stop Excel From Freezing Again
A few habits that help going forward:
Set calculation to Manual (Formulas > Calculation Options > Manual) on large files, and press F9 to calculate only when you're ready.
Replace volatile functions with non-volatile alternatives where possible. OFFSET, for example, can often be replaced with INDEX.
Keep add-ins to only the ones you actively use.
Save files locally rather than directly to a network drive or SharePoint, which adds latency to every save operation.
If your workbook has grown large enough that freezes are routine, it may be worth splitting the data across multiple files and using linked workbooks to connect them.
Comments