Excel Always Not Responding? Causes and Fixes

How-to basics · Updated November 18, 2026

No—Excel does not always freeze because the program is broken. A Not Responding message usually means Windows is waiting for Excel to finish a task, or Excel is stuck on a workbook, add-in, or system issue. Give it a short chance to recover, protect any unsaved work, then test Excel without the affected workbook or add-ins before considering a repair.

What “Not Responding” means

In Windows, Not Responding is a status shown when an application is not processing normal window messages promptly. It does not, by itself, prove that Excel has crashed or that your workbook is lost. Excel may be calculating formulas, refreshing a data connection, loading a large file, or waiting on another component. During that work, the window can appear frozen even though the task may eventually finish.

The distinction matters because repeatedly clicking the window or immediately choosing End task can make recovery harder. A workbook with millions of calculations can take time to recalculate; a macro or external connection can also pause while it works. On the other hand, a freeze that happens every time Excel opens, including with a blank workbook, points more toward an add-in, installation, or Windows-level problem than a single file.

Look for clues before changing anything: did this begin after opening one particular workbook, starting a refresh, running a macro, or installing an add-in? Does the status clear after a minute, or does Excel remain stuck even when idle? Those details help narrow the cause and avoid unnecessary changes.

First, protect unsaved work

If the workbook contains changes you have not saved, do not start by force-closing Excel. Wait briefly and watch for signs of activity, such as a changing status bar or a return to normal window controls. If Excel becomes responsive, use File > Save As to create a separate copy before trying repairs. Saving a copy protects the current file from experiments that could alter formulas, links, or data.

If a calculation or refresh is underway, allow more time when the workbook is large or the operation is known to take a while. Avoid launching multiple copies of Excel or repeatedly clicking the same command, since that can queue more work. If the problem is limited to a macro and Excel still accepts keyboard input, the Esc key may stop some running VBA procedures; it will not reliably stop every task or recover a genuinely hung application.

When Excel has been unresponsive for a long time and does not recover, ending the task may be the only practical option. In Windows, open Task Manager with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This can discard changes made since the last save. After reopening Excel, check whether a Document Recovery pane offers a recovered copy, then save any useful version under a new name. AutoRecover and recovery panes can help, but they are not a guarantee that every recent change was captured.

Find out whether Excel or one workbook is the cause

Once you have protected what you can, compare the problem workbook with a blank one. Open Excel without opening the file that freezes, create a blank workbook, and try ordinary actions such as entering a value and saving locally. If the blank workbook works normally, the original file or something it triggers is a stronger suspect. If even a blank workbook hangs, look beyond that file to add-ins, Office, or the computer.

For a workbook-specific freeze, make a copy before troubleshooting. If the file is stored on a network share, cloud-synced folder, removable drive, or shared location, try working from a local copy if your organization’s rules allow it. A slow or interrupted connection can delay opening, saving, or refreshing linked data. If the file opens, use Save As to create a new workbook copy, then test whether the freeze follows the copy. Do not overwrite the only original while investigating.

Consider what the workbook is doing at the moment it stalls. A file that freezes during opening may contain extensive formulas, links, queries, or macros that run automatically. A freeze only during Data > Refresh All suggests a connection or data-refresh workload; one that occurs during recalculation suggests formulas or calculation volume. If a single sheet or action consistently triggers the problem, note it before changing the file. That observation is more useful than randomly deleting content.

Start Excel in Safe Mode and isolate add-ins

Excel Safe Mode is a useful Windows test because it starts Excel with a reduced set of startup features and without many customizations and add-ins. Close Excel if possible, press Windows key+R, type excel /safe, and press Enter. If Excel starts and behaves normally in Safe Mode, an add-in or startup customization is a likely cause. Safe Mode is a diagnostic step, not a permanent repair, and it does not prove which add-in is responsible.

To check add-ins in a normal Excel session, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then choose Go. Clear the check boxes to disable the listed COM add-ins, restart Excel, and see whether the freeze returns. If it does not, re-enable add-ins one at a time, restarting between tests, to identify a likely trigger. Excel add-ins can be checked from the same Manage list by selecting Excel Add-ins and choosing Go.

Some add-ins are installed by employers or are needed for specialized workflows. Before removing one, ask your IT administrator if you are unsure what it does. If Safe Mode also freezes, or disabling the relevant add-ins does not help, move on rather than repeatedly changing unrelated settings. The Safe Mode command and these Windows menu paths do not apply to Excel for Mac; Mac startup and add-in controls differ.

