Excel Not Responding? Causes, Fixes, and Recovery Steps

How-to basics · Updated November 21, 2026

If Excel says “Not Responding,” wait briefly if it is calculating or opening a large file; if it stays frozen, try opening Excel in Safe Mode, disabling add-ins, and checking whether the problem affects one workbook or every workbook. Before forcing Excel closed, allow time for recovery options because ending the task can discard unsaved changes.

What “Not Responding” Means

In Windows, “Not Responding” generally means the program is not currently answering Windows’ requests for updates or user input. It does not automatically mean Excel has crashed or that the workbook is damaged. Excel may be busy calculating formulas, refreshing data, loading a file, communicating with a network location, or waiting for another process. During that work, the window can appear frozen even though Excel may eventually finish.

How long to wait depends on the task and the computer. A workbook with many formulas, pivot tables, external data connections, or large images can take longer than a simple sheet. If the status changes or the workbook begins responding again, let the operation complete. Repeatedly clicking the window or pressing keys can queue additional actions and make it harder to tell whether Excel is recovering.

First consider what happened just before the freeze. Did it start after opening one particular file, pasting a large range, refreshing a query, installing an add-in, or changing a formula? That clue helps distinguish a workbook-specific issue from a problem with the Excel installation or computer.

Try These Safe First Steps

Start with actions that do not risk closing the workbook. If Excel may be processing a calculation or refresh, wait several minutes and watch for signs of activity, such as a changing status message or the workbook becoming responsive. If a dialog box is open behind the main window, Excel may be waiting for a response; use Alt+Tab to look for another Excel window or prompt.

  • If the workbook is stored on OneDrive or SharePoint and AutoSave is on, check that the connection is available and look for a saving or syncing message. Do not assume every recent edit has reached the cloud.
  • If Excel responds intermittently, save a new copy using File > Save As before trying more disruptive troubleshooting. Choose a location on the computer if a network or cloud location may be contributing to the delay.
  • Disconnecting a network drive or closing a data source can affect work in progress. Avoid doing so while Excel is actively refreshing or saving.
  • If Windows indicates that Excel is not responding, do not repeatedly click the title bar. Give it time to finish its current operation.

If the application remains completely unresponsive and waiting is not helping, open Task Manager with Ctrl+Shift+Esc. Select Microsoft Excel under Processes and choose End task only as a last resort. Any changes since the last successful save may be lost. On a Mac, use Option+Command+Esc to open Force Quit, select Microsoft Excel, and choose Force Quit; the same risk to unsaved edits applies.

Recover Unsaved Work After a Freeze

After Excel closes unexpectedly, reopen it and look for the Document Recovery pane. It may show recovered versions of workbooks that Excel saved automatically. Open the most recent version that appears complete, then save it with a clear filename. Compare versions if there is any doubt about which one contains the latest edits.

Excel’s AutoRecover feature can save recovery information at intervals, but it is not the same as a continuous, guaranteed backup. The interval and available recovery data depend on settings and circumstances, and edits made after the last recovery save may be missing. AutoSave is a separate feature generally associated with files saved to OneDrive or SharePoint; availability can depend on the file and account setup. Neither feature is a reason to close a frozen workbook casually.

To check recovery settings in Microsoft 365 for Windows, open File > Options > Save and review the AutoRecover settings. This screen also shows the AutoRecover file location. Do not delete files from that location while trying to recover work. If the recovery pane does not appear, File > Open > Recent may help locate the workbook, but it cannot restore edits that were never saved or recovered.

Check Whether the Problem Is Excel or One Workbook

Try opening a different, known-good workbook, or create a blank workbook from Excel’s start screen. If those work normally while one file repeatedly hangs, focus on that workbook: it may contain complex formulas, damaged content, oversized formatting, external links, or data connections that take a long time to update. If every workbook and even a blank workbook cause trouble, investigate Excel itself, add-ins, updates, or Windows resources.

For a workbook-specific problem, make a copy before changing its contents. If the copy opens, try disabling automatic calculation temporarily through Formulas > Calculation Options > Manual, then investigate expensive formulas or circular references. Manual calculation means formula results may not update until calculation is run, so restore Automatic when appropriate. If the file is on a shared drive, save a copy locally to see whether the delay is related to the storage location or connection.

Large used ranges can also slow a workbook. For example, formatting applied to entire columns across many sheets, or pasting styles into thousands of unused rows, can increase file size and processing. Removing unnecessary formatting or reducing formulas may help, but do this on a copy and check that the workbook’s intended data and layout remain intact.

Start Excel in Safe Mode and Test Add-Ins

Safe Mode starts Excel with some startup features and add-ins bypassed, making it a useful diagnostic test. Close Excel if possible. In Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens in Safe Mode and works normally, an add-in, startup file, or customization may be involved. Safe Mode is a test, not necessarily the permanent fix.

