Excel Not Responding? Causes and Fixes

If Excel says Not Responding, give it a short time to finish before closing it; the message can appear while Excel is calculating, opening a large file, or waiting on an add-in. If it remains frozen, try to save if possible, then isolate the cause by checking the workbook, add-ins, calculation load, and Office installation—in that order.

What Not Responding means

In Windows, Not Responding means the program is not currently processing messages from the operating system. It does not, by itself, prove Excel has crashed or that your workbook is lost. Excel may be occupied with a demanding task and unable to update its window. A workbook with extensive formulas, a slow network connection, or an add-in waiting on another service can all make the window appear stuck.

Look for signs that work is continuing. The status bar may show Calculating, a progress indicator may be moving, or disk and CPU activity may change in Task Manager. If activity continues, waiting is safer than repeatedly clicking the window, which can queue more actions. A brief pause may be normal for a large operation; a freeze that lasts many minutes without progress deserves investigation.

Before ending Excel, consider whether the latest changes have been saved. If Windows offers to wait or close the program, choose wait first when the workbook may still be processing. Ending the task can discard unsaved changes. On a Mac, the wording and recovery steps differ, but Force Quit also risks losing work that was not saved.

First steps when Excel freezes

Start with low-risk checks. If Excel becomes responsive, save the workbook with Ctrl+S on Windows or Command+S on Mac. If a calculation is clearly stuck and Excel accepts keyboard input, Ctrl+Break on Windows can interrupt the current calculation; some keyboards require Fn with the Break key or a different key combination. It may not work while the whole application is unresponsive.

Wait briefly and check whether a calculation or file operation is visibly progressing.
Stop clicking repeatedly. If Excel recovers, save a copy under a new name before further troubleshooting.
Check whether the problem affects one workbook or every workbook. Try opening a blank workbook without closing the original if Excel still responds.
If you must close Excel, use Task Manager on Windows with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task only after accepting that unsaved changes may be lost. On Mac, use Command+Option+Esc to open Force Quit.
When Excel restarts, review the Document Recovery pane if it appears and save any recovered version with a new filename.

A recovered file may not include the very latest edits. Compare it with the last saved version before replacing anything. Avoid repeatedly opening and closing a damaged or very large workbook until you have made a backup.

Find out whether the problem is Excel or one file

Testing another workbook is a useful first diagnosis. If a new blank workbook works normally but one particular file freezes, the issue is more likely connected to that file, its data connections, formulas, or location. If every workbook freezes, look more closely at add-ins, Office updates, system resources, or the Excel installation.

Also compare where the file is stored. A workbook on a shared drive, network folder, removable disk, or cloud-synced folder may be slow because Excel is waiting for access or synchronization. If you are permitted to do so, make a local copy and open that copy. Do not overwrite a shared original while other people may be editing it. If the local copy works, investigate the connection or synchronization status rather than assuming the workbook itself is broken.

For a file that still opens but behaves abnormally, use Excel’s repair option on a copy: choose File > Open > Browse, select the workbook, select the arrow beside Open, and choose Open and Repair. Try Repair first. Extract Data is a fallback that may recover values and formulas but can lose workbook features or formatting, so retain the original file.

Check formulas and calculation load

Excel recalculates formulas when their inputs change, and a workbook with many dependent formulas can take time to update. Volatile functions, large array calculations, external links, and formulas applied to entire columns can add work. For example, a calculation that searches a million-row range repeatedly may be much heavier than one limited to the rows that contain data. A large number of conditional-formatting rules or complex charts can also slow editing and opening.

If Excel recovers, look at the status bar for calculation progress and review Formulas > Calculation Options. Automatic calculation is the normal setting for many workbooks. You can temporarily choose Manual to avoid recalculating after every edit, but results may then be stale until you recalculate. Use F9 to calculate open workbooks, or Shift+F9 to calculate the active sheet on Windows. On Mac, the function-key behavior can depend on keyboard settings; use the corresponding Excel command or configure the keyboard’s function keys. Return to Automatic when the task is done if that is the workbook’s expected behavior.

Manual calculation is not a repair for a broken workbook, and it can mislead readers if values are not refreshed. If you change the setting, tell collaborators and verify important results after recalculating. For a recurring slowdown, narrow oversized ranges, remove genuinely unnecessary formulas or formatting, and check whether external data connections are waiting for a server.

Test Excel add-ins in safe mode

