Excel Not Responding? How to Fix It (and Save Your Work)

When Excel says “Not Responding”, it is usually busy with something heavy (a big calculation, a large file, a slow save to a network drive) or something is clashing with it (an add-in, an outdated Office build, antivirus software) 😫

Here is the quick version, in the order I would try it:

1. Wait a minute and look at the status bar. If Excel is calculating or saving, let it finish and don’t click around.
2. Force-close Excel in Task Manager (Ctrl+Shift+Esc) if it is truly frozen. When you reopen it, Document Recovery can offer your unsaved work.
3. Start Excel in safe mode (hold Ctrl while you open Excel). If it works there, an add-in is the likely cause.
4. Disable add-ins under File > Options > Add-ins, then turn them back on one at a time.
5. Repair Office with Quick Repair (or Online Repair).
6. Update Office under File > Account > Update Options > Update Now.
7. Fix the file itself if only one workbook freezes: whole-column formulas, volatile functions, heavy conditional formatting and external links are the usual suspects.

Below, I’ll walk you through every fix step by step 🔨

First: wait and check what Excel is doing

“Not Responding” does not always mean Excel has crashed. Very often it is still working on something: recalculating a big workbook, opening or saving a large file, refreshing data, or running a macro.

So before you close anything:

• Give it a minute or two. Clicking around in a busy Excel window only queues up more work.
• Look at the status bar at the bottom of the window. If you see a progress message (for example Calculating or Saving), let the current task finish before you do anything else.
• Check other open programs. Another app (or another Excel window) may be using Excel in the background. Let it finish, then try again.
• Save as soon as Excel responds again (Ctrl+S), so you don’t lose your work if it freezes a second time.

If Excel keeps freezing the moment you type or change a cell, switch calculation to manual (Formulas tab > Calculation Options > Manual). Excel then only recalculates when you press F9, which gives you time to save and fix the slow formulas. Read more in my guide to recalculating and refreshing formulas.

Still nothing after a few minutes? Then it is time to close Excel.

Force-close Excel if it is truly frozen

If Excel is stuck and you can’t close it the normal way, close it from Task Manager.

Open Task Manager with the Ctrl+Shift+Esc shortcut and find Microsoft Excel in the list of processes.

Right-click it and select “End task”.

Unsaved changes since your last save (or AutoRecover save) can be lost, so only do this when waiting doesn’t help. When you open Excel again, check the Document Recovery pane (see how to recover unsaved work below).

On a Mac, press Option+Command+Esc and force quit Microsoft Excel.

For more ways to close a frozen Excel (Alt+F4, Command Prompt and Windows Settings), see my guide on how to force quit Excel on Windows.

Start Excel in safe mode

If Excel freezes again right after you reopen it, the cause is often something that loads together with Excel, such as:

• Excel add-ins or COM add-ins, or
• Add-ins from other software, such as antivirus programs.

In such situations, opening Excel in safe mode is the best test 🦺

When you open Excel in safe mode, Excel starts without add-ins and other extras that normally load automatically.

To start it, press and hold Ctrl while you double-click the Excel shortcut, then click Yes. Or press Windows key + R, type excel /safe and click OK.

If Excel works fine in safe mode, an add-in (or something else that loads at startup) is the likely cause. Close Excel, start it normally, and disable add-ins as shown below.

Disable add-ins

Did Excel work properly in safe mode?

Then the not responding error is most likely caused by an add-in. You can disable Excel add-ins until you find the one causing it 🔒

To disable add-ins, follow these steps.

1. Go to the File tab.

2. Select Options.

3. Go to Add-ins in Excel Options.

4. In the Manage box, select Excel Add-ins (or COM Add-ins) and click Go.

5. Clear the check boxes next to the add-ins you want to disable. Then click OK.

Close Excel and start it again normally. Sometimes you have to restart Excel before disabled add-ins disappear from the ribbon.

Start by disabling all COM add-ins (Microsoft’s own troubleshooting article starts there), then all Excel add-ins.

If that fixes Excel, turn the add-ins back on one at a time, restarting Excel after each one, until you find the one causing the issue.

Tip: in the same Manage box you’ll also find Disabled Items. That is where Excel lists add-ins it has already switched off after a problem.

Repair Microsoft Office

Sometimes Excel stops responding because files in the Office installation are damaged.

Then the solution is to repair Microsoft Office ⚒️ This repairs the whole Office suite, not just Excel.

To repair Office, follow these steps.

1. Type “Control Panel” in the Windows search bar.

2. Select Control Panel to open the Control Panel window.

3. Click Uninstall a program under Programs.

4. Select Microsoft 365 and click Change.

5. Select Quick Repair.
6. Click Repair.

Quick Repair is the fastest option: it detects and replaces corrupted files. If Excel still freezes afterwards, run the repair again and choose Online Repair, which is more thorough and takes longer.

On Windows 11 you can also start the repair from Settings: right-click the Start button, select Installed apps, click the three dots next to Microsoft 365 and select Modify.

After the repair is completed, you may have to restart your computer.

Update Excel

Excel sometimes stops responding because of bugs that Microsoft has already fixed in a newer build.

So make sure you run the latest version 🧑🏻‍💻 Here is how to update Excel on Windows.

1. Go to the File tab.

2. Select Account.

3. Expand Update Options.

4. Click “Update Now”.

If you don’t see Update Now, click Enable Updates first.

It is also a good idea to install the latest Windows updates.

On a Mac, go to Help > Check for Updates in Excel.

Fix a slow or heavy Excel file

Does Excel only stop responding in one particular workbook? Then the problem is most likely inside the file itself 🐌

These are the most common causes:

