Excel Sheet Not Responding? Causes and Safe Fixes Guide

How-to basics · Updated November 21, 2026

If Excel says Not Responding, first give it a few minutes if it may be calculating, refreshing data, or opening a large file; then try Esc to cancel a long operation and save if the window becomes responsive. If it remains frozen, use the steps below to isolate the cause before force-closing Excel, because closing it can discard unsaved changes.

What Not Responding means

Excel for Microsoft 365 on Windows displays Not Responding when the application is not processing Windows messages quickly enough to keep the window interactive. That message does not, by itself, prove Excel has crashed. A large calculation, a connection refresh, a slow network location, or a temporary shortage of available memory can leave the interface unresponsive while work continues.

It also helps to distinguish an application freeze from a worksheet problem. Excel may be open and usable while one sheet seems stuck because a cell is being edited, a dialog box is hidden behind another window, or a particular workbook is taking a long time to process. Check whether the mouse pointer, ribbon, and other open workbooks respond. If only one file triggers the problem, focus on that workbook rather than assuming all of Excel is damaged.

Start with the safest checks

Before ending the task, consider what Excel was doing just before it stopped responding. Opening a large workbook, filling thousands of formulas, refreshing a PivotTable, importing data, or recalculating after a change can take time. Repeatedly clicking the window or launching more copies of Excel can add confusion and may slow the computer further.

  • Wait a few minutes, especially if the workbook is large or Excel was refreshing or calculating. Watch for activity such as changing status text or renewed response from the window.
  • Press Esc once to try to cancel the current operation. For some calculations, Ctrl+Break can also interrupt processing; on keyboards without a Break key, the combination may differ.
  • Check for a dialog box waiting for a response. Use Alt+Tab to cycle through open windows, including file prompts and sign-in dialogs.
  • If Excel recovers, immediately use Ctrl+S to save. On Mac, use Command+S.
  • If the workbook is stored on a network drive or cloud service, check whether the connection is available. Avoid disconnecting or moving the file while Excel is actively saving.

On a Mac, the same general principle applies: wait for a long operation to finish before force-quitting. The Mac equivalent for saving is Command+S. If Excel must be closed, use the Apple menu > Force Quit only after recognizing that unsaved work may be lost.

Check whether the workbook is the cause

Try opening a blank workbook or a different, smaller file. If those work normally but one workbook repeatedly freezes, the cause is more likely to be specific to that file or its contents. A workbook can become slow because it contains extensive formulas, large data ranges, many objects or formatting rules, external links, or queries that contact another source.

Consider what changed recently. Did the issue begin after adding a formula, importing a CSV, copying a large range, inserting images, or connecting to a database? If you can open the file, test a copy rather than experimenting on the only original. A simple comparison is to open the workbook on another computer or in Excel for the web, if the file is stored in OneDrive or SharePoint. Different results can point toward a local add-in, installation, device, or network issue, though the web version may not support every workbook feature.

For a workbook that opens but becomes slow during calculation, look for formulas applied to entire columns when only a smaller range is needed, repeated lookup or array calculations, and formulas that refer back to one another. External links and data connections can also wait on unavailable sources. Avoid changing calculation settings as a first response: manual calculation can make a workbook appear faster while leaving displayed results out of date. If you use that setting for diagnosis, restore the intended setting and recalculate before relying on the results.

Test Excel without add-ins

An add-in can affect startup, menus, or workbook operations. Windows Safe Mode is a useful diagnostic because it starts Excel with certain startup features and add-ins disabled. Close Excel if possible, press Windows key+R, type excel /safe, and press Enter. If Excel behaves normally in Safe Mode, an add-in or startup customization is a reasonable suspect, although this test does not identify which one.

To check COM add-ins in a normal Excel session, use File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go. Clear the checkbox for an add-in to disable it temporarily, then restart Excel and test. You can re-enable items one at a time to find a possible conflict. The list of available add-ins and the exact interface can vary depending on what is installed.

Excel for Mac does not use the Windows excel /safe launch command. To investigate an add-in there, open Excel and use Tools > Excel Add-ins, or check the add-in’s own instructions. Disable only add-ins you recognize and can restore. If Safe Mode also freezes, continue checking the workbook, installation, and available system resources rather than assuming an add-in is responsible.

Recover work before closing Excel

If the window stays frozen, there may be no safe way to save the latest edits from that session. Give Excel time first, particularly if the computer is still busy. If you have no alternative, press Ctrl+Shift+Esc on Windows to open Task Manager, select Microsoft Excel, and choose End task. This is a last resort: unsaved changes since the most recent save can be lost. Do not end unrelated processes just because they appear busy.