To inspect COM add-ins in normal Excel, select File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and click Go. Clear the check boxes to disable the listed add-ins, restart Excel, and see whether the freeze returns. If that fixes the issue, re-enable add-ins one at a time, restarting as needed, to identify the likely cause. You can also inspect Excel add-ins from the same Manage list by selecting Excel Add-ins and choosing Go.

Add-ins may provide legitimate business functions, so do not remove them blindly. If your organization manages Excel or requires a particular add-in, ask its support team before changing settings. On a Mac, available add-ins and startup troubleshooting options differ; Windows’ excel /safe command does not apply. Test Excel for Mac’s installed add-ins through its Excel settings or contact the add-in provider if the issue is specific to that program.

Update or Repair Microsoft 365

If all workbooks are affected, install available Office updates. In Excel for Windows, go to File > Account > Update Options > Update Now. The Update Options control may not appear if an employer or school manages updates; in that case, ask the organization’s administrator. Save work and close Office applications before installing updates when prompted.

If updating does not help, repair Microsoft 365 through Windows. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, and select Modify. In Windows 10, open Settings > Apps > Apps & features, select Microsoft 365, and choose Modify. Start with Quick Repair. If the problem continues, Online Repair is a more extensive repair and requires an internet connection; follow the prompts and be prepared to sign in again if requested.

Repairing Office is different from repairing an individual workbook. Make a separate copy of important files before broader troubleshooting, especially if the only copy is stored on a shared location. On Mac, Windows’ Modify and Repair controls are not available; update Office through an available Microsoft AutoUpdate prompt or the update options for the installed Office version.

Look for Workload, Storage, and Resource Issues

Excel can become sluggish when a workbook demands more memory or processing than the computer can readily provide. Many volatile formulas, extensive conditional formatting, large data models, complex array calculations, and repeated lookups across large ranges can all contribute. External data connections may also wait on a database, website, or network service. A pause during a refresh is not necessarily proof that Excel itself is defective.

Close unnecessary programs if the computer is low on available resources, and check Task Manager for unusually high CPU, memory, or disk use. Avoid ending unfamiliar Windows processes. If the workbook is on a network share, test a local copy only when doing so is permitted and safe for the data. Do not make simultaneous local edits and then overwrite a shared file without reconciling changes.

For recurring delays, narrow the work down rather than making many changes at once. Refresh one connection at a time, test a copy with some formulas removed, or temporarily disable a specific add-in. Record what changed and whether it improved the behavior. This makes it easier to reverse a change and identify a cause instead of introducing several new variables.

When to Escalate or Avoid Risky Fixes

Contact your organization’s IT team or Microsoft support if Excel keeps freezing after Safe Mode, updates, and repair, particularly if the issue affects multiple users, involves a managed device, or occurs with critical business files. Include the Excel version, Windows version, workbook location, approximate file size, actions that trigger the freeze, and whether a blank workbook behaves the same way. Remove confidential data before sharing diagnostic files or screenshots.

Avoid downloading unofficial “Excel repair” utilities or deleting Office folders and recovery files based on generic advice. Such steps can expose data, remove useful recovery information, or make an installation harder to repair. If a single workbook appears damaged, work on a copy and use Excel’s Open dialog options cautiously; for important or regulated data, ask an administrator before attempting recovery procedures that could alter the file.

Frequently Asked Questions

Should I wait or close Excel when it says Not Responding?
Wait first if Excel recently started a calculation, opening, save, or refresh operation. If it remains frozen for an extended period and no recovery is possible, End task may be necessary, but unsaved changes can be lost. Reopen Excel afterward and check for Document Recovery.

Why does Excel freeze only with one file?
That workbook may be unusually large, contain costly formulas or formatting, rely on external links or data connections, or have damaged content. Test a copy and compare its behavior with a blank workbook; avoid editing the only original while diagnosing it.

Can I recover an Excel file I did not save?
Sometimes. Reopen Excel and check Document Recovery, and review File > Options > Save for the AutoRecover location and settings. Recovery depends on whether Excel created usable recovery data, so it cannot be guaranteed.

Does Safe Mode delete my add-ins or workbook data?
No. Starting Excel with excel /safe is a diagnostic launch and does not itself delete add-ins or workbook contents. Disabling an add-in changes whether it loads; you can re-enable it later if needed.

Why does Excel say Not Responding while calculating?
A complicated or large calculation can keep Excel busy long enough that Windows labels it unresponsive. Allow the calculation to finish if possible. If it happens repeatedly, examine the workbook’s formulas and calculation settings on a copy.

Are Excel for Mac and Excel for the web fixed the same way?
No. The Safe Mode command and Windows Office repair paths above are for Windows desktop Excel. Mac has different force-quit and update options, while Excel for the web runs in a browser and may be affected by the browser, connection, or service. Use troubleshooting steps for the version you are using.

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.