Excel Not Responding? Causes and Fixes

How-to basics · Updated November 19, 2026

If Excel says Not Responding, it may be temporarily busy calculating, opening a large file, or waiting on an add-in or network connection—or it may genuinely be stuck. Wait briefly before closing it, then try to save if the window responds; if the problem persists, use the troubleshooting steps below to protect your work and isolate the cause.

What the Not Responding message means

In Windows, the message usually means Excel is not currently responding to Windows messages, such as clicks or requests to redraw the window. It does not by itself prove that Excel has crashed. A demanding operation can temporarily occupy Excel, making the interface appear frozen even while the application is working.

For example, Excel may need time to recalculate formulas after a large paste, refresh a data connection, open a workbook with many sheets, or process a pivot table. The status bar or a progress indicator may show activity. A slow or unresponsive window that eventually recovers is different from one that remains frozen indefinitely.

Excel for Microsoft 365 on Windows is the focus here. On a Mac, the app may show a spinning wait cursor or an application-not-responding alert rather than the same Windows message. The underlying causes—heavy calculations, add-ins, damaged files, and resource limits—can still be similar.

What to do before closing Excel

Give Excel a short period to finish, particularly if you just started a calculation, import, refresh, or save. Repeatedly clicking the window or launching more copies of Excel will not make the operation finish sooner. If the workbook is large or stored online, wait longer than you would for a small local file.

Check whether other programs and Windows are responsive. If only Excel is affected, the issue is more likely to involve the workbook, Excel, or an add-in. If the whole computer is sluggish, available memory, storage activity, or another system-wide problem may be contributing.

  • If Excel recovers, save a new copy with File > Save As before trying more troubleshooting. This gives you a fallback if the next operation causes another freeze.
  • If the window responds but a calculation is taking a long time, press Esc once to try to interrupt it. This will not cancel every operation, and it is not a substitute for waiting during a save or file repair.
  • If Excel remains frozen, avoid ending the task immediately if the workbook contains unsaved changes. Closing the process can discard those changes.
  • If Windows offers to wait for the program or close it, choose to wait first when you suspect a calculation or refresh is still underway.

Recover work after Excel stops responding

If you have to close Excel, reopen it and look for the Document Recovery pane. Excel may offer versions recovered from AutoRecover or from an unexpected shutdown. Open the most recent plausible version, check that it contains the work you need, and save it under a new name.

You can also check File > Info for workbook management and recovery options. Depending on the workbook and whether it was saved before, the options may include recovering unsaved workbooks. The exact recovery choices depend on Excel’s settings and the circumstances of the shutdown, so recovery is not guaranteed.

AutoSave and AutoRecover are different. AutoSave can save ongoing edits automatically for eligible files stored in OneDrive or SharePoint when the feature is on. AutoRecover periodically saves recovery information; it is not a promise that every last edit will be restored. For important work, save regularly and keep a separate backup copy. Do not overwrite a known-good file until you have checked the recovered version.

Start Excel in Safe Mode and check add-ins

An add-in can interfere with startup, workbook operations, or Excel’s interface. Safe Mode starts Excel with certain customizations and add-ins bypassed, making it a useful diagnostic test. It does not repair a workbook or permanently remove add-ins.

  1. Close Excel. Press Windows key + R to open the Run dialog.
  2. Type excel /safe and press Enter. If Excel opens, try the same workbook or a copy of it.
  3. If Excel behaves normally in Safe Mode, disable add-ins and restart normally to test. In Excel, go to File > Options > Add-ins.
  4. At the bottom, select COM Add-ins next to Manage, then select Go. Clear an add-in’s checkbox and select OK. You can re-enable it later if it is not the cause.
  5. Repeat the test with other enabled add-ins if needed. Change one at a time so you can identify which setting affects the problem.

Some add-ins are managed differently, so look at the Manage list that matches the add-in type. If Excel still freezes in Safe Mode, an add-in is less likely to be the cause, although this test cannot rule out every configuration issue. On Mac, Windows’ excel /safe command does not apply; review Excel’s add-ins in the app’s settings or preferences instead.

Check whether the workbook is the cause

If only one workbook triggers the problem, test a copy rather than assuming the entire Excel installation is broken. A workbook can be slow because it contains extensive formulas, large data ranges, external links, embedded objects, macros, or complex formatting. A file stored on a network share or in a cloud-synced folder can also be delayed by connectivity or synchronization.

  • Open a blank workbook. If it works normally while the problem file does not, focus on that file and its contents.
  • Make a copy of the workbook and open the copy from a local folder. If it opens more reliably, the storage location, network, or sync process may be involved.
  • If the workbook opens, try disabling automatic calculation temporarily only if you understand the consequences: File > Options > Formulas > Workbook Calculation. Set it back to Automatic when appropriate. In Manual mode, formula results may not update until you recalculate.
  • For files that refresh external data, look at Data > Queries & Connections. A slow source or refresh can make Excel appear unresponsive while it waits for data.
  • If the file is important and continues to fail, use a separate copy and consider Excel’s Open and Repair option from the Open dialog. Repair may not preserve every workbook feature.

