Excel Not Responding? Causes and Fixes

If Excel says “Not Responding,” first give it a moment: a large calculation, refresh, or file operation can temporarily occupy the app. If it remains stuck, protect your work, then reopen Excel in Safe Mode and check add-ins, the workbook, and Office updates to identify the cause.

Why Excel stops responding

“Not Responding” is a Windows status, not a diagnosis. It means Windows has not received a timely response from Excel’s interface; it does not necessarily mean the workbook is lost or Excel has crashed permanently. Excel may be busy with work that takes longer than usual, or it may be blocked by a problem in the app, a workbook, or the environment around it.

Common causes include a workbook with many formulas or large data ranges, a lengthy recalculation, a Power Query refresh, a slow network location, or an add-in that is not behaving properly. A workbook containing links to other files, complex formatting, pivot tables, or macros can also take longer to open or update. Low available memory and other demanding programs may add to the delay.

Notice when the freeze occurs. If it happens with one particular file, investigate that workbook first. If it happens with every file, the Excel installation, an add-in, or the computer is a more likely starting point. If it occurs only during refresh or calculation, wait for that operation to finish before changing settings or closing the app.

What to do before closing Excel

Repeatedly clicking the window or pressing keys can queue up actions that Excel may carry out all at once if it becomes responsive. Avoid doing that. Wait a few minutes for a large job, and check whether the computer is still active or whether the status bar shows a calculation or refresh in progress. A short pause is different from an extended freeze: use judgment, especially with a large file or a slow connection.

If Excel responds again, save a new copy of the workbook before troubleshooting. Use File > Save As and choose a local folder you can find easily. This helps protect the original if a repair or a change to formulas has an unexpected result. For a workbook stored in OneDrive or SharePoint, check that its latest changes have finished syncing before relying on a cloud copy.

If the window remains stuck and you must close it, Windows Task Manager can end the Excel process: press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This can discard unsaved changes, so treat it as a last resort rather than the first fix. When Excel starts again, look for a Document Recovery pane or use File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery options depend on whether Excel had time to create an AutoRecover copy; they cannot guarantee restoration of every recent edit.

Start Excel in Safe Mode

Safe Mode starts Excel with certain startup features and add-ins disabled, which makes it a useful way to separate an Excel-wide problem from a normal startup problem. Close Excel if possible. In Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens and stays responsive in Safe Mode, an add-in or another startup component is a reasonable suspect. Safe Mode is a diagnostic step, not a permanent repair.

Try opening the affected workbook while Excel is in Safe Mode. If it opens there but not in a normal session, focus on add-ins and startup settings. If it still hangs, the workbook itself, its data connections, or a broader Office or system issue may be involved. If Safe Mode will not start, move on to checking updates and repairing Microsoft 365.

Excel for Mac does not use the Windows excel /safe command. Do not enter that command in macOS and expect the same diagnostic mode. On a Mac, start by quitting and reopening Excel, checking for updates, and investigating add-ins from Excel’s menu. Excel for the web also has no desktop Safe Mode; use its browser and workbook troubleshooting steps instead.

Check add-ins and startup settings

A COM add-in or Excel add-in can affect startup, file opening, or particular actions. In Excel for Microsoft 365 on Windows, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then select Go. Clear the check box for an add-in to disable it and restart Excel. If needed, repeat the process with Excel Add-ins in the Manage list. Record which items you disable so you can restore them later.

If Excel works normally after disabling add-ins, re-enable them one at a time and restart Excel after each change. This can identify a specific conflict without leaving every add-in turned off. Some organizations manage add-ins centrally, so contact your IT administrator if a setting is unavailable or the add-in is required for work.

On Mac, add-in management is available from Excel’s Tools menu, but the available add-in types and controls differ from Windows. Excel for the web supports some add-ins but not the same desktop COM add-ins. A web workbook that hangs should therefore be investigated through browser, connection, and workbook checks rather than Windows COM settings.

Find out whether the workbook is the problem

Open a blank workbook and see whether Excel remains responsive. If it does, test a copy of the troublesome file rather than repeatedly experimenting on the original. A very large used range, unnecessary formatting across whole columns, lengthy formulas, external links, data connections, or a refresh can increase the work Excel must do. A workbook can also be slow because it is stored on a network drive or depends on a source that is currently unavailable.

