If Excel says Not Responding, first stop clicking and give it a few minutes: a large calculation, refresh, or file operation can temporarily make the window unresponsive. If it stays frozen, reopen Excel in Safe Mode to check for add-ins, then determine whether the problem affects one workbook or every workbook before repairing Office or forcing Excel to close.
What “Not Responding” means
In Windows, Not Responding is a status message indicating that an application is not currently responding to Windows’ requests. It does not, by itself, prove Excel has crashed or that the workbook is damaged. Excel may be busy calculating formulas, loading data, communicating with a network location, or waiting for another process. A workbook with many formulas or large data ranges can take time even on a functioning computer.
Look for signs of activity before ending the task. The computer may be working hard, the file may be on a slow network or cloud connection, or Excel may become responsive after a brief pause. If the message persists for several minutes with no progress, or Excel repeatedly freezes during the same action, investigate instead of waiting indefinitely. A forced close can lose unsaved changes, so treat it as a last resort.
Try these safe first steps
Start with actions that do not change the workbook. Avoid repeatedly clicking the window or opening more copies of Excel; extra requests can add to the delay and make it harder to tell whether the original task is progressing.
- Wait briefly and note what Excel was doing when it froze: opening a file, editing a formula, refreshing data, printing, or saving.
- Check whether another dialog is hidden behind Excel. Press Alt+Tab to switch between open windows. A confirmation or sign-in dialog can make the main Excel window seem stuck.
- Check whether the file is still being copied, downloaded, or synchronized. If it is on a shared drive or cloud folder, connection delays may be relevant.
- If Excel remains frozen and you accept the risk of losing unsaved work, press Ctrl+Shift+Esc to open Task Manager. Select Microsoft Excel and choose End task. Reopen Excel once; look for Document Recovery if it appears.
On a Mac, use Command+Option+Esc to open Force Quit, select Microsoft Excel, and choose Force Quit. The Windows Task Manager instructions and Windows Safe Mode command below do not apply to Mac.
Use Safe Mode to check add-ins
Safe Mode starts Excel with certain startup items and customizations bypassed, making it a useful way to check whether something loaded into Excel is causing the freeze. Close Excel first. In Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens and remains responsive in Safe Mode, an add-in or startup customization is a likely cause; it is not proof that a particular add-in is responsible.
To investigate, close Safe Mode and start Excel normally. Go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then select Go. Clear the check boxes to disable the listed add-ins temporarily, restart Excel, and test. You can also check Excel Add-ins in the same Manage list. If the freeze stops, turn add-ins back on one at a time, restarting and testing after each change. That helps identify the specific item rather than leaving every add-in disabled.
Some add-ins provide important business or accessibility functions. If an add-in is required, check with its publisher or your organization’s IT support for an update before removing it. In Excel for Mac, add-in controls and startup behavior differ; use Excel’s Tools menu for available add-in options rather than the Windows Safe Mode command.
Find out whether it is one workbook or all of Excel
Open a new blank workbook and try a few simple actions. If that works normally but one particular file repeatedly freezes, focus on that workbook: its size, formulas, links, data connections, or file condition may be involved. If blank workbooks also freeze, look more broadly at add-ins, Office updates, available memory, and other software or system issues.
For a workbook-specific freeze, note the action that triggers it. A delay only while opening may point to startup calculations, linked files, or a slow location. A delay after editing a cell may be caused by formulas recalculating. A freeze during saving may involve the destination, synchronization, or the file itself. Test a copy stored in a local folder if you have permission and can do so safely; do not overwrite the original while diagnosing. If the file belongs to a team or uses shared data, coordinate before changing its location or contents.
If Excel can open the file but it behaves abnormally, use File > Open > Browse. Select the workbook, choose the arrow beside the Open button, and select Open and Repair if that option is available. Choose Repair first. This can help with a damaged workbook, but it is not a guarantee and may not preserve every feature. Keep an untouched copy of the original.
Check calculation and workbook workload
Formula-heavy workbooks can appear frozen while Excel recalculates. This is especially plausible after changing a value used by many formulas, opening a workbook set to recalculate, or working with large ranges and volatile formulas. If Excel becomes responsive after the calculation finishes, the issue may be workload rather than a broken installation. Reducing unnecessary formulas or limiting formulas to the rows actually used can improve responsiveness, but make changes only after checking how the workbook is meant to work.
In Excel for Microsoft 365 on Windows, check Formulas > Calculation Options. If calculation is set to Manual, formulas will not recalculate automatically after every change; pressing F9 requests a calculation. Automatic calculation may take longer on a large workbook, while manual calculation can leave displayed results out of date until recalculated. Do not switch modes casually in a shared or important workbook. Calculation mode can affect other open workbooks, and a workbook may intentionally use Manual to manage a heavy model.
Large pasted data ranges, complex conditional formatting, and extensive formatting applied to unused rows can also make a workbook slower to edit, save, or calculate. If the problem began after a recent change, try undoing that change only if Excel is responsive and you understand its effect. Do not delete formulas or formatting from a production workbook simply to see whether it helps.
Consider connections, shared files, and security prompts
Excel can wait on work outside the workbook. Refreshing a query, updating an external link, accessing a database, or opening a file from a network share can stall while a source is slow or unavailable. If the freeze occurs during refresh, note which connection is running and whether the source can be reached. Ask the workbook owner or IT administrator before changing connection settings or removing links; those links may supply required information.
For a cloud-stored workbook, check whether the internet connection is stable and whether OneDrive or SharePoint is still synchronizing. Do not repeatedly save competing copies or disable synchronization as a first response. If Excel displays a sign-in, permission, or security prompt, read it rather than dismissing it automatically. Protected View and other security features help limit risk from files; disabling them broadly is not a safe general fix. If a work-managed computer or file is involved, follow your organization’s policy.
Update or repair Microsoft 365
If multiple workbooks freeze, or Safe Mode does not help, install available Office updates. In Excel for Windows, go to File > Account > Update Options > Update Now. The exact options can differ if an organization manages Office updates. Save work and close Office apps before updating when prompted, then restart Windows and test Excel again.
If the problem continues, Windows can repair the Microsoft 365 installation. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the menu beside it, and select Modify. Choose Quick Repair first. If that does not fix the issue, Online Repair is a more thorough option and requires an internet connection; it may take longer and can require signing in again. Menu labels vary slightly across Windows versions and installation types. On Mac, there is no matching Windows Modify repair flow; update Office through Microsoft AutoUpdate, commonly available from Help > Check for Updates in an Office app, and consult Microsoft support if reinstalling is needed.
Protect unsaved work and recover a file
After an unexpected close, reopen Excel and check the Document Recovery pane for a recovered version. Review its time and contents before saving over anything. You can also check File > Info for workbook management and recovery options, though what is available depends on how the file was saved and the version of Excel. AutoRecover is useful but is not a promise that every recent edit will be restored.
For important work, save regularly and keep version history or backups where available. With OneDrive or SharePoint, version history may let you restore an earlier version, subject to the file location and account settings. For local files, use a separate backup process. If Excel freezes while saving, avoid making several differently named copies until you know which version is current; compare timestamps and contents carefully.
Reduce the chance of another freeze
Keep Microsoft 365 updated, use only add-ins you need, and remove or update an add-in that is repeatedly implicated. Store large files where their data sources are accessible, and avoid refreshing connections while the network is unstable. For shared workbooks, agree on how changes and versions are managed. If a problem appears only after a workbook change, keep a clean copy and identify the change before altering formulas or connections. These steps do not eliminate every freeze, but they make it easier to distinguish a temporary calculation from a recurring application or file problem.
Frequently Asked Questions
Should I wait or force quit Excel?
Wait first if Excel has just started a large calculation, refresh, or save, and check for a hidden dialog or visible progress. Force quit only when it has stayed unresponsive and you accept that unsaved changes may be lost. Repeatedly clicking or launching more copies is unlikely to help.
Will I lose my work if I end Excel in Task Manager?
You may lose changes made since the last successful save. Excel may offer Document Recovery when reopened, but recovery is not guaranteed. Check for a recovered version and compare it with the saved workbook before replacing any file.
Why does Excel freeze only when I open one file?
That points toward something specific to that workbook, such as complex calculations, external links, a data refresh, its file location, or possible damage. Test a blank workbook, then investigate a safe copy of the affected file and preserve the original.
Can an Excel add-in make the program stop responding?
Yes. An add-in can conflict with Excel or take too long during a task. If Excel works in Safe Mode, disable add-ins temporarily and re-enable them one at a time to identify a possible cause. Check with your organization before disabling required business tools.
Does Not Respond mean my workbook is corrupted?
No. The message means Excel is not currently responding to Windows; it can happen during legitimate work as well as because of a software or workbook problem. If the same file repeatedly fails to open or save, keep a copy and try Open and Repair, but do not assume the message alone proves corruption.
Related
- Excel Print Area Lines: How to Hide Them Correctly
- Excel Hide Row and Column Labels: Steps and Options
- Excel: How to Hide Columns With No Data Automatically
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Not Responding: How to Fix ItIf Excel says Not Responding, first give it a few minutes to finish any calculation or file operation,…
- Excel Merged Cell Error: Causes, Fixes, and PreventionThe Excel message “We can’t do that to a merged cell” means the action you tried conflicts with…
- Excel Not Dragging Formula? Fix Fill Handle IssuesIf Excel will not drag a formula, enable the fill handle in File > Options > Advanced, then…
- Add Slide Numbers to PowerPoint Not Working? Try These FixesIf slide numbers are missing in PowerPoint, open Insert > Header & Footer, select the Slide number checkbox…
- Microsoft Excel Spill Error: Causes and FixesMicrosoft Excel’s #SPILL! error means a formula is trying to return multiple results, but Excel cannot place the…
- Excel Sheet Hyperlink Not Working? How to Fix ItIf an Excel hyperlink seems unresponsive, first try Ctrl+clicking its cell on Windows: Excel normally uses a regular…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.