Microsoft Excel Always Not Responding? Causes and Fixes

No—Microsoft Excel does not always become unresponsive because it is broken. A brief freeze can happen while a large workbook calculates, saves, or loads data; if it happens repeatedly, isolate whether the cause is Excel, an add-in, the workbook, or the computer before closing the app.

If Excel has stopped responding, wait briefly and avoid repeatedly clicking the window. If it remains frozen, use the steps below to troubleshoot while reducing the chance of losing unsaved work.

What “Not Responding” Means

In Windows, Not Responding is a status indicating that an app is not currently processing messages from the operating system. It does not, by itself, prove that Excel has crashed or that the workbook is damaged. Excel may be busy with a calculation, a large paste, a refresh, a save, or another task that takes time.

For example, opening a workbook with many formulas or refreshing a connection to an external data source can temporarily make the window unresponsive. If the activity finishes, Excel may recover without intervention. A window that stays frozen for a long time, repeatedly freezes during ordinary work, or closes unexpectedly needs investigation.

Notice the timing and scope of the problem. Does it happen with one file or every workbook? Does it start when you click a particular command, open a sheet, or refresh data? Those details help distinguish a workbook-specific issue from a problem with the Excel installation or system.

What to Do Before Closing Excel

Give Excel a little time, especially if the workbook is large or you just started a calculation, refresh, or save. Look for signs of activity, such as a calculation indicator in the status bar or disk activity. Avoid clicking repeatedly: queued clicks can trigger unintended actions once Excel responds.

If Excel begins responding again, save a separate copy before continuing to troubleshoot. Use File > Save As and choose a different name or location. If the window is still responsive enough to use, pressing Esc may cancel some ongoing actions, such as certain selections or dialogs, but it cannot reliably stop every calculation or operation.

If it remains frozen, Windows Task Manager can close Excel, but unsaved changes may be lost. Press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. Use this only after waiting, because ending the process interrupts work in progress. On a Mac, use Option+Command+Esc to open Force Quit, select Excel, and choose Force Quit.

When Excel starts again, check for a Document Recovery pane or recovered versions. Recovery can restore some unsaved work, but it is not a substitute for saving regularly and may not contain the latest changes.

Check Whether One Workbook Is the Cause

Open a blank workbook or another known-good file. If those work normally while one particular workbook freezes, focus on that file rather than immediately reinstalling Office. A workbook can be slow because it contains extensive formulas, large data ranges, many shapes or conditional formatting rules, external links, queries, or macros.

Consider what happens just before the freeze. A pause when refreshing a query points toward data retrieval; a pause after editing a formula may indicate recalculation; a pause when opening the file could involve links, macros, or file loading. If the file is stored in OneDrive, SharePoint, or a network location, syncing or connection delays may also affect opening and saving. Try a local copy only if your organization’s policies allow it, and avoid creating conflicting copies of a shared workbook.

If the workbook opens, save a copy and test one change at a time. For instance, make a copy before removing an external connection or changing calculation settings. Avoid deleting formulas, links, or macros from the only copy: those elements may be essential to the workbook’s purpose.

Start Excel in Safe Mode

Safe Mode is a useful way to check whether startup customizations or add-ins are involved. On Windows, press Windows key+R, type excel /safe, and press Enter. Open the affected workbook if possible. If Excel behaves normally in Safe Mode but freezes in a normal launch, an add-in or customization is a reasonable suspect, though the test does not identify the exact cause by itself.

Safe Mode is a Windows troubleshooting option. Excel for Mac does not use the same Windows Safe Mode command; on a Mac, test by opening Excel without opening the affected workbook and then review available add-ins and startup items in that version.

If the workbook still freezes in Windows Safe Mode, the file itself, its data connections, or a wider Office or system issue may be involved. If it works, return to a normal launch and disable add-ins as described below.

Disable Add-Ins and Check for Updates

Add-ins extend Excel, but an outdated or incompatible add-in can interfere with startup or particular tasks. In Excel for Microsoft 365 on Windows, 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 to disable them temporarily. You can also select Excel Add-ins in the Manage list and choose Go to review that category. Restart Excel and see whether the problem continues.

If disabling add-ins helps, re-enable them one at a time, restarting Excel between changes. This can identify which add-in is associated with the freeze. Check with its publisher or your organization’s IT team before removing an add-in you rely on. The Mac interface and available add-in types differ; use Excel’s Tools > Add-ins menu for add-ins available there, or the Office Add-ins controls if the add-in was installed through Microsoft 365.