Reduce workbook calculation and loading strain

Large or complex workbooks can make Excel appear stuck without having a damaged installation. Common sources of heavy work include formulas copied through many rows, references to entire columns in repeated calculations, volatile functions that recalculate frequently, large array calculations, extensive conditional formatting, and many pivot tables or external connections. A workbook may also be slow because it contains far more used cells or formatting than its visible data requires.

For example, a sales workbook with formulas on hundreds of thousands of rows and several data connections may take noticeably longer to open or recalculate than a small table. If the delay began after adding a formula or query, test a copy with that recent change removed or reduced. Avoid replacing formulas with values in the original just to see whether it helps; that can destroy the workbook’s intended behavior. A copy lets you compare safely.

Check whether Excel is calculating or refreshing before treating the delay as a crash. If the file is usable after the work finishes, consider simplifying repeated calculations, limiting formulas to the rows that contain data, reducing unnecessary formatting, or refreshing connections individually to identify a slow source. These are workbook design choices, so preserve an untouched copy and confirm results after each change. If a workbook is shared, coordinate changes with its owner or team.

Calculation mode is another factor. In Excel for Windows, check Formulas > Calculation Options. If the workbook is set to Manual, formulas may not update until recalculation is requested; changing this setting can affect how the workbook behaves. Do not switch calculation modes blindly to cure a freeze. First note the current setting, and make sure the displayed results are recalculated and correct before relying on them.

Check updates, Office repair, and Windows factors

If blank workbooks also freeze, install available Microsoft 365 updates. In Excel for Windows, use File > Account > Update Options > Update Now. The labels can differ if an organization manages Office updates. On a Mac, updates are handled through Microsoft AutoUpdate; the route can depend on how Office was installed, so check Excel’s Help menu or your organization’s update instructions.

A damaged Office installation is another possibility, especially if the problem affects several Office applications or began after an interrupted update. On Windows, open Settings > Apps > Installed apps, find Microsoft 365, choose its More options button, and select Modify. Depending on the installation, repair choices can include Quick Repair and Online Repair. Quick Repair is the less extensive first option; Online Repair is more thorough and may require internet access and time. Close Office apps and follow the prompts. Work or school devices may require an administrator to do this.

Also consider recent changes outside Excel: a new printer, security tool, driver, or managed Office policy may coincide with the first freeze. Do not disable antivirus protection or make broad system changes as a test. Instead, note when the issue started and contact IT if the computer is managed. On a Mac, use Apple menu > Force Quit only when Excel is stuck and cannot be closed normally; force quitting can lose unsaved work. Windows repair steps and Safe Mode instructions above are not Mac instructions.

When to wait, close, or recover

Waiting is sensible when Excel has just started a known calculation, refresh, or large file operation and there are signs the task is progressing. Closing is more reasonable when the window remains stuck for a long time, the same operation repeatedly hangs, and recovery is unlikely. There is no single safe waiting period: a small workbook should not normally require the same time as a large model or remote data refresh.

When Excel opens again, check the recovered files carefully. Compare the recovery version with your last saved copy, confirm important formulas and data, and save the version you want to keep with a clear new filename. If crashes repeat, record whether they happen with one workbook, after one action, or even in Safe Mode. Share those details, your Excel version, and any error messages with IT or Microsoft support. Reproducible details make diagnosis more efficient than a report that Excel simply “always” freezes.

Frequently Asked Questions

Why does Excel say Not Responding but later recover?
Windows can show that status when Excel is busy and not responding to window messages promptly. A long calculation, file operation, or data refresh may finish eventually. The message alone does not establish that the workbook is corrupted.

Will I lose my work if I force close Excel?
You can lose changes made since the last save. After reopening, Excel may offer recovered files, but recovery is not guaranteed. If the workbook becomes responsive, save a separate copy before troubleshooting.

How can I tell whether an add-in is causing the freeze?
On Windows, start Excel with excel /safe. If the issue disappears, disable add-ins through File > Options > Add-ins and test them one at a time. Safe Mode is a clue, not proof, and it does not identify the specific add-in by itself.

Why does only one Excel file keep freezing?
That workbook may involve unusually heavy formulas, macros, external links, data connections, or file-location delays. Test a copy and compare its behavior with a blank workbook. Keep the original unchanged while narrowing down which operation triggers the stall.

Does Excel Not Responding mean my file is corrupted?
No. The message can result from ordinary workload, an add-in, or an installation or system issue. A problem limited to one workbook makes file-specific causes worth checking, but a freeze alone is not proof of corruption.

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.