Excel Often Not Responding? Causes, Fixes, and Prevention

How-to basics · Updated November 21, 2026

If Excel often shows Not Responding, it may be busy recalculating a workbook, waiting on an add-in, or struggling with a file or system resource—not necessarily crashed. On Windows, give it a short time to finish, protect any unsaved work, then use Safe Mode and a few targeted checks to identify the cause before forcing Excel to close.

What Not Responding means in Excel

Windows displays Not Responding when an app is not replying to Windows messages promptly. In Excel, this can happen while the program performs demanding work, such as recalculating formulas, opening a large file, refreshing a query, or loading an add-in. The message alone does not prove that the workbook is damaged or that Excel has permanently stopped.

Look for signs of activity before taking action. A changing progress indicator, a busy status bar, or a return to normal after a wait suggests Excel may be working. A long pause with no visible progress can indicate a hang, but there is no universal waiting time: a large model or data refresh may take considerably longer than a small sheet. Repeatedly clicking the window or opening more copies of the file can make troubleshooting harder.

If the workbook contains unsaved changes, avoid ending the task immediately. When Excel becomes responsive, save a copy under a new name before continuing. If Windows asks whether to wait or close the program, waiting is the safer first choice when you can afford to give the operation more time.

First checks before closing Excel

Try simple checks that do not alter the workbook. Confirm that Excel is not displaying a hidden dialog box: press Alt+Tab to cycle through open windows and look for a prompt about links, file formats, or a password. A dialog waiting for input can make the main workbook appear stuck. Also check whether another application or a network location is delaying access to a linked file.

If the window remains unresponsive, use Windows Task Manager to see whether Excel is still running and how much CPU or memory it is using. Press Ctrl+Shift+Esc, find Microsoft Excel in the Processes list, and check its resource use. These readings are clues, not a diagnosis: low CPU use does not by itself prove Excel is frozen, and high use may simply mean it is calculating.

  • Wait briefly if Excel is opening, saving, calculating, or refreshing data.
  • Check for a hidden Excel dialog with Alt+Tab.
  • Avoid launching repeated copies of the same workbook while the first one is busy.
  • If you must end the task, understand that changes since the last save may be lost. Reopen Excel afterward and check for Document Recovery files.

Excel may offer recovered versions after an unexpected shutdown, but recovery is not guaranteed. AutoRecover stores recovery information at intervals; it is not the same as saving every change. For work stored in OneDrive or SharePoint, AutoSave can save changes continuously when enabled and available, but it does not remove the need to verify that the file has finished saving.

Common causes of recurring freezes

A recurring Not Responding message is often tied to a particular workbook or action. Large workbooks can contain many formulas, formatting rules, charts, PivotTables, or embedded objects. Volatile formulas recalculate more often than ordinary formulas, and formulas that refer to entire columns or perform repeated lookups across large ranges can add substantial work. External links, data connections, and queries may also wait on a network or source that is slow or unavailable.

Add-ins are another common source of trouble. They can extend Excel with tools for reporting, finance, document management, or data analysis, but an outdated or incompatible add-in may slow startup or interfere with a task. Other possibilities include insufficient available memory, limited disk space, a damaged Office installation, an outdated Excel build, or security software interacting with files. A freeze that affects only one workbook points more toward that file or its contents; a freeze across many unrelated files makes an add-in, installation, or system issue more plausible.

Notice when the problem occurs. A freeze only while opening one file differs from a freeze every time you use a particular button or refresh a connection. Write down the workbook, action, and approximate time involved. That small record helps distinguish a repeatable trigger from a one-off delay.

Test Excel in Safe Mode and check add-ins

Excel Safe Mode starts the Windows desktop app with many customizations and add-ins bypassed. It is a useful comparison: if Excel behaves normally in Safe Mode but freezes during an ordinary start, an add-in or customization becomes a stronger suspect. Safe Mode is a diagnostic step, not a repair for a damaged workbook.

  1. Close Excel if it is open. Press Windows key+R to open Run, type excel /safe, and press Enter.
  2. Open the affected workbook only if it is safe to do so, then repeat the action that usually causes the freeze.
  3. If the problem disappears, close Excel and reopen it normally. Go to File > Options > Add-ins.
  4. At the bottom, select COM Add-ins beside Manage, then select Go. Clear an add-in checkbox to disable it temporarily and restart Excel. Re-enable items one at a time to identify a possible trigger.

Excel add-ins and COM add-ins are separate categories, so an extension may appear in a different Manage list. Change one item at a time and note what you changed; otherwise, it is difficult to tell which setting affected the result. If the freeze persists in Safe Mode, an add-in is less likely to be the explanation, though the test does not rule out every workbook or Windows issue.

On a Mac, the Windows Run command and Safe Mode procedure do not apply. Use Activity Monitor to check whether Excel is active, and review Excel add-ins in the app’s settings. Menu labels can differ by macOS and Office release.