• Formulas that reference entire columns, especially array formulas and SUMPRODUCT (for example A:A instead of A2:A5000). They can force Excel to calculate a million rows, empty cells included.
• Many volatile functions. OFFSET, INDIRECT, TODAY, NOW, RAND, CELL and INFO recalculate every time Excel recalculates anything.
• Heavy conditional formatting and data validation. Every visible conditional formatting rule is evaluated at each calculation.
• External links to other workbooks. They are slow, easily broken and hard to track down.
• A bloated used range. Press Ctrl+End on each sheet. If Excel jumps far beyond your data, the extra rows and columns can slow the file down.
• Thousands of styles, shapes or hidden objects, often from copying and pasting between workbooks.
• Circular references with iterative calculation turned on.
• Large pictures and unnecessary data or formatting.

To make the file work properly again, try the following.

• Switch to manual calculation while you clean up (Formulas tab > Calculation Options > Manual).
• Use only the cell ranges you need, or use Excel tables so ranges grow with your data. For example, with XLOOKUP, select only the relevant cells for the lookup and return arrays.
• Replace volatile functions where you can (for example, INDEX instead of OFFSET).
• Delete conditional formatting rules you don’t need (Home > Conditional Formatting > Manage Rules).
• Find external links and break the ones you no longer need.
• Delete unused rows and columns below and to the right of your data, then save the file (make a backup copy first).
• Find and remove circular references.
• Remove invalid defined names and unnecessary sheets.
• Compress pictures inside your workbook.
• Don’t save Excel files in Page Break Preview. Excel checks the default printer when it opens a file, and this view can slow it down.
• Copy the file to your own computer and open it from there. Files on network drives, SharePoint or redirected folders can make Excel hang while opening or saving.

Still freezing? Startup files, antivirus and printer

If none of the fixes above worked, check these less common causes from Microsoft’s troubleshooting guide:

• Files that open automatically. Excel opens every file in the XLStart folder at startup. Find the path under File > Options > Trust Center > Trust Center Settings > Trusted Locations, move the files somewhere else, and restart Excel. Also check File > Options > Advanced > General > “At startup, open all files in”.
• Antivirus software. Update your antivirus program. An antivirus add-in that integrates with Excel can conflict with it, so check the COM add-ins list. Ask your antivirus vendor before changing any settings.
• Printer or video driver. Excel checks the default printer and video driver when it starts. As a test, set Microsoft XPS Document Writer as your default printer.
• Files created by other programs. If a file exported from another program freezes Excel, test the same steps in a new workbook created in Excel.
• Too little memory. Close other programs, especially when you work with large files.

How to recover unsaved work after Excel freezes

Had to force-close Excel before you could save? Don’t panic. Excel saves AutoRecover information in the background, so there is a good chance you can get most of your work back 😊

• Document Recovery. When Excel closes unexpectedly, the Document Recovery pane opens the next time you start Excel. Open the newest version of your file and save it right away.
• Never saved the workbook? Go to File > Info > Manage Workbook > Recover Unsaved Workbooks.
• Saved before, but lost recent changes? Open the file, go to File > Info and look under Manage Workbook for a version marked “(when I closed without saving)”.
• File won’t open after the crash? Go to File > Open > Browse, select the file, click the arrow next to Open and choose Open and Repair.

Read my full guide on how to recover unsaved Excel files for all the methods.

To protect yourself next time, store your files in OneDrive or SharePoint and keep AutoSave on (here is how AutoSave works).

That’s it! Now what?

Nice going! Now you know why Excel stops responding and how to fix it 😀

You also learned that slow, heavy formulas are one of the most common causes.

So it’s really important to learn how to build your formulas correctly and efficiently.

If you want to learn Excel functions the right way, then join my 30-minute free online course where I send you free, quick, and practical lessons about the IF, SUMIF, and VLOOKUP functions.

Get more work done in less time by learning these powerful Excel functions 🚀

Join this Excel training that helped +100,000 people and more 🤗

Other resources

Have you lost your Excel file due to Excel not responding error? 😢

Quickly read our article about How to Recover Unsaved Excel Files (4 Free Methods) so you can easily recover your lost files.

You can minimize the Excel not responding issue by reading about How to Find Circular References in Excel and How to Reduce Excel File Size.

Be Excel-wise! 🧐 Read our Full List of ALL Excel Errors and How to Fix Them article.

Frequently asked questions

Will Excel recover from not responding?

Yes, in most cases.

If Excel is busy with a heavy calculation or a large file, it usually comes back on its own when the task is done. If it is still frozen after a few minutes, force-close it and work through the fixes above.

If the file itself is corrupted, use File > Open > Open and Repair, or go back to a backup or an earlier version.

Why is Excel constantly not responding?

When Excel keeps freezing in every file, the usual causes are add-ins, an outdated or damaged Office installation, antivirus integration or too little memory. Start Excel in safe mode, disable add-ins, then repair and update Office.

When it only happens in one file, the file is the problem: whole-column formulas, volatile functions, heavy conditional formatting or external links.

How do I save my work when Excel is not responding?

You can’t save while Excel is frozen, so wait first. If it starts responding again, press Ctrl+S right away.

If you have to force-close it, reopen Excel and use the Document Recovery pane, or File > Info > Manage Workbook > Recover Unsaved Workbooks.

How do I restart Excel when it is frozen?

Press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel and click End task. Then open Excel again. On a Mac, press Option+Command+Esc and force quit Excel.

Why does Excel stop responding when I save or open a file?

Large files, files stored on a network drive or SharePoint, and workbooks that recalculate on open can all make Excel hang. Copy the file to your computer and open it from there. If the file opens slowly, setting calculation to manual before you open it can help.