Excel Repeatedly Not Responding? Causes and Fixes

How-to basics · Updated November 21, 2026

If Excel repeatedly shows “Not Responding,” first give it a short time to finish, especially if a large workbook is calculating or opening; then save as soon as the window responds. If the problem keeps returning, use Excel’s Safe Mode to check for add-ins, test whether the issue follows one workbook, and then update or repair Microsoft 365 as needed.

What “Not Responding” means

In Windows, “Not Responding” usually means Excel is not currently processing ordinary input from the mouse or keyboard. It does not automatically mean the program has crashed or that the workbook is lost. Excel may be busy recalculating formulas, loading data, refreshing a connection, rendering a large sheet, or waiting on another component. During that work, Windows may mark the app as unresponsive even though it could recover.

How long to wait depends on what Excel was doing and the workbook’s size. A brief pause after opening a complex file can be normal; a freeze that recurs during simple actions such as selecting a cell is more concerning. Avoid clicking repeatedly or launching multiple copies of Excel while it is stalled. Extra input can queue up, and additional instances can consume memory without fixing the underlying cause.

Look for clues before closing anything. Is the pause limited to one workbook, or does it happen with a blank workbook too? Does it occur when opening, saving, filtering, printing, or refreshing data? Does it begin after a particular add-in loads? These distinctions help separate a damaged or demanding file from an issue with Excel itself.

Protect your work before troubleshooting

If the window starts responding again, save immediately with Ctrl+S on Windows. On a Mac, use Command+S. If the workbook is important, save a separate copy with a new name using File > Save As before experimenting with settings. A copy makes it easier to compare results and protects the original from accidental changes.

If Excel remains frozen, check whether it is doing substantial work before ending the process. On Windows, press Ctrl+Shift+Esc to open Task Manager and look at Excel’s CPU and memory activity. A busy process may still be calculating; low activity for a prolonged period is not proof of a crash, but it can be a reason to wait no longer if the program has stopped making progress. Pressing Esc can cancel some Excel operations, such as certain calculations or selections, but it will not interrupt every kind of hang.

Force-closing Excel can discard changes made since the last save. After an unexpected closure, reopen Excel and look for the Document Recovery pane or recovered files. AutoRecover may help restore unsaved work, but it is not a guaranteed backup and its recovery interval matters. Do not treat a recovered copy as authoritative until you have checked its latest entries and formulas.

Check whether the problem is Excel or one workbook

Open a new blank workbook and try ordinary actions such as entering a value, changing sheets, and saving. If the blank file works but one existing workbook repeatedly freezes, focus on that file: its formulas, data connections, formatting, size, or file integrity may be responsible. If even a blank workbook stalls, investigate add-ins, updates, and the Office installation.

On Windows, launch Excel in Safe Mode by pressing Win+R, entering excel /safe, and pressing Enter. Safe Mode starts Excel with some features and add-ins disabled. If Excel behaves normally there, an add-in or startup customization is a likely lead, though this test alone does not identify which one. Safe Mode is a Windows troubleshooting option; it is not the same command on Mac.

To test whether a workbook is the trigger, open it only after Excel has started cleanly. If it freezes during opening, try making a copy first. For a workbook that opens but behaves badly, save a copy in a different supported format only when you understand the implications: converting to CSV, for example, removes formulas, formatting, charts, and other workbook features. Do not use a lossy format as a general repair step.

Find common workbook causes

Large or complex workbooks can make Excel appear stuck without being corrupt. Common sources of delay include formulas that recalculate across many rows, volatile functions recalculated frequently, extensive conditional formatting, whole-column references in complex formulas, numerous shapes or images, pivot tables, and links to external workbooks or data sources. A workbook that refreshes queries or connections may also wait on a network, server, or sign-in prompt.

Once you have a safe copy, narrow down the workload instead of deleting content at random. Try the following checks:

  • Notice whether the pause follows a particular sheet, formula edit, filter, pivot-table refresh, or data connection.
  • Check whether Excel is calculating. The status bar may show calculation progress; a large formula workload can take time.
  • Review Data > Queries & Connections for queries that refresh when the file opens, and test a refresh only when you know the data source is available.
  • Inspect external links and formulas that refer to other workbooks, especially if those files are on a disconnected drive or network location.
  • Compare the original with a copy after removing one suspected feature at a time, keeping notes so you can reverse each test.

Changing calculation to Manual is sometimes suggested as a quick fix, but it can leave displayed results out of date. If you use Formulas > Calculation Options > Manual as a temporary diagnostic, record the original setting and calculate deliberately before relying on results. Restore Automatic if that was the workbook’s intended mode.

