Excel Not Responding: Causes, Checks, and Practical Fixes

How-to basics · Updated November 18, 2026

When Excel says “Not Responding,” first give it a few minutes if it may be calculating or opening a large file; repeatedly clicking can make the delay worse. If it stays frozen, protect any recoverable work, then reopen Excel and troubleshoot in order: test the workbook, start Excel without add-ins, and check for updates or resource problems.

What “Not Responding” means

In Windows, the message usually means Excel is not responding to Windows’ requests for a short period. It does not prove that the program has crashed or that the workbook is lost. Excel may be calculating formulas, refreshing data, loading an add-in, saving a large file, or waiting for a network location. Some tasks temporarily monopolize the application, so the window can appear frozen even though work is still underway.

Look for clues before closing it. A changing status bar, disk activity, or a progress indicator may suggest Excel is still working. If the file is stored on a shared drive or synced folder, a slow connection can add delay. By contrast, a blank window that remains unchanged for a long time, especially after the same action repeatedly, makes a hang more likely. There is no universal wait time: a large calculation can take much longer than a small edit.

Wait safely and protect your work

If you just opened a big workbook, refreshed a query, or triggered a calculation, wait rather than clicking repeatedly or launching Excel several more times. Avoid shutting down the computer while a save may be in progress. If the workbook is synced with OneDrive or SharePoint, do not assume that a cloud copy contains the latest unsaved changes; synchronization generally cannot upload edits Excel has not saved.

If Excel becomes responsive, save a separate copy before trying changes that could affect the file. Use File > Save As and choose a local folder, such as Documents, for a diagnostic copy. If the workbook is still frozen, Windows may offer Document Recovery the next time Excel starts. Review the recovered version carefully and save it with a new name rather than overwriting the original immediately.

AutoRecover can help, but it is not a substitute for saving. In Excel for Microsoft 365 on Windows, review File > Options > Save for the AutoRecover settings. The exact recovery options differ on Mac and depend on the version. AutoSave is also different: it works with supported files stored in OneDrive or SharePoint, while AutoRecover periodically keeps recovery information for a crash or unexpected closure.

Close or restart Excel only when necessary

If Excel has not recovered after a reasonable wait and there is no sign of progress, close it as a last resort. In Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. On Mac, press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. These actions can discard unsaved changes, so use them only when waiting is no longer useful.

Reopen Excel and check for a Document Recovery pane or a prompt to recover files. Open the most recent candidate, inspect the last rows or edits you remember making, and save it under a new name. If recovery does not appear, check File > Info for workbook management or recovery options available in your Excel version. The names and availability of these commands can vary; do not delete temporary or recovery files simply because their names are unfamiliar.

Find out whether the workbook or Excel is the problem

Open a blank workbook. If it works normally while one particular file repeatedly freezes, the cause is more likely to be that workbook, its formulas, external connections, or its location than Excel as a whole. If even a blank workbook hangs, investigate add-ins, Office installation, updates, and available system resources.

Make a copy of a problematic workbook before testing it. If the copy opens, try a smaller version or remove one suspected feature at a time, saving separate test copies. A workbook that behaves differently when moved from a network share to a local folder may be affected by connectivity, permissions, or sync activity. Avoid treating “Open and Repair” as a routine first step: use it on a copy if Excel reports a damaged file, because repair can remove content it cannot recover.

Start Excel without add-ins

Add-ins can extend Excel, but a faulty or outdated one may slow startup, freeze a workbook, or conflict with an update. On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins disabled. It is a diagnostic test, not a permanent fix. This command is for Windows; Mac does not use the same Excel Safe Mode command.

If Excel works in Safe Mode, disable add-ins and restart normally to identify the cause. In Windows Excel, go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, choose Go, and clear the check boxes. You can also inspect Excel Add-ins from that Manage list. Restart Excel and test; if the problem is gone, re-enable items one at a time, restarting between tests. That helps isolate the add-in rather than leaving every extension disabled.

On Mac, add-in controls and available add-in types differ from Windows. Check Excel’s Add-ins settings or the relevant add-in’s own instructions, and disable only what you recognize. If your workplace manages add-ins, ask the administrator before removing or changing a required tool.

Reduce workbook calculation and data load

Large or complex workbooks can demand substantial memory and processing time. Common sources include formulas copied across entire columns, many volatile formulas, extensive conditional formatting, external links, large pivot caches, and queries that refresh from slow sources. One example is a workbook that recalculates thousands of formulas after every edit because many formulas refer to broad ranges. Simplifying the ranges or limiting calculations to the data actually used can reduce that workload.