A workbook can also be large without being corrupt. For instance, a sheet with formulas copied far beyond the actual data can require much more calculation than expected. Removing unnecessary content may help, but first make a backup and verify what is safe to remove.

Check system resources, updates, and installation

Excel needs available memory and processing time to open and calculate workbooks. Large datasets, many open workbooks, other demanding applications, or limited free disk space can make the whole process slower. Close programs you do not need and restart the computer if it has been running for a long time. A restart can clear temporary resource pressure, but it will not fix a persistent workbook or add-in problem by itself.

In Windows, Task Manager can help distinguish a busy process from an idle one. Press Ctrl + Shift + Esc and look at Excel’s CPU, memory, and disk activity. Resource use is only a clue: high activity may mean Excel is working, while low activity does not prove that it is safe to end the task. On Mac, Activity Monitor provides similar process information; open it from Applications > Utilities.

Install available Microsoft 365 and Windows updates after saving your work. Updates can address compatibility and reliability issues, although an update is not a guaranteed fix for a specific workbook. If Excel continues to fail across multiple files, repair Microsoft 365 in Windows Settings: open Apps > Installed apps, select Microsoft 365, choose Modify, and follow the options for Quick Repair or Online Repair if they are available. Online Repair may take longer and require an internet connection. The labels can vary slightly by Windows version and installation type.

When to end the task—and what to avoid

End Excel from Task Manager only when it has remained unresponsive and waiting is no longer practical, or when you need to recover the computer. Select Microsoft Excel and choose End task. Unsaved changes in that Excel process may be lost, and any recovery information may be incomplete. After reopening, check for Document Recovery before continuing.

Do not repeatedly force-quit Excel during a save, a repair, or a data refresh unless there is a strong reason to believe it will not finish. Interrupting file activity can leave you uncertain about which changes reached disk. If a workbook is stored on OneDrive or SharePoint, check its sync status before editing the same file from another device; simultaneous edits or a sync conflict can complicate recovery.

Also avoid downloading unofficial registry fixes or tools that claim to repair any Excel freeze automatically. The symptoms can have different causes, and an unknown tool may introduce security or data-loss risks. Prefer a copy of the file, built-in recovery options, Safe Mode, and official Microsoft 365 repair tools.

How to reduce future freezes

Prevention is mostly about reducing avoidable work and making recovery easier. Save important files in a location with reliable backups, keep Excel and Windows current, and remove add-ins you do not use. For shared workbooks, check that the network or cloud service is connected before starting a large refresh.

  • Keep formulas and formatting limited to the rows and columns you actually use; unnecessarily large ranges can increase calculation work.
  • Refresh external data when you need it rather than repeatedly starting overlapping refreshes.
  • Close unused workbooks and applications when working with a large dataset.
  • Save a separate copy before extensive edits, file repair, or changes to calculation settings.
  • If one workbook is consistently slow, make a copy and test its data connections, formulas, add-ins, and storage location separately.

These steps will not prevent every freeze, particularly when a file or data source is inherently demanding. They do make it easier to identify whether the problem follows Excel generally, a particular workbook, or a particular environment—and reduce the cost of an unexpected shutdown.

Frequently Asked Questions

How long should I wait when Excel says Not Responding?
There is no fixed timeout. Give it several minutes if it has just begun a large calculation, import, refresh, or save, and look for signs of activity. If it remains frozen and the computer is otherwise responsive, use the recovery and diagnostic steps above rather than waiting indefinitely.

Will I lose my work if I close Excel?
Unsaved changes can be lost when Excel is forced to close. After reopening, check the Document Recovery pane and the recovery options under File > Info, but do not assume every edit will be available. Save recovered work as a new file.

Why does Excel freeze when opening only one file?
That points toward something specific to the workbook or its location, such as heavy formulas, links, data connections, macros, file damage, or a slow network or sync service. Test a copy locally and compare it with a blank workbook before changing the original.

Does Excel Safe Mode delete my add-ins?
No. Safe Mode is a temporary diagnostic startup. If Excel works there, you can disable add-ins through File > Options > Add-ins and test them individually. Re-enable an add-in if it is not responsible.

Why does Excel keep saying Not Responding during calculation?
Excel may be recalculating many formulas or processing a large range, especially after edits that affect dependent cells. Wait for the operation to finish, and consider reviewing workbook size and calculation settings. If you switch calculation to Manual, remember that results may become out of date until recalculated.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.