Test add-ins and update Office

Add-ins can extend Excel, but a malfunctioning or incompatible one may slow startup or interfere with particular tasks. To test them on Windows, choose File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go; clear the checkboxes to disable them temporarily. Also check Excel Add-ins in the same Manage list, because those are a separate category. Close and reopen Excel, then re-enable add-ins one at a time until the problem returns. That identifies a likely culprit more reliably than leaving every add-in disabled.

On Mac, the Windows Safe Mode command and COM Add-ins dialog do not apply. You can review Excel add-ins from Tools > Excel Add-ins, turn off available items for a test, and reopen the app. Add-in availability and controls can vary by type, so consult the provider if a specific extension does not appear there.

Install current Office updates because updates can include fixes and compatibility improvements. In Excel for Windows, use File > Account > Update Options > Update Now. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is installed. If the freeze began immediately after adding third-party software, an update or removal of that software may be relevant; change one thing at a time so you can tell what helped.

Reduce strain on large files

If the issue is tied to a particular workbook, simplify the work it asks Excel to do. For example, a formula copied through hundreds of thousands of rows can be costly when it references entire columns and performs repeated lookups. Limit ranges to the data actually used where practical, remove duplicate formatting rules, and avoid repeatedly refreshing connections that do not need current data. Keep a copy before structural changes, and confirm that formulas and totals still give the expected results afterward.

File format can affect file size and supported features. The standard .xlsx format is suitable for many workbooks but does not store VBA macros. The .xlsb binary format can make some large workbooks smaller or faster to open, but it is not a universal fix and may be less convenient for sharing with systems that expect .xlsx. Keep the original and check compatibility before converting. Saving as .xlsm is appropriate when a workbook needs macros; it does not by itself make Excel run faster.

Hardware and available memory can also limit how smoothly a large workbook runs, particularly when several demanding applications are open. Close unnecessary programs and check whether the computer is low on memory or disk space. This is a diagnostic step, not a substitute for identifying a workbook problem: a file that hangs consistently on one operation may still need its formulas, queries, or design reviewed.

Repair Office or recover a damaged file

If Excel freezes with blank workbooks, in Safe Mode, or after add-ins have been ruled out, repair Microsoft 365. On Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, and select Modify. On Windows 10, look under Settings > Apps > Apps & features. Run Quick Repair first; if the issue remains, consider Online Repair, which requires an internet connection and may take longer. The wording can differ slightly by Windows build.

If only one workbook is affected and it will not open normally, Excel for Windows has an Open and Repair option. Choose File > Open > Browse, select the file, use the arrow beside the Open button, and choose Open and Repair. Work on a copy where possible. Repair may recover a file, but it can also fail or omit damaged content, so compare the result with a backup or earlier version. For a file stored in OneDrive or SharePoint, check its version history before replacing it; earlier versions may provide a cleaner recovery point.

If the workbook is saved locally, check Windows File History or another backup system if one is configured. For cloud files, allow synchronization to finish before opening several copies or overwriting versions. Excel for the web can be a useful comparison for supported workbooks, but it does not support every desktop feature, and a workbook that depends on certain macros, connections, or advanced desktop behavior may work differently. Use another platform as a diagnostic or temporary alternative, not proof that the file is fully repaired.

Frequently Asked Questions

Should I wait when Excel says Not Responding? Usually, wait briefly if Excel has just opened a large file, recalculated formulas, or refreshed data. If there is no progress for a long time and the same freeze repeats, check Task Manager and troubleshoot rather than repeatedly clicking. Ending Excel may lose unsaved changes.

How do I open Excel in Safe Mode? In Windows, press Win+R, type excel /safe, and press Enter. If Excel works there, test add-ins and startup customizations. This command is for Windows and does not launch Excel for Mac in the same mode.

Why does Excel freeze only with one file? That file may contain costly formulas, extensive formatting, external links, queries, or damaged content. Test a copy, note the action that triggers the pause, and isolate likely features one at a time. If it is stored in OneDrive or SharePoint, check whether synchronization or a data connection is waiting.

Will I lose my work if I force-close Excel? Changes saved before the freeze should remain, but unsaved changes may be lost. Reopen Excel and check Document Recovery, then verify any recovered copy carefully. AutoRecover can help but is not guaranteed to contain the latest edits.

Does reinstalling Excel always fix the problem? No. A reinstall or repair may help with damaged Office components, but it will not necessarily fix a problematic workbook, unavailable data source, or incompatible add-in. Test a blank workbook and Safe Mode first; use Quick Repair or Online Repair if the evidence points to the Office installation.

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.