For diagnosis, you can temporarily change calculation to manual in Windows Excel through Formulas > Calculation Options > Manual. This prevents automatic recalculation after each change, but it also means displayed results may be out of date until you calculate. Restore Automatic when appropriate, and calculate before relying on or sharing results. On Mac, the calculation controls are also on the Formulas tab, though the layout can vary. Do not use manual calculation as a way to hide incorrect or stale results.

Also consider whether Excel is refreshing external data or working with a file that is unusually large. If the workbook is safe to edit, refresh one connection at a time and note which one causes the delay. For files on a network, test a local copy only if your organization’s data-handling rules allow it. A local copy can help distinguish a file-processing issue from a connection issue, but it may not include the latest shared changes.

Check updates, storage, and system resources

Install available Office updates after saving your work. In Windows Excel, use File > Account > Update Options > Update Now if that option is available; work or school devices may be managed by an administrator. On Mac, check for updates through Microsoft AutoUpdate, often available from Help > Check for Updates. Update names and paths can change between releases.

Close other demanding applications and check that the device has free storage. Low available memory, a nearly full drive, or many simultaneously open workbooks can contribute to sluggish behavior. Restarting the computer may clear temporary resource pressure, but it will not fix a damaged workbook or a problematic add-in. If the issue begins after an Office update, record the version and timing before seeking help; do not download replacement Excel files from unofficial sites.

When to repair Office or ask for help

If blank workbooks also freeze and Safe Mode does not help, repair the Office installation on Windows. Close Office apps, open Windows Settings > Apps > Installed apps, select Microsoft 365 or Office, choose Modify, and try Quick Repair first. If that does not solve the issue, Online Repair is a more thorough option and may require an internet connection and sign-in again. Exact labels can vary by Windows and Office installation. Mac users should update Office and consult Microsoft support or their IT administrator for repair guidance appropriate to their installation.

Contact your organization’s support team if the problem affects a managed device, a shared workbook, an important business process, or an add-in supplied by your employer. Provide the Excel version, operating system, file location, approximate file size, and the action that triggers the freeze. If only one file is affected, share a copy only through an approved channel and remove confidential data when possible.

Common mistakes to avoid

  • Do not repeatedly click the frozen window or press keys rapidly. Excel may eventually process queued input all at once.
  • Do not force quit immediately after starting a save, refresh, or large calculation unless the wait is clearly unreasonable.
  • Do not overwrite the original workbook while testing repairs. Keep a backup and use clearly named copies.
  • Do not assume AutoSave has captured changes that were never saved or uploaded.
  • Do not disable every add-in permanently without testing; one at a time is more informative and preserves useful functionality.

Frequently Asked Questions

How long should I wait when Excel says Not Responding?
There is no fixed limit. Give a large calculation, refresh, or save time to finish, and look for signs of progress. If the window remains unchanged for an unusually long time and the same task repeatedly hangs, begin recovery and troubleshooting rather than clicking repeatedly.

Will I lose my work if I force close Excel?
Unsaved changes can be lost. Excel may offer recovered files after reopening, but recovery is not guaranteed and may not include the latest edits. Check the Document Recovery pane and save any recovered version under a new name.

Why does only one Excel file keep freezing?
That workbook may contain heavy formulas, data connections, external links, extensive formatting, or damaged content. Test a copy, compare it with a blank workbook, and note whether the problem changes when the file is opened from a local location rather than a network or synced folder.

Does Excel Safe Mode delete my add-ins?
No. On Windows, excel /safe is a temporary diagnostic startup. It does not by itself uninstall add-ins. If Excel works in Safe Mode, disable add-ins deliberately through the Add-ins settings and test them one at a time.

Can AutoSave recover a frozen workbook?
AutoSave can save ongoing changes for supported files in OneDrive or SharePoint, but a freeze may prevent new changes from being saved or synced. AutoRecover is a separate recovery feature. Check both the recovered files offered by Excel and the cloud version history when available.

A practical troubleshooting order

For most cases, the safest sequence is to wait for a plausible task to finish, recover and save a copy if Excel restarts, compare the affected file with a blank workbook, test Windows Safe Mode if available, and then inspect add-ins, workbook load, updates, and Office repair. Change one thing at a time and keep the original file untouched. This approach helps distinguish a temporary calculation delay from a workbook-specific problem or an Excel installation issue, while reducing the chance that troubleshooting causes avoidable data loss.

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.