Excel Not Responding? How To Fix It

Last updated: August 20, 2026

Most guides to this error start with "open Excel and go to File, Options". That is not much use when the window is grey, the title bar says Not Responding and nothing you click does anything. So this one starts with the frozen window in front of you, then moves on to why it happened and how to stop it happening again.

Excel is frozen right now: the first 90 seconds

Do these in order. Most freezes resolve themselves at step 2 or 3, and the ones that do not are the ones where patience saves your unsaved work.

1. Press Esc. This cancels a long running operation such as a fill, a sort or a paste over a huge range. It is the single most overlooked step.

2. Press Ctrl + Break. On a laptop this is often Ctrl + Fn + Pause or Ctrl + Fn + B. This interrupts a running macro, which is a common cause of an apparently dead window.

3. Look at the bottom left of the Excel window. If the status bar says Calculating: (4 processors) 62%, Excel is not frozen at all. It is working, and the percentage is climbing. Leave it alone. Killing it here throws away the work.

4. Wait two full minutes. A recalculation across a few hundred thousand formulas genuinely takes that long, and Windows labels any window that has not answered for five seconds as Not Responding. Not Responding is often just Windows being impatient.

5. Click once on the Excel window and wait again. Sometimes a hidden dialog box is sitting behind the main window waiting for an answer. Clicking makes Windows flash it.

6. Only now, force quit. Press Ctrl + Shift + Esc to open Task Manager, click Microsoft Excel, then End task. Go straight to the recovery section before you do anything else.

The rule: "Not Responding" in the title bar means Excel has not answered Windows for five seconds. It does not mean Excel has crashed, and it does not mean your work is gone.

How do you fix Excel not responding without closing it?

This is the question most people are actually asking, so here is the honest answer: you cannot repair a frozen Excel from inside itself. Every real fix, disabling add-ins, repairing Office, changing settings, needs a responsive window to click in. What you can do is get the window back without losing the file.

• If it is calculating, it is not frozen. Check the status bar. Wait. When it finishes, immediately press Ctrl + S, then go and apply the fixes below.

• If a macro is running, Ctrl + Break stops it and hands the window back. Excel stays open and your data stays put.

• If a dialog is hidden, press Alt + Tab through your open windows, or Esc to dismiss it. Excel frequently looks dead when it is just waiting on a print dialog or an unsaved-changes prompt.

• If a linked file or network drive is unreachable, Excel can hang for minutes trying to reach it. Disconnecting from the network or VPN often releases it immediately.

• If none of that applies, the window will not come back, and the only route is Task Manager followed by AutoRecover. Waiting longer past about five minutes with no CPU activity in Task Manager almost never helps.

One thing to check in Task Manager before you end the task: if Excel's CPU figure is moving at all, something is still running. Give it more time. A flat 0% for several minutes is the signal that it is genuinely stuck.

How do you recover unsaved work after a force quit?

Excel saves recovery copies in the background by default, so an unplanned close is usually survivable.

1. Reopen Excel. The Document Recovery pane appears down the left side listing any recovered files. Click one to preview it, then use Save As to keep it. Do this before opening anything else, because the pane does not always come back.

2. If the pane does not appear, go to File, then Info, then Manage Workbook, then Recover Unsaved Workbooks.

3. If that comes up empty, browse to the unsaved files folder directly. Paste this into the File Explorer address bar, replacing the placeholder with your Windows username:

C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles

AutoRecover copies live here instead:

C:\Users\YourName\AppData\Roaming\Microsoft\Excel

Check how often AutoRecover is running while you are at it: File, Options, Save. The default is every 10 minutes, which means a crash can cost you 10 minutes of work. Setting it to 2 or 3 minutes costs nothing on a normal file.

The rule: after a force quit, reopen Excel before you do anything else. The Document Recovery pane is offered once, and dismissing it is how people lose work they still had.

How do you properly restart Excel?

Closing the window is not always the same as closing Excel. A hidden background process can keep the file locked and cause the same freeze the moment you reopen it.

1. Press Ctrl + Shift + Esc to open Task Manager.

2. On the Processes tab, look for Microsoft Excel. Click it and choose End task.

3. Scroll down to the Background processes section and check for any remaining EXCEL.EXE entries. End those too.

4. Wait about ten seconds, then reopen Excel.

If a file tells you it is "locked for editing by another user" when you reopen it and you are the only user, that leftover background process is why.

Which fix matches your symptom?

What causes Excel to stop responding?

Add-in interference

Add-ins extend what Excel can do, but a faulty or incompatible one loads with every workbook and can hang the whole application. This is the most common cause of a freeze that happens on every file, including a brand new blank one.

File size and file bloat

Large datasets, thousands of conditional formatting rules, or formatting applied to entire columns rather than the cells in use all inflate what Excel has to hold in memory. A 40 MB file that only contains a few thousand rows of data is almost always bloat rather than data.