Try opening a copy from a local folder, if your organization’s storage rules allow it. If the file opens, check whether the network location or connection is contributing to the delay. For a file that will not open normally, use File > Open > Browse, select the file, choose the arrow next to Open, and select Open and Repair. Choose Repair first; if that does not work, the available Extract Data option may help recover values and formulas, though it may not preserve all workbook features. Keep the untouched original as a backup.

When a workbook is calculating, switching calculation to Manual can help diagnose whether recalculation is the trigger, but it changes workbook behavior and may leave displayed results out of date. On Windows, use Formulas > Calculation Options > Manual only if you understand that trade-off, and restore Automatic when appropriate. Press F9 to calculate open workbooks, Shift+F9 to calculate the active sheet, or Ctrl+Alt+F9 to force a full calculation. On Mac, keyboard equivalents can differ by keyboard and settings; use the Formulas menu if a shortcut does not work. Do not treat stale displayed values as current results.

Update or repair Microsoft 365

Installing Office updates can resolve problems addressed in a newer build. In Excel for Microsoft 365 on Windows, use File > Account > Update Options > Update Now. The Update Options control may be managed by an organization or absent with some installation types. Save your work and close other Office apps before updating when prompted. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is installed; update controls can vary with how Office was installed.

If the problem continues across workbooks, repair the Office installation. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, select its menu, and choose Modify. Run Quick Repair first. If that does not help, Online Repair is a more extensive option and requires an internet connection; follow the prompts, then restart the computer and test Excel. The exact labels can vary slightly by Windows release and installation. If your organization manages Microsoft 365, ask its support team before changing or repairing the installation.

Excel in a browser or on a Mac

Excel for the web runs in a browser, so a frozen tab can reflect a browser or connection issue as well as a busy workbook. Confirm the internet connection, wait briefly, and check whether the workbook is still available in OneDrive or SharePoint from another tab or device before refreshing. Refreshing a page can interrupt unsaved activity, even when cloud AutoSave is enabled; wait for saving or syncing to finish whenever possible. If the issue persists, try a supported, up-to-date browser and close unnecessary tabs.

On Mac, close other demanding apps, restart Excel, and check for Office and macOS updates. If only one workbook is affected, make a copy and test that copy; if all workbooks are affected, concentrate on updates and add-ins. Menu names and keyboard shortcuts can differ from Windows, so use the menus described for Mac rather than assuming a Windows path or shortcut applies. Some Windows repair tools and COM add-ins are not available on Mac.

Reduce the chance of another freeze

There is no setting that prevents every hang, but a few habits reduce the risk and make recovery easier:

Keep Microsoft 365 and the operating system updated, subject to your organization’s update policies.
Save regularly, keep a separate backup of important workbooks, and allow cloud files time to finish syncing.
Remove add-ins you do not need, and update essential add-ins through their supported source.
Limit unnecessary formatting and formulas over unused rows or columns, and avoid repeatedly refreshing a large data connection while other work is running.
For critical workbooks, test structural changes on a copy and confirm calculation settings before relying on displayed results.

AutoRecover can provide an additional safety net. In Windows Excel, open File > Options > Save and check that Save AutoRecover information every … minutes is enabled; you can also keep the last AutoRecovered version if you close without saving. AutoRecover is not a substitute for saving: it may not capture every change, and it does not prevent a freeze.

Frequently Asked Questions

Should I wait or force close Excel?
Wait if Excel may be calculating, refreshing, or opening a large file, and avoid repeatedly clicking the window. If it remains unresponsive for an extended period and you cannot continue, ending the task in Task Manager may be necessary, but unsaved work can be lost.

Why does Excel freeze only with one file?
The workbook may contain heavy formulas, large data ranges, external links, a connection that cannot respond, or damaged content. Test a copy, compare it with a blank workbook, and consider Open and Repair if the file will not open normally.

Can I recover an Excel file after it stops responding?
After restarting Excel, check the Document Recovery pane and File > Info > Manage Workbook > Recover Unsaved Workbooks. Whether a usable version exists depends on the last save and AutoRecover data, so recovery is not guaranteed.

Does Safe Mode fix Excel permanently?
No. It helps determine whether startup components or add-ins are involved. If Excel works in Safe Mode, disable add-ins and re-enable them individually to find the cause, then use Excel normally once the issue is addressed.

Why does Excel say Not Responding during calculation?
A complex or large calculation can occupy Excel long enough for Windows to display that status. Give it time, particularly on a large workbook. Manual calculation can be a diagnostic option, but results may be stale until recalculated, so restore the appropriate calculation setting afterward.

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.