After restarting Excel, look for the Document Recovery pane, which may appear automatically if Excel detects an interrupted session. Review the available versions and save the recovered file under a new name before replacing the original. You can also check File > Info > Manage Workbook for recovery options, including Recover Unsaved Workbooks when available. Recovery depends on settings, the type of failure, and whether Excel had a recoverable copy; it is not guaranteed to restore every change.

AutoRecover and AutoSave are different. AutoRecover periodically saves recovery information for many locally edited workbooks, but it is not a substitute for saving. AutoSave is generally available for eligible files saved to OneDrive or SharePoint while the relevant account and feature are active. If a cloud file has conflicting versions, review the version history before overwriting one; do not assume the newest timestamp is always the version you intended to keep.

Check updates, file safety, and the Office installation

If multiple workbooks freeze, restart the computer and install available Microsoft 365 updates. In Excel for Windows, check File > Account > Update Options > Update Now. The choices can be managed by an organization, so a work or school device may not show the same controls. On Mac, check Help > Check for Updates if Microsoft AutoUpdate is installed, or use the update method provided by your organization.

A file downloaded from the internet may open in Protected View. That is a security feature, not evidence that Excel is broken. Only choose Enable Editing when you trust the source and expected the file. Avoid disabling Protected View globally to solve a single freeze, and do not enable macros in an unknown workbook. If the file is trusted but repeatedly fails, ask the sender for a fresh copy or use Excel’s repair option rather than lowering security protections.

When Excel itself is unstable across files, repair Microsoft 365 on Windows. Open Windows Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, then Modify. Run Quick Repair first; if the issue continues, Online Repair is a more extensive option and may require an internet connection and sign-in afterward. Names and placement can differ slightly between Windows builds. On Mac, Office repair is not offered through that Windows path; update Office, restart the Mac, and use Microsoft support guidance if reinstalling becomes necessary.

Prevent recurring freezes

Prevention usually means making it easier to save, reducing unnecessary work, and identifying slow operations early. Keep a separate backup of important workbooks, especially before major edits or structural changes. For shared cloud files, use version history where available. A backup is more dependable than expecting AutoRecover to restore a particular edit.

  • Save large or important workbooks regularly with Ctrl+S on Windows or Command+S on Mac.
  • Remove unused formatting, duplicate objects, and obsolete sheets from a copy of the workbook, not the sole original.
  • Use appropriately sized ranges for formulas and data operations instead of processing far more rows than the workbook needs.
  • Refresh external data when the source is available, and avoid repeatedly starting the same refresh while Excel is busy.
  • Keep Microsoft 365 and trusted add-ins up to date, and investigate a newly installed add-in if freezes start soon afterward.

For recurring delays in a shared or business-critical workbook, note which action triggers the slowdown, the workbook’s approximate size, whether the file is local or cloud-hosted, and whether other files are affected. Those details are more useful to an IT administrator or support technician than simply reporting that Excel froze. Never send confidential workbook data to a public repair website or an unapproved third-party service.

Frequently Asked Questions

Should I wait or force-close Excel?
Wait if Excel may be calculating, refreshing, or saving, and try Esc once to cancel the operation. Force-close only when it remains unresponsive and you accept the risk of losing changes since the last save.

Why does Excel freeze when I open one file?
That workbook may contain heavy calculations, external connections, large amounts of formatting, or damaged content. Test a separate copy, try a smaller workbook, and note whether opening the file on another device produces the same problem.

Will AutoRecover bring back my unsaved spreadsheet?
It may offer a recoverable version after Excel restarts, but it cannot guarantee recovery of every edit. Check the Document Recovery pane and File > Info > Manage Workbook, then save any recovered copy under a new name.

Can I keep using Excel while it says Not Responding?
Usually the unresponsive window will not accept normal commands until the operation finishes or is interrupted. Avoid repeatedly clicking or opening more copies. If Excel becomes responsive again, save before continuing.

Does Excel Safe Mode delete my add-ins or files?
No. Safe Mode is a diagnostic startup method; it does not itself delete workbooks or add-ins. It starts Excel with certain features disabled, so normal behavior in Safe Mode can help narrow down the cause.

Why does Excel freeze only on a network or cloud file?
A slow or interrupted connection, synchronization delay, permissions issue, or remote data source can affect a workbook that works locally. Check connectivity and the service status, and avoid making competing copies or moving the file during a save.

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.