Volatile formulas recalculating constantly

NOW, TODAY, RAND, RANDBETWEEN, OFFSET and INDIRECT recalculate every single time anything on the sheet changes. A few hundred of them in a large workbook makes every keystroke trigger a full recalculation.

Outdated or mismatched software

An old Excel build against a current Windows build, or the other way round, produces freezes that no amount of file cleanup will fix.

Antivirus interference

Real time scanning inspects the file on every save. On a large workbook, or one stored on a network share, that inspection is what you experience as the freeze.

Printer and video drivers

Excel queries the default printer to work out page boundaries, so an offline or broken printer driver hangs it on open and on print. Video drivers cause a different pattern: freezing on scroll, with visible tearing or flicker.

Fix 1: Start Excel in Safe Mode

Safe Mode launches Excel with no add-ins, no custom toolbars and no startup files. It is a diagnostic, not a fix: if the problem disappears in Safe Mode, you have proved it is an add-in or a customisation rather than Excel itself.

1. Press Windows + R.

2. Type excel /safe and press Enter.

3. Open the file that was freezing and see whether it still does.

The alternative, if you prefer the mouse: hold Ctrl while you click the Excel icon, and click Yes when Excel asks whether you want to start in Safe Mode.

The rule: if it works in Safe Mode, stop looking at your file. The problem is an add-in.

Fix 2: Disable problematic add-ins

• Open Excel and go to File > Options > Add-ins.

  

• Select COM Add-ins from the Manage drop-down at the bottom and click Go.

  

• Untick every add-in and restart Excel. If the freeze is gone, re-enable them one at a time, restarting between each, until it returns. The last one you switched on is the culprit.

• Repeat the whole process with Excel Add-ins selected in the same Manage drop-down. People check COM add-ins and forget this second list.

Fix 3: Turn off hardware graphics acceleration

This one is not widely known and it resolves a specific and recognisable pattern: Excel freezes when you scroll, cells redraw in the wrong place, or the screen flickers as you move around the sheet.

1. Go to File > Options > Advanced.

2. Scroll to the Display section.

3. Tick Disable hardware graphics acceleration.

4. Click OK and restart Excel.

If the option is not there, your build of Microsoft 365 has removed it, and the equivalent action is updating your graphics driver from the manufacturer's site rather than through Windows Update.

Fix 4: Switch calculation to Manual

If Excel hangs for several seconds every time you type in a cell, it is recalculating the entire workbook on every entry. Turning that off makes a heavy file usable immediately.

1. Go to the Formulas tab.

2. Click Calculation Options.

3. Choose Manual.

4. Press F9 whenever you want to recalculate on purpose.

Remember to set it back to Automatic when you are finished, or you will be looking at stale numbers without realising it. The setting is saved with the workbook, so it follows the file to whoever you send it to.

Fix 5: Update Excel and Windows

• In Excel, go to File > Account > Update Options.

• Select Update Now.

  

• Then update Windows. On Windows 11 go to Settings, then Windows Update. On Windows 10 go to Settings, then Update & Security.

• Restart the computer, not just Excel. Office updates frequently need a reboot to take effect.

Fix 6: Repair Microsoft Office

Use this when Excel freezes on every file including a blank one, and Safe Mode did not help.

1. Open the Control Panel and go to Programs > Programs and Features. On Windows 11 you can also use Settings, Apps, Installed apps, then the three dots next to Microsoft Office and Modify.

2. Select Microsoft Office and click Change.

3. Choose Quick Repair first. It takes a couple of minutes and needs no internet connection.

4. If that does not fix it, repeat and choose Online Repair. This is effectively a reinstall, takes considerably longer, and does need an internet connection. Your files are not affected.

Fix 7: Change the default printer

Excel checks the default printer when opening a workbook to calculate page breaks. If that printer is switched off, unreachable, or has a broken driver, Excel hangs waiting for it.

1. On Windows 11, go to Settings, then Bluetooth & devices, then Printers & scanners. On Windows 10, go to Settings, then Devices, then Printers & scanners.

2. Set Microsoft Print to PDF as the default. It is always available and never offline, which makes it the right test.

3. Turn off Let Windows manage my default printer so it does not switch back.

4. Restart Excel and open the file again.

Fix 8: Repair the file itself

If exactly one workbook freezes and everything else is fine, the file is the problem, not Excel.

1. In Excel, go to File > Open > Browse.

2. Click the file once to select it, but do not open it.

3. Click the small arrow next to the Open button and choose Open and Repair.

4. Choose Repair to recover as much as possible. If that fails, run it again and choose Extract Data, which pulls out the values and drops the formulas.

Another option that often works when Open and Repair does not: open the file, then use Save As and choose a different format such as .xlsb or .csv. Rebuilding the file from scratch drops whatever was corrupted.

Why does Excel keep freezing on the same file?

A file that freezes repeatedly is usually carrying junk it does not need. Four checks, in order of how often they turn out to be the cause.