An add-in can extend Excel but may also conflict with an update, workbook, or other add-in. On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe mode starts Excel with certain customizations and add-ins disabled. If the freeze no longer occurs, an add-in or customization is a plausible cause, not a certainty; test by disabling items and reopening Excel normally.

To manage add-ins in Microsoft 365 for Windows, open File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go; you can also inspect Excel Add-ins in the same list. Clear a checkbox to disable an item, restart Excel, and test again. Change one item at a time so you can identify the cause, and do not disable workplace security or business add-ins without checking with your organization.

Excel for Mac does not use the Windows /safe launch command or COM Add-ins. To check Excel add-ins on Mac, use Tools > Excel Add-ins and clear an add-in’s checkbox, then restart Excel. Menu availability can vary with the add-in and Excel build. Excel for the web does not load desktop COM add-ins; if a file works there but not in desktop Excel, that difference can help narrow the investigation.

Check workbook size and available resources

Excel can become slow when a workbook demands more memory or processing than the computer can comfortably provide. Large imported datasets, many open workbooks, high-resolution images, pivot caches, data models, and numerous formulas can contribute. Other applications competing for memory or CPU can make the delay worse. Close unrelated programs if practical, then reopen only the workbook you need.

File size is a clue, not a complete diagnosis: a compact file can contain expensive formulas, while a larger file of static values may open quickly. If one workbook is the issue, work on a copy and remove only material you understand. For instance, deleting unused rows or sheets can help only if they contain no required information, formulas, or references. A workbook that depends on external links or queries may also pause while refreshing; check its connection settings and whether the source is available before disabling refreshes.

Update or repair Microsoft 365

If multiple workbooks freeze and safe mode does not resolve the problem, install available Office updates. In Excel for Windows, choose File > Account > Update Options > Update Now. The exact controls may be managed by an organization, and updates can be delivered on a schedule. Save your work and close Office apps before maintenance where possible.

On Windows, you can repair Office through Settings > Apps > Installed apps, select Microsoft 365, choose Modify, and follow the repair prompts. Quick Repair is a faster first option; Online Repair is more thorough and may require an internet connection and sign-in. The wording can vary by Windows version and installation type. On Mac, update Office through Microsoft AutoUpdate, typically available from Help > Check for Updates in an Office app; Windows repair steps do not apply to Mac.

Repairing Office is more relevant when Excel itself fails across files than when one workbook alone is slow. Before repair, save work and confirm you can sign back in if prompted. If a managed work computer prevents updating or repair, contact IT rather than trying to remove or reinstall organizational software yourself.

Recover work and reduce future freezes

Excel’s AutoRecover feature can preserve drafts at intervals, but it is not a substitute for saving. In Excel for Windows, inspect File > Options > Save for the AutoRecover settings. After an unexpected close, Excel may show recovered files when it opens; you can also check File > Info > Manage Workbook for available recovery options. Names and availability can differ by version, and a recovery copy may be older than the last changes.

AutoSave is different: it is designed for eligible files stored in OneDrive or SharePoint and saves changes as you work when enabled. It does not guarantee recovery from every freeze, sync conflict, or service interruption. For important workbooks, use a clear versioned backup approach and verify that cloud synchronization has completed before relying on another device or closing a session.

Save before running large imports, refreshes, or formula-heavy operations.
Keep a separate copy before repairing a workbook or removing add-ins and content.
Use appropriately sized data ranges and remove obsolete formatting or connections only after checking their purpose.
Install updates through the supported Microsoft 365 or organization-managed process.

Frequently Asked Questions

Should I wait or close Excel when it says Not Responding?
Wait first if Excel may be calculating, opening a large workbook, or refreshing data. If there is no progress for a long time and the app remains unusable, ending it may be necessary, but unsaved changes can be lost.

How do I start Excel in safe mode?
On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Mac does not use this command; disable Excel add-ins through Tools > Excel Add-ins instead.

Why does Excel freeze when I open one workbook?
That workbook may contain costly formulas, external connections, damaged content, or features that behave differently on your computer. Test a local copy, check whether other files open, and use Open and Repair on a backup if needed.

Will force-closing Excel recover my unsaved file?
Not necessarily. AutoRecover or a Document Recovery prompt may offer a recent draft after restart, but it may omit recent edits. Save recovered content as a separate file and compare it with your last saved version.

Does Not Responding mean my workbook is corrupted?
No. The message only indicates that Windows is not receiving a timely response from Excel. A temporary calculation or resource bottleneck can cause it; workbook damage is only one possible explanation, especially when the problem follows a single file.

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.