If Excel displays “Not Responding,” Windows is not getting a timely response from the app; Excel may be busy calculating or opening a file, or it may have become stuck. Wait briefly before closing it, especially if the workbook is large, and avoid repeated clicks; if the pause continues, use the steps below to protect your work and identify the cause.
What the “Not Responding” message means
On Windows, the message usually appears in Excel’s title bar when the program is not processing ordinary Windows messages quickly enough. It describes Excel’s current responsiveness, not the exact cause. The app might still be working in the background, for example calculating formulas, refreshing data, loading a workbook, or running a macro. A genuinely stuck app can look the same from the outside.
A short pause is common after a demanding action. A workbook with many formulas, external links, PivotTables, or connections to remote data can take time to open or refresh. If the Excel window becomes responsive again and the status bar or screen shows progress, let the operation finish. If there is no change for several minutes, the same freeze recurs, or the app remains unresponsive after the task should have ended, troubleshoot rather than assuming it will recover.
What to do first when Excel freezes
Give Excel a moment and look for signs of activity. If the workbook is on a network location or contains large data sets, waiting longer may be sensible than it would be for a small local file. Do not keep clicking buttons or opening menus: queued clicks can trigger unwanted actions if Excel suddenly catches up.
- Wait at least a minute for a routine pause. For a large calculation or data refresh, allow more time if there is visible progress or you know the task is substantial.
- If Excel appears to be calculating, try Esc once. For a calculation that will not stop, Ctrl+Break on Windows may interrupt it and bring up a prompt. Some laptops require Fn with the Break key, and the key combination may not work on every keyboard.
- If the window is still completely unresponsive, avoid repeatedly pressing save or switching commands. Windows Task Manager can show whether Excel is still running, but “Not responding” there does not by itself prove that the workbook is unrecoverable.
- End the Excel task only as a last resort. Unsaved changes since the last save may be lost, and a forced close cannot undo actions in the workbook.
On Mac, Windows’ “Not Responding” title-bar wording and Task Manager steps do not apply. If Excel is frozen, wait first; if it does not recover, use Apple menu > Force Quit to close it as a last resort. Mac keyboard shortcuts and recovery prompts differ from Windows.
Protecting unsaved work and recovering a workbook
If Excel recovers, save a new copy before continuing to troubleshoot. Use File > Save As and choose a local folder, such as Documents, with a different file name. Saving a copy protects the current state from experiments that could cause another freeze. If the workbook is already saved in a cloud location, check that synchronization has completed before assuming the latest version is safely stored there.
After Excel closes unexpectedly, reopen it and look for the Document Recovery pane. Excel may offer one or more recovered versions; open the most recent one and inspect it before saving. You can also check File > Info > Manage Workbook for available recovery options, including Recover Unsaved Workbooks when that option is shown. What appears depends on whether AutoRecover was enabled and when Excel last saved recovery data, so recovery is not guaranteed.
AutoRecover is intended to help restore work after an unexpected interruption; it is not a substitute for saving. In Excel for Microsoft 365 on Windows, review its settings at File > Options > Save. The interval and file-location settings determine how often recovery information is stored. For important work, save regularly, keep a separate backup, and consider using OneDrive or SharePoint version history where available.
Common causes of Excel becoming unresponsive
The same message can result from different workloads, so note what you did just before the freeze. A pause that happens only when one particular workbook opens points toward the file or its contents. A pause in several unrelated workbooks suggests a broader issue, such as an add-in, Office installation, or device resource constraint.
- Heavy calculations: Large formula ranges, array calculations, volatile functions, and complex dependencies can make recalculation slow. A workbook that recalculates after every edit may appear frozen during that work.
- Data operations: Power Query refreshes, PivotTable updates, external links, and connections to a slow server or web source can delay interaction while data is retrieved or processed.
- Macros and add-ins: A VBA macro or third-party add-in can perform a lengthy task or fail to return control to Excel. Add-ins can affect all workbooks, while a macro may affect only the workbook that runs it.
- Workbook size or complexity: Large sheets, extensive formatting, many objects, or a large volume of data can use substantial memory and processing time. A 64-bit edition can address more memory than a 32-bit edition, but it does not make an inefficient workbook automatically fast.
- File access and environment: A workbook on a network share, removable drive, or synchronized folder may be delayed by connection or synchronization problems. Security software, a printer driver, or graphics and display issues can also be relevant in particular cases.
Check whether the problem is in one workbook
Once Excel is responsive, open a blank workbook and try ordinary tasks such as typing a value and saving. If that works normally but one file repeatedly hangs, make a copy of the problem workbook and use the copy for diagnosis. If the file is shared, avoid troubleshooting by editing the only shared copy while other people are working in it.
In the copied file, consider the action that triggers the delay. If it happens while opening, test whether the workbook is waiting on links or data connections; do not blindly disable or refresh connections if the workbook depends on them. If it happens after changing a cell, the change may trigger broad recalculation. If refresh is the trigger, check whether the source is reachable and whether the refresh normally takes a long time.
For a calculation-related pause, you can temporarily choose Formulas > Calculation Options > Manual and then test the workbook. This changes when formulas recalculate; it does not repair a broken workbook, and displayed results may be out of date until you recalculate. Restore Automatic calculation when appropriate. Calculation mode can affect other open workbooks in the same Excel session, so note the original setting and verify results before relying on them.
Test Excel in Safe Mode and check add-ins
Safe Mode starts Excel without some startup features and add-ins, making it a useful comparison test. Close Excel, press Windows key + R, type excel /safe, and press Enter. If Excel behaves normally in Safe Mode but freezes during ordinary startup, an add-in, startup file, or customization is a plausible cause. Safe Mode is a diagnostic step, not a permanent fix.
To review add-ins in normal Excel, open File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go. Clear the check boxes to disable the selected COM add-ins temporarily, then restart Excel and test. You can similarly review Excel Add-ins using the Manage list. Disable items systematically and re-enable them one at a time to identify whether a particular add-in brings the problem back. The names and choices depend on what is installed.
If the issue began after installing an add-in, updating it or leaving it disabled may resolve the conflict. Do not remove an add-in your organization requires without checking with its administrator. Also, a clean Safe Mode test does not prove that an add-in is at fault; it narrows the possibilities and should be followed by controlled testing.
Update or repair Microsoft 365
If several workbooks freeze, install available Office updates. In Excel for Microsoft 365 on Windows, go to File > Account > Update Options > Update Now. The exact availability of update controls can depend on how Microsoft 365 is installed or managed by an organization. Restart Excel after an update and check whether the problem remains.
If updates do not help, repair Office through Windows Settings. Open Settings > Apps > Installed apps, find Microsoft 365, select its additional options, and choose Modify. Run Quick Repair first. If the issue continues, Online Repair is a more thorough option and may require an internet connection and sign-in afterward. Windows labels can vary slightly by release. Save and close Office files before repairing; repair is different from deleting a workbook, but it can change or restore Office components and settings.
Reduce repeat freezes and choose the right next step
Once Excel works again, prevent a repeat by matching the remedy to the trigger. For a slow workbook, simplify unnecessary formulas or formatting, avoid recalculating oversized ranges when a smaller range is sufficient, and refresh external data only when needed. For files on shared storage, confirm that the connection is stable and allow synchronization to finish. Do not remove formulas, links, macros, or connections simply because they look complex: first confirm what the workbook is intended to do.
Keep Excel and Windows updated, save important work often, and use a backup or version history for files that matter. If only one workbook is affected and it continues to hang after reasonable checks, use a clean copy and consult the file owner or your organization’s IT support before attempting advanced repair. If every workbook is affected even after add-ins are disabled and Office is repaired, contact Microsoft support or your IT administrator with details of the steps that reproduce the issue.
Frequently Asked Questions
Should I wait or close Excel when it says Not Responding?
Wait first, particularly if Excel is opening a large file, calculating, or refreshing data. If there is no sign of progress and the app stays frozen, closing it may become necessary, but unsaved changes can be lost. Try to recover work when Excel restarts.
Will Excel save my work if I force it to close?
Not necessarily. Excel may offer recovered work from AutoRecover the next time it opens, but recovery depends on its settings and the last recovery save. Changes since your last save may be missing, so forced closing should be a last resort.
Why does Excel say Not Responding when calculating?
A calculation can occupy Excel long enough that Windows marks the window unresponsive. Large formula dependencies or complex workbook calculations can cause this. Wait for the calculation to finish, or try Esc; Ctrl+Break may interrupt a calculation on Windows.
Why does Excel freeze only with one file?
That often points to something specific in the workbook, such as formulas, macros, external connections, size, or file damage, rather than a general Excel failure. Test a copy and note whether opening, editing, recalculation, or refresh triggers the freeze.
Does Excel Safe Mode delete or change my files?
No. Starting Excel with excel /safe is a way to test the application with a reduced set of startup features. It does not itself delete workbooks. Save important work before making other changes, and use Safe Mode only as a diagnostic comparison.
Related
- How to Create a PowerPoint Background Template That Works
- Excel Data Validation Table Column: Dropdowns That Expand
- Construction Budget Spreadsheet: Plan Costs and Track Changes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Conditional Formatting: Add Color to Cells by RuleTo add color conditional formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home…
- Excel Keyboard Shortcut to Resize a Column or AutoFitIn Excel for Microsoft 365 on Windows, select a cell in the column and press Alt, H, O,…
- Excel Insert Row Shortcut: Steps for Windows and MacIn Excel for Microsoft 365 on Windows, select the row where you want a new row, then press…
- Freeze Panes in Excel: How to Edit Rows and ColumnsTo edit frozen panes in Excel, open View > Freeze Panes, choose Unfreeze Panes, then select the cell…
- Excel Unable to Find Circular Reference?If Excel is unable to find a circular reference, open Formulas > Error Checking > Circular References and…
- Excel Freeze Panes: Repeat Rows on Every Printed PageNo: Excel’s Freeze Panes setting keeps rows or columns visible while you scroll, but it does not make…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.