If Excel says Not Responding, first give it a minute without clicking repeatedly; it may be busy calculating, loading a file, or waiting on an add-in. If it stays frozen, protect any recoverable work, then test Excel in Safe Mode and work through the likely causes before forcing it to close.
What Not Responding means
In Excel for Microsoft 365 on Windows, Not Responding is a Windows status indicating that Excel is not currently processing input from its window. It does not identify the cause, and it does not always mean Excel has stopped working. A large calculation, a slow network location, an add-in, or a busy workbook can temporarily keep Excel from responding to clicks.
Look for signs of activity before ending the task. The workbook may be calculating, the pointer may show a busy indicator, or Excel may become responsive again after a delay. A very large workbook or a file with many formulas can take longer than a small, local spreadsheet. Avoid clicking repeatedly or opening more Excel windows while it is busy: extra actions can queue up and make it harder to tell whether the program has recovered.
If Excel has been unresponsive for several minutes with no sign of progress, or the same freeze happens every time you open a particular file, treat it as a recurring problem. The distinction matters: a one-time delay may call for patience, while a repeatable freeze is a reason to investigate the workbook, add-ins, updates, or installation.
What to do before closing Excel
Start with the least destructive option. If the workbook is still open, wait briefly and see whether Excel resumes. If it does, save immediately with Ctrl+S on Windows. On a Mac, use Command+S. If Excel remains stuck, do not assume that every recent change has been saved; forcing the app to close can discard changes since the last save.
When Excel is completely unresponsive, Windows Task Manager can close it, but use that only after waiting and considering recovery options. Press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. The Mac equivalent for closing a stuck app is Option+Command+Esc, then select Excel and choose Force Quit. These actions end the process; they do not repair the underlying cause.
When you reopen Excel, check for a Document Recovery pane or a recovered version of the workbook. Recovery may restore work saved by AutoRecover, but it is not a guarantee and may not include the last few minutes of editing. Compare recovered copies with the file you last saved before replacing anything.
- If Excel becomes responsive, save a new copy before trying more involved troubleshooting.
- If the freeze occurs during a calculation, wait for the calculation to finish before making another change.
- If the file is stored on a network share or cloud service, avoid creating multiple competing copies while sync is in progress.
Recover unsaved work and reduce future loss
Excel’s AutoRecover feature periodically saves recovery information, but it is intended to help after an unexpected closure, not to replace normal saving. In Excel for Microsoft 365 on Windows, review its settings at File > Options > Save. The available options include the AutoRecover interval and whether to keep the last AutoRecovered version if you close without saving. The exact recovery outcome depends on the settings and when Excel last recorded recovery information.
After restarting Excel, check the Document Recovery pane if it appears. You can also look under File > Info for workbook management and recovery options, or use File > Open > Recent and the Recover Unsaved Workbooks option when it is available. Open a recovered file and use Save As to create a separate copy until you have confirmed it contains the changes you need.
For a workbook saved to OneDrive or SharePoint, AutoSave can save changes continuously when the feature is on and the file is in a supported cloud location. Cloud version history may also let you review or restore an earlier version. This is different from AutoRecover: AutoSave and version history depend on the cloud file and sync state, while AutoRecover is a local recovery mechanism. Check the file’s current status before restoring a version so you do not overwrite newer work.
Test Excel in Safe Mode
Safe Mode starts Excel with many customizations and add-ins disabled, making it a useful way to find out whether an extension or startup setting is involved. Close Excel first if possible. On Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens and behaves normally in Safe Mode, an add-in or customization is a plausible cause. This test does not prove which one is responsible.
To disable COM add-ins in normal Excel, open File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. Clear the selected add-ins, restart Excel normally, and see whether the freeze returns. If it does not, enable add-ins one at a time, restarting and checking after each change. This narrows down the culprit more reliably than turning everything back on at once. Excel add-ins are managed separately, so use the Manage list to choose Excel Add-ins if you need to check those too.
If Excel still freezes in Safe Mode, an add-in is less likely to be the explanation. The issue may instead involve the workbook, Office installation, Windows environment, or a file location. Safe Mode is a diagnostic startup, not a repair, and some features will be unavailable while it is running.
Check whether the workbook or its location is the problem
Try opening a blank workbook and using Excel for a few minutes. If a blank file works but one particular workbook freezes, focus on that file. It may contain extensive formulas, large data ranges, external links, connections, PivotTables, conditional formatting, or macros that take time to process. A workbook can also be slow because it is stored somewhere Excel cannot reach reliably, such as a disconnected network drive or a cloud folder still syncing.
Make a copy of the workbook before investigating. If the original opens, save a copy to a local folder and test that copy. A local copy can help distinguish a workbook problem from network or sync delays, though it will not fix a damaged file or a costly calculation. If Excel hangs while opening the file, try Excel’s Open dialog and its Open and Repair option when available: choose File > Open > Browse, select the file, open the menu beside the Open button, and choose Open and Repair. Repair attempts can alter or remove damaged elements, so keep the untouched copy.
For calculation-heavy workbooks, check whether the delay happens after editing a formula or opening the file. Recalculating a large model can take time, especially when formulas depend on many cells or external data. Do not switch calculation settings casually: changing calculation behavior can leave displayed results out of date. If you know the workbook is intended to calculate automatically, restore that setting after testing and confirm important results have recalculated.
Update Office and repair the installation
If Excel freezes across several unrelated workbooks, install available Microsoft 365 updates. In Excel for Windows, use File > Account > Update Options > Update Now. The labels or availability can differ if an organization manages Office updates. Restart Excel after the update and check whether the problem persists.
You can also repair Microsoft 365 through Windows. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. In Windows 10, the comparable route is Settings > Apps > Apps & features, then select Microsoft 365 and choose Modify. Run Quick Repair first. If that does not help, Online Repair is a more thorough option and may require an internet connection and sign-in afterward. Save and close Office files before either repair.
Repairing Office is more appropriate when the problem affects Excel broadly than when only one workbook is slow. If only one file triggers the freeze, investigate that file first. If the problem continues after updates and repair, note when it happens, whether Safe Mode changes it, and whether it affects other Office apps; those details help IT support or Microsoft support narrow the cause.
Reduce recurring freezes
Good workbook habits reduce the chances of long waits, though they cannot prevent every crash. Save important work regularly and keep a backup before making large structural changes. Avoid keeping multiple copies open and editing them at the same time, especially when cloud syncing is involved. Close unused workbooks and applications if the computer is under heavy load.
- Keep formulas, formatting, and conditional formatting limited to the ranges that need them rather than applying them to entire columns without a reason.
- Review external links and data connections when a workbook waits during opening or refresh.
- Use a local copy as a diagnostic comparison when a network or synced file is slow.
- Install updates through the normal Microsoft 365 update channel, and ask your organization’s administrator before changing managed settings.
- Save a clean copy before removing macros, connections, or workbook features; those elements may be essential to how the file works.
Do not assume that a powerful computer will eliminate every Excel freeze. A workbook may be waiting for a remote source, an add-in, or a long calculation rather than simply running out of memory. Likewise, seeing Not Responding once does not by itself mean the workbook is corrupted. Repeated behavior and controlled comparisons—blank workbook versus problem file, normal startup versus Safe Mode, local file versus network copy—provide more useful clues.
Windows, Mac, and Excel for the web
The steps above primarily describe Microsoft 365 Excel on Windows. On a Mac, use Command+S to save and Option+Command+Esc to force quit an unresponsive app. The Windows Safe Mode command and Windows repair paths do not apply directly to Mac. If Excel for Mac repeatedly freezes, update Office through its available update mechanism, restart the Mac, and check whether the issue affects one workbook or all workbooks before considering a reinstall or contacting support.
Excel for the web runs in a browser, so a stuck workbook may involve the browser tab, network connection, or cloud service rather than the desktop Excel process. Give it time to sync, check the connection, and avoid closing the tab if unsaved edits may remain. If the file is available, open it in the desktop app as a comparison, or try a supported browser. Do not assume desktop recovery options such as Windows Safe Mode are available in the web version.
Frequently Asked Questions
Should I wait or force close Excel? Wait briefly if Excel may be calculating or loading, and avoid repeated clicks. If it remains frozen for several minutes with no progress, force closing may be necessary, but unsaved changes can be lost. Reopen Excel afterward and check for recovered work.
Why does Excel say Not Responding when calculating? A complex formula or large workbook can keep Excel busy and temporarily prevent it from processing window input. Wait for the calculation to finish. If the same workbook repeatedly takes an unreasonable time, investigate its formulas, data connections, and workbook design.
How do I open Excel in Safe Mode? On Windows, press Windows key+R, enter excel /safe, and press Enter. If Excel works in Safe Mode but freezes during a normal start, disable add-ins and test them one at a time.
Can I recover an Excel file I did not save? Sometimes. Reopen Excel and check the Document Recovery pane, or look for Recover Unsaved Workbooks under File > Open > Recent. Recovery depends on whether Excel created recovery information, so it may not include your latest edits.
Why does only one Excel file freeze? That points toward something specific to the workbook or its storage location, such as complex calculations, an external connection, file damage, or sync delays. Test a copy locally and compare it with a blank workbook before changing or repairing the original.
Related
- Debt Snowball Budget Spreadsheet: Build and Use One
- How to Add a Transition Effect to a Shape in PowerPoint
- How to Add Timed Transitions in PowerPoint
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Null Error in Excel: Causes and FixesIn Excel, the #NULL! error usually means a formula asks for the intersection of two cell ranges that…
- Excel Interpolate Missing Values: 4 MethodsYes, Excel can interpolate missing values, and the best method depends on your data: use =FORECAST() or =TREND()…
- COUNTIF Duplicates in Excel: Examples and Ways to Fix ThemTo count how often a value appears in Excel, enter =COUNTIF($A$2:$A$7,A2) beside your list and fill it down.…
- Excel Send -1 Error: What It Means and How to Fix ItIf Excel VBA reports “Run-time error ‘-1 (ffffffff)’: Method ‘Send’ of object ‘_MailItem’ failed,” Excel could not complete…
- ISBLANK Not Working in Excel? Find the Real CauseISBLANK is usually working as designed: it returns TRUE only when the cell it checks has no contents.…
- XLOOKUP Not Working? Common Causes, Checks, and FixesIf XLOOKUP is not working, first check that your Excel version supports it, then verify the lookup value…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.