1. Press Ctrl + End. This jumps to what Excel believes is the last used cell. If your data ends at row 800 but Ctrl + End lands on row 60,000, Excel is storing 59,000 empty formatted rows. Select every row below your data, right-click, choose Delete, then save and reopen the file. The size drop is often dramatic.

2. Check conditional formatting. Go to Home, Conditional Formatting, Manage Rules, and set the scope to This Worksheet. Copying and pasting rows repeatedly splinters one rule into hundreds of near-identical ones. Delete and reapply a single rule across the full range.

3. Look for whole-column references. A formula reading A:A instead of A2:A5000 makes Excel evaluate a million rows. Multiply that by a few hundred formulas and the freeze explains itself.

4. Count your volatile functions. Use Ctrl + F to search the workbook for NOW(, TODAY(, OFFSET( and INDIRECT(. Each one recalculates on every change anywhere in the file.

The rule: if the file is far bigger than its data justifies, the problem is formatting and used range, not the data.

What if Excel will not open at all?

Different symptom, different fixes. Nothing appears, or the splash screen shows and then vanishes.

• Check Task Manager first with Ctrl + Shift + Esc. A leftover EXCEL.EXE in Background processes will block a new instance from starting. End it and try again.

• Try Safe Mode with excel /safe from the Run box. If it opens in Safe Mode, an add-in or a file in the XLSTART folder is loading at startup and crashing it.

• Clear the startup folder. Paste this into the File Explorer address bar and move anything you find out to the desktop:

C:\Users\YourName\AppData\Roaming\Microsoft\Excel\XLSTART

• Turn off Protected View temporarily if it hangs only on files from email or the internet. File, Options, Trust Center, Trust Center Settings, Protected View.

• Run an Online Repair if none of the above changes anything.

What about Excel on a Mac?

The causes are the same, the commands are not.

How do you stop it happening again?

1. Shorten the AutoRecover interval. File, Options, Save, then set it to 2 or 3 minutes instead of the default 10. This does not prevent a freeze but it caps what one costs you.

2. Keep Excel and Windows updated, and restart the machine after Office updates rather than just closing Excel.

3. Review your add-ins every few months. Disable anything you no longer use rather than leaving it loading on every launch.

4. Keep the used range tight. Format the cells you are using, not entire columns, and delete unused rows properly rather than just clearing their contents.

5. Limit volatile formulas. Replace OFFSET with INDEX, and INDIRECT with a structured table reference, wherever you can.

6. Work on files locally. Copy a workbook off a network drive or a syncing OneDrive folder before doing heavy editing, then copy it back.

7. Adjust your antivirus settings so Excel processes and your working folder are excluded from real time scanning.

8. Split genuinely huge workbooks across several files, or move the data into Power Query and keep only the summary in the workbook.

Microsoft's own guide to Excel not responding, hangs, freezes or stops working covers the same ground from the support side, including the advanced troubleshooting steps that go beyond this article.

Frequently asked questions

How do I fix Excel not responding without closing it?

Press Esc to cancel a long operation and Ctrl + Break to stop a running macro, then check the status bar. If it reads Calculating with a percentage, Excel is working rather than frozen and will come back on its own. If nothing responds after five minutes with no CPU activity, Task Manager is the only remaining option.

Will I lose my work if I force quit Excel?

Usually not. Excel keeps AutoRecover copies in the background, and reopening it presents a Document Recovery pane listing what it saved. If the pane does not appear, use File, Info, Manage Workbook, Recover Unsaved Workbooks.

Why does Excel keep freezing on the same file?

The file is almost always carrying an inflated used range. Press Ctrl + End: if it jumps thousands of rows past your data, delete those empty rows, save and reopen. Splintered conditional formatting rules and whole-column formula references cause the same thing.

How do I restart Excel properly?

Press Ctrl + Shift + Esc, end the Microsoft Excel task, then scroll to Background processes and end any leftover EXCEL.EXE entries too. Wait ten seconds before reopening, or the old process will keep the file locked.

Is it safe to run Excel in Safe Mode?

Yes. Safe Mode simply starts Excel without add-ins, custom toolbars or startup files. It changes nothing in your files and is the fastest way to prove whether an add-in is behind the freeze.

Why does Excel freeze when opening large files?

Excel loads the whole workbook into memory, including formatting applied to empty cells. A file that is large because of formatting rather than data will freeze on open. Check the used range with Ctrl + End and set calculation to Manual before opening the next one.

Final thoughts

The order matters more than the individual fixes. Get the window back or recover the file first, prove whether it is Excel or the file second with Safe Mode, then apply the fix that matches your symptom. Guessing your way down a list of settings changes is how a ten minute problem becomes an afternoon.

For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles below.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials.

Related Articles

How to Subtract Dates in Excel

How to Spell Check in Excel

How to Add Axis Labels in Excel

Excel Formulas Not Calculating