If Excel says Not Responding, first wait a minute or two if the workbook is large or has just opened, saved, or recalculated; the program may be busy rather than frozen. If it stays stuck, try to preserve your work, then check whether the problem affects one workbook or Excel generally, start Excel in safe mode, and investigate add-ins, workbook complexity, and Office updates before forcing Excel to close.
What to do before closing Excel
A Not Responding message means Windows is not receiving a timely response from Excel. It does not, by itself, prove that the workbook or its data is lost. Excel can temporarily stop responding while it performs demanding work, including recalculating formulas, refreshing connections, opening a large file, or saving changes to a slow or unavailable location.
Give the program time if you can see signs of activity, such as disk use or changing CPU activity in Task Manager. Avoid repeatedly clicking the window: that can queue up more actions and make it harder to tell whether Excel is recovering. If the window becomes usable, save immediately. If the workbook is on OneDrive or a network location, save a separate local copy using File > Save As, if Excel allows it.
If there is no recovery after several minutes and the process appears stuck, you may have to close it. On Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. This can discard unsaved changes, so use it only when waiting is no longer useful. The equivalent keyboard shortcut on Mac is Command+Option+Esc, which opens Force Quit; select Excel there. Windows Task Manager instructions do not apply to Excel for the web, where closing the browser tab is a different action.
Find out whether Excel or one workbook is the problem
Before changing settings, compare a few situations. Can Excel open a new blank workbook? Do other workbooks open normally? Does the same file hang on another computer or in Excel for the web? These checks help separate a general application problem from a file-specific or device-specific one.
- Only one workbook hangs: suspect its size, formulas, links, data connections, formatting, or possible file damage.
- Every workbook hangs: investigate add-ins, Office installation or updates, and system resources.
- The file works elsewhere: the original computer, its Excel configuration, or its connection to the file location may be involved.
- The file hangs only from a shared location: test a copy saved locally, while taking care not to create conflicting versions of a shared workbook.
Make a copy before experimenting with a valuable file. If it is stored in a synced folder, check whether OneDrive has finished syncing and whether the file is available locally. A slow network, interrupted sync, or a busy shared location can delay opening or saving without meaning that the workbook itself is corrupt.
Test Excel in safe mode
Safe mode is a useful Windows diagnostic because it starts Excel with certain startup features and add-ins disabled. Close Excel first if possible. Press Windows key+R, type excel /safe, and press Enter. If Excel opens and behaves normally in safe mode, an add-in or another startup customization is a likely cause. Safe mode is a test, not a permanent repair.
If Excel still hangs in safe mode, the cause may instead be the workbook, the Office installation, or available system resources. Try opening a blank workbook and then the problem file. If safe mode will not launch Excel, continue with the update, repair, and recovery checks below.
The Windows Run command is not a Mac instruction. On Mac, menu labels and add-in controls differ, and safe-mode troubleshooting is not started with excel /safe. Use Excel’s Mac settings and add-in controls, and check whether the same file behaves differently in another supported Excel environment before changing application preferences.
Check add-ins and startup files
If safe mode works, disable add-ins in normal Excel and test again. In Microsoft 365 for Windows, open File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. Clear the check boxes, select OK, and restart Excel. If the issue stops, re-enable add-ins one at a time, restarting and testing after each change. This can identify the specific add-in without leaving all of them disabled.
Excel also lists other add-in types in the Manage list, including Excel Add-ins. Check those separately if disabling COM add-ins does not help. Add-ins can provide legitimate features such as data connectors or analysis tools, so do not remove one permanently unless you know it is unnecessary. If your organization manages Microsoft 365, ask its support team before changing a required business add-in.
On Mac, do not expect the Windows File > Options path. Excel settings and add-in management are arranged differently; the available controls depend on the add-in type and Excel version. The diagnostic principle is the same: disable optional add-ins, restart Excel, and re-enable them individually to find a trigger.
Look for workbook-specific causes
A workbook can be difficult to open or edit even when Excel itself is functioning. Large files with many formulas, extensive conditional formatting, numerous objects, external links, or imported data may take time to process. A workbook can also become slow after repeated editing has left formatting or used ranges extending far beyond the visible data. These are possibilities to investigate, not proof that any one feature is responsible.
If the file opens eventually, work on a copy and narrow down what makes it slow. For example, if it contains several sheets, test a duplicate with some nonessential sheets removed. Check whether a particular action, such as filtering a table or changing a value, triggers the delay. Look for links to files that have moved and queries or connections that refresh when the workbook opens. Do not delete data or connections from the original just to test a theory.
Excel may also display a security prompt or wait for confirmation behind another window. Check the taskbar and use Alt+Tab on Windows to look for a dialog that is waiting for input. This is especially worth checking when a workbook opens from email, a shared folder, or another application. On Mac, use Command+Tab to switch between applications, though the relevant window controls differ.
If Excel offers a repair prompt when opening a file, keep an untouched copy first and follow the prompt only if you accept that some workbook content might not be recoverable. For a copy that opens, Save As to a new file name can help distinguish a problem with the original file from a broader Excel problem.
Understand calculation delays
Formula recalculation is a common reason Excel appears frozen after an edit or when a workbook opens. A change in one cell can affect many dependent formulas. Workbooks that use large ranges, repeated complex calculations, or formulas that recalculate frequently can take longer than expected, especially on a computer with limited available memory or processing capacity.
Wait for calculation to finish before making more edits. If Excel recovers, check the status bar for calculation activity and consider reviewing formulas or reducing unnecessary calculations in a copy. Excel’s calculation options are under Formulas > Calculation Options. Changing from Automatic to Manual can reduce repeated recalculation, but it also means results may not update until calculation is triggered. That can leave displayed results out of date, so it is not a general fix to apply without understanding the workbook.
For a shared or business-critical workbook, coordinate calculation-setting changes with other users. A workbook may be designed to recalculate automatically, and manual mode can lead someone to rely on stale values. Improving formula design or splitting an oversized task may be safer than changing calculation behavior for everyone.
Update or repair Microsoft 365
If Excel hangs with multiple files, install available Office updates. In Excel for Windows, use File > Account > Update Options > Update Now. If Excel will not stay open long enough, update Microsoft 365 through the method used to install and manage Office on that computer, or ask the organization’s administrator if updates are centrally managed. Update labels and availability can vary by licensing and management settings.
If updates do not help, repair the Office installation. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, select its menu, and choose Modify. The available repair choices depend on the Windows and Office installation; Quick Repair is a reasonable first attempt, while Online Repair is more thorough and may require internet access and sign-in afterward. Save and close Office apps before starting a repair. On Mac, Windows Settings repair steps do not apply; use Microsoft’s current Mac update and troubleshooting guidance or contact your administrator.
Also check that the computer has enough free storage and close other demanding applications during a test. Very low system resources can make Excel and other programs slow, but adding memory or changing hardware is not the first step unless diagnostics point to a resource limit.
Recover unsaved work carefully
After Excel closes unexpectedly, reopen it and look for the Document Recovery pane. It may show recovered versions that Excel saved automatically; open the most recent plausible copy and save it under a new name. Recovery is not guaranteed, and the latest recovered version may be older than the changes you remember making.
On Windows, you can also check File > Info > Manage Workbook for available recovery options, including Recover Unsaved Workbooks where offered. The exact options depend on how the file was saved and Excel’s settings. For future work, review File > Options > Save and confirm that AutoRecover information is being saved at a useful interval. AutoRecover is a fallback, not a substitute for saving regularly, and it does not guarantee recovery of every edit.
Reduce the chance of another freeze
Once the immediate issue is resolved, reduce the conditions that make a repeat more likely. Keep a working backup before major edits, use a local copy when diagnosing a shared-file delay, and avoid leaving unnecessary applications open during large calculations. If a particular add-in or connection repeatedly causes trouble, check for an update or ask its provider or your IT team about compatibility.
- Save valuable work regularly, especially before refreshing data or running a large calculation.
- Keep Microsoft 365 and trusted add-ins up to date, subject to your organization’s update policy.
- Use copies to test changes to formulas, formatting, links, and calculation settings.
- Record what action triggers the hang and whether other workbooks are affected; those details make support requests more useful.
A brief pause is not necessarily a failure, and a Not Responding label alone does not identify the cause. The most useful sequence is to allow time for legitimate work, compare the problem file with a blank workbook, test safe mode, and then make targeted changes rather than repeatedly forcing Excel to close.
Frequently Asked Questions
Should I wait or force-close Excel? Wait if the workbook may be opening, saving, refreshing, or recalculating and the computer shows activity. If it remains unresponsive for several minutes with no sign of progress, closing it may be necessary, but unsaved changes can be lost.
Why does Excel say Not Responding when calculating? Excel may be busy recalculating formulas and therefore unable to respond to clicks temporarily. Large dependency chains or complex workbooks can extend the delay. Let calculation finish, then investigate formulas and calculation settings on a copy.
Will I lose my file if I end the Excel task? The saved file should remain, but changes since the last save may be lost. Excel may offer recovered work after restarting, but recovery is not guaranteed. Save a recovered version under a new name rather than overwriting the only copy immediately.
How can I tell whether an add-in is causing the freeze? Start Excel in safe mode on Windows. If the issue goes away, disable add-ins in normal mode and re-enable them one by one, restarting Excel between tests. If safe mode also hangs, an add-in is less likely to be the only cause.
Why does only one Excel file keep freezing? That workbook may have unusually heavy calculations, links, connections, formatting, or other content that takes time to process. Test a copy and compare it with a blank workbook. If the same file also hangs on another computer, the workbook itself or its data sources deserve closer investigation.
Related
- Data Validation Interview Questions and Strong Answers
- Data Validation Greyed Out in Excel? Causes and Fixes
- Excel Data Validation Guidelines for Reliable Spreadsheets
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Error Checking: Find and Fix Formula ErrorsIn Excel for Microsoft 365 on Windows, select the cell with the problem and choose Formulas > Formula…
- VLOOKUP Not Working in Excel? Show the Formula FixIf VLOOKUP appears in a cell instead of returning an answer, first turn off Formulas > Show Formulas…
- IFERROR VLOOKUP Not Working? Common Causes and FixesIFERROR with VLOOKUP usually seems not to work because the formula is malformed, the problem is not an…
- Excel Data Validation Rule Error: Causes and FixesAn Excel data validation rule error usually means the entered value does not meet the cell’s rule, or…
- Excel File Won’t Open: How to Repair ItIf an Excel file will not open, first make a copy of it, then use Excel for Microsoft…
- Excel File Too Large Because of Blank Cells? Fix ItYes—an Excel workbook can become unusually large when cells that look blank contain formatting, spaces, formulas, or other…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.