Check whether one workbook is the problem

Try opening a different, uncomplicated workbook. If Excel is stable there but regularly freezes with one file, make a backup copy of the troublesome workbook before experimenting. If the file is stored on a network, removable drive, or cloud service, test a local copy when permitted. A slow connection, synchronization delay, or unavailable linked source can make a healthy workbook seem unresponsive.

For a workbook that opens but becomes slow during a particular action, try a copy and change one thing at a time. For example, refresh a single data connection rather than all connections, or temporarily disable automatic calculation while investigating a large formula model. In Excel for Microsoft 365 on Windows, the calculation setting is under Formulas > Calculation Options. Manual calculation can make results out of date until recalculation, so restore the intended setting and calculate the workbook before relying on its values.

Other useful checks include whether the file has far more formatted rows or columns than its visible data needs, whether formulas or conditional formatting cover unnecessarily large ranges, and whether external links point to unavailable files. Do not delete formulas, links, or formatting from the only copy to see whether performance improves. A copy preserves a route back if a change affects results.

Reduce workbook and calculation load

When a workbook is the trigger, focus on the operation that consumes time rather than assuming Excel needs more memory. A model with repeated calculations over hundreds of thousands of rows can become slow even on a capable computer. Narrowing formulas to the actual data range, removing unnecessary duplicate formatting, and reducing repeated calculations can help, but each change should be checked against the workbook’s intended results.

Data imports can also be expensive. A query that reads a large source, a PivotTable with a large cache, or a refresh that depends on a remote service may take time without indicating an Excel fault. If the pause starts when you select Refresh All, test individual connections where possible and check that the source is reachable. For a shared or business workbook, ask its owner or administrator before changing connections or model structure.

Keep the computer’s available resources in mind. Close applications that are consuming substantial memory, ensure there is adequate free disk space, and avoid running multiple heavy workbook calculations at the same time. These measures can reduce pressure, but they cannot fix a workbook design problem or an incompatible add-in by themselves.

Update or repair Microsoft 365

If Excel freezes across multiple workbooks, install available Office updates. In Excel for Microsoft 365 on Windows, go to File > Account > Update Options > Update Now. If Update Options is missing or unavailable, the installation may be managed by an organization or installed through a different channel; contact the administrator rather than changing managed settings.

If updates and add-in checks do not help, repair Office from Windows. Open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. Depending on the installation, choose Quick Repair first. If the issue continues, Online Repair is a more thorough option and may require an internet connection and a sign-in or setup afterward. Save work and close Office apps before starting repair.

Repairing Office addresses problems with the installation; it is not a substitute for recovering a damaged file or fixing a slow data source. If only one workbook remains affected after repair, keep investigating that workbook. If the problem continues across files, note your Office version and the steps that reproduce the issue before contacting Microsoft support or your organization’s IT team.

Prevent future Excel hangs

Prevention starts with a reliable save routine. Save important work with Ctrl+S on Windows (Command+S on Mac), and keep a separate backup before major edits or structural changes. To review recovery settings in Windows Excel, go to File > Options > Save and check the AutoRecover options. The available settings may be controlled by an organization. AutoRecover is a safety net, not a replacement for saving.

Keep workbooks and Excel updated, remove add-ins you do not use, and be cautious when opening files from unknown sources. For large or shared workbooks, agree on who owns data connections and avoid changing calculation settings without understanding whether colleagues depend on automatic results. If a freeze returns, record the file, action, and whether Safe Mode changes the behavior. Specific evidence is more useful than repeatedly reinstalling Office or deleting workbook content at random.

Frequently Asked Questions

Should I wait or force close Excel? If Excel may be calculating, saving, opening a file, or refreshing data, wait and check for activity or a hidden dialog first. Force closing can discard unsaved changes. If it stays unresponsive and you decide to end the task, reopen Excel and look for Document Recovery, but do not assume every recent change will be restored.

Why does Excel say Not Responding when calculating? A demanding recalculation can temporarily prevent Excel from responding to Windows. Large formula ranges, repeated calculations, and volatile formulas can contribute. If it happens consistently, test a copy of the workbook and review the formulas and calculation workload rather than treating the message alone as proof of a crash.

Will Safe Mode delete my add-ins or files? Starting Excel with excel /safe is a diagnostic launch; it does not itself delete workbooks or uninstall add-ins. If Safe Mode changes the behavior, disable add-ins temporarily through Excel’s settings and test them individually.

Why does only one Excel file freeze? That file may contain heavier formulas, formatting, connections, or other content than your other workbooks, or it may depend on a slow or unavailable source. Make a copy, test a different workbook, and check whether a local copy behaves differently before making changes to the original.

Does AutoRecover save every change? No. AutoRecover periodically stores recovery information according to its settings; it is not the same as saving each edit. Save manually, and use AutoSave where available for supported files stored in OneDrive or SharePoint.

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.