Also install available Office updates. In Excel for Windows, select File > Account > Update Options > Update Now. If your organization manages updates, the option may be controlled by IT. On a Mac, use Help > Check for Updates when Microsoft AutoUpdate is available, or update Office through the method used to install it.

Reduce Workload and Check System Resources

Excel can slow down when a workbook asks the computer to process a great deal at once. Examples include formulas that refer to entire columns across many sheets, repeated volatile calculations, very large data models, or a query that retrieves more data than needed. Several resource-heavy applications open at the same time can make the delay worse.

Close other applications you do not need and check whether the computer is low on available memory or storage.
Reduce unnecessary formatting and duplicate conditional formatting rules in a copy of the workbook.
Limit imported data to the columns and rows needed for the task, where practical.
Allow a long refresh or calculation to finish before starting another large operation.
If a workbook is shared, coordinate major edits or refreshes with other users to avoid competing changes.

Calculation mode can affect when formulas update, but changing it is not a general cure. In Windows Excel, see Formulas > Calculation Options. Manual calculation can leave results out of date until calculation is triggered, so do not switch to it without understanding the workbook’s needs. If you change the setting for a test, note the original setting and restore it when finished.

Repair Microsoft 365 if Excel Freezes Across Files

If Excel freezes with different workbooks, including a blank workbook, and Safe Mode or add-in checks do not help, repair the Office installation. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, and select Modify. Depending on the installation, the repair choices include Quick Repair and Online Repair. Quick Repair is the less extensive first option; Online Repair is more thorough and may take longer or require an internet connection.

Save and close Office apps before starting a repair. The labels and route can vary slightly by Windows version and by how Microsoft 365 was installed; a work or school computer may require an administrator or IT support. Repairing Office is different from repairing a single workbook, so first make sure you have a safe copy of important files.

On Mac, Windows’ Installed apps repair controls do not apply. Update Office first; if the issue persists, consult Microsoft support or your organization’s IT team for the appropriate Mac-specific repair or reinstall guidance. Avoid removing Office components or system files based on generic cleanup advice.

Prevent Future Freezes and Protect Work

Save important work regularly with Ctrl+S on Windows or Command+S on Mac. For a critical workbook, keep a separate backup or use an approved cloud location with version history. AutoSave may be available for files stored in OneDrive or SharePoint, but it is not a guarantee that every change can be recovered, especially if a problem occurs before syncing finishes.

Keep Excel and its add-ins current, and be cautious with files from unknown sources. Macros and external connections can perform actions or access data; enable them only when you trust the file and understand why they are needed. If a workbook is consistently slow, document which action triggers the delay and share that information with its owner or your IT team. A repeatable description is more useful than simply reporting that Excel freezes.

For Excel for the web, the Windows Safe Mode command and desktop repair steps do not apply. Try reloading the browser tab only after considering whether unsaved changes could be lost, and check the connection and browser. If the same file works in desktop Excel but not in the browser, the feature or workload may be affected by the web version’s different capabilities and limits.

Frequently Asked Questions

Should I wait or close Excel when it says Not Responding? Wait briefly if you just started a calculation, refresh, or save, and avoid repeated clicks. If it stays frozen, close it through Task Manager as a last resort, understanding that unsaved changes may be lost.

Why does Excel freeze when I open one file? The workbook may have heavy formulas, external links, data connections, macros, or extensive formatting. Compare it with a blank workbook, then troubleshoot a saved copy and note which action triggers the freeze.

Will Safe Mode delete my files or settings? No. Safe Mode starts Excel with a limited set of features for troubleshooting; it does not intentionally delete workbook files. Still, save a backup before making changes to a workbook.

Can an add-in make Excel stop responding? Yes. An add-in can contribute to freezes or startup problems, particularly if it is incompatible or outdated. Disable add-ins temporarily, then re-enable them one at a time to narrow down the cause.

How do I recover an unsaved Excel workbook? Reopen Excel and look for the Document Recovery pane. Depending on the recovery settings and when Excel last saved temporary information, some changes may be available; not every unsaved edit can be restored.

Does reinstalling Excel fix every freeze? No. Reinstalling will not necessarily fix a workbook-specific problem, a slow data connection, insufficient system resources, or a faulty add-in. Identify whether the issue affects one file or all files before choosing repair or reinstall steps.

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.