If an entire Excel sheet or workbook is not responding, first wait briefly if Excel is calculating or processing a large operation; then press Esc once to try to stop it. If the window stays frozen, avoid repeatedly clicking it, check whether other workbooks respond, and use the steps below to recover safely and identify the cause.
What “Not Responding” means
In Windows, Excel may show “Not Responding” when it is not responding to messages from the operating system. That does not always mean Excel has crashed. A large calculation, import, refresh, or formatting operation can temporarily occupy the application while the work continues in the background. The window may look frozen even though Excel is still processing.
There is also a difference between an unresponsive worksheet and an unresponsive application. If the ribbon, formula bar, and other open workbooks are all stuck, Excel itself is likely busy or blocked. If only one workbook is slow, its formulas, data connections, formatting, or file condition may be responsible. Not responding is a symptom, not a diagnosis: restarting immediately can discard unsaved work without fixing the underlying problem.
Wait, then try safe interruption
Give Excel time if the workbook has many formulas, a large PivotTable, an external data refresh, or a macro that is expected to take a while. Watch for signs of activity, such as the status bar changing or the computer continuing to use resources. A short wait is sensible; waiting indefinitely is not. If Excel is consuming resources continuously for a long time, it may be working through an unexpectedly expensive task rather than making useful progress.
Try these low-risk actions before closing the application:
- Press Esc once. Excel may stop the current calculation, data entry, or operation. It cannot interrupt every task, and it may take time to respond.
- If Excel is waiting for a dialog box, use Alt+Tab on Windows to look for a hidden prompt, such as a confirmation or sign-in window.
- If you can reach the ribbon, save with Ctrl+S on Windows. On Mac, use Command+S. Do not assume a save completed if the interface is still frozen.
- Check whether another open workbook responds. If it does, the problem is more likely tied to the affected workbook than to all of Excel.
Do not keep clicking the frozen window. Windows can queue those clicks, making it harder to tell whether the application has recovered and potentially triggering unwanted actions once it does.
Recover work before forcing Excel to close
Force-closing Excel should be a last resort because unsaved changes may be lost. If Windows offers a choice to wait or close the program, choose wait while there is a reasonable chance Excel is still working. If it remains stuck, open Task Manager with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This terminates Excel rather than saving the workbook; Ctrl+Z cannot undo the loss of unsaved changes.
After reopening Excel, look for a Document Recovery pane. Excel may offer recovered versions of files that were open when it closed unexpectedly. Open the most relevant version and save it under a new name or to a safe location before continuing. Recovery is not guaranteed, and the recovered copy may not contain the latest edits.
You can also check File > Info for workbook-management options, including Recover Unsaved Workbooks where available. To adjust future recovery intervals in Excel for Microsoft 365 on Windows, use File > Options > Save and review the AutoRecover settings. AutoRecover is a safeguard, not a replacement for saving regularly. AutoSave is most relevant to files stored in OneDrive or SharePoint; it may not protect unsaved changes in a local file or a change that had not yet synced.
Check whether calculation is holding up the sheet
Workbooks with many formulas can become slow when a change causes Excel to recalculate a large dependency chain. This is especially likely when formulas refer to entire columns, repeat expensive lookups, or depend on volatile functions such as NOW, TODAY, RAND, or OFFSET. A formula can be valid and still make a workbook too costly to recalculate efficiently.
If Excel becomes responsive long enough to use the ribbon, choose Formulas > Calculation Options > Manual. Manual calculation can prevent repeated recalculation while you inspect or edit a large workbook, but it affects calculation behavior for open workbooks in the Excel session. Results may be stale until you calculate again. Press F9 to calculate, or use Formulas > Calculate Now. On Mac, the menu and shortcuts can differ by keyboard and Excel version; use the Formulas tab’s calculation controls if a Windows shortcut does not apply.
Manual mode is a temporary diagnostic and performance choice, not proof that a formula is wrong. Before sharing or relying on results, recalculate and confirm that the displayed values are current. If a workbook is slow after every edit, review formulas for unnecessary whole-column references, repeated calculations, and duplicated conditional-formatting rules. Test changes on a copy, especially if the workbook supports an important business process.
Test Excel without add-ins
An add-in can interfere with startup, workbook loading, or a particular action. To test Excel for Microsoft 365 on Windows in Safe Mode, close Excel, press Windows key+R, type excel /safe, and press Enter. Open the affected workbook if Excel starts. If it now behaves normally, an add-in or a startup customization may be involved. Safe Mode is a diagnostic test; it does not repair the workbook by itself.
To review COM add-ins in normal Excel, choose File > Options > Add-ins. At the bottom, set Manage to COM Add-ins and select Go. Clear an add-in’s checkbox to disable it, restart Excel, and test again. You can also review Excel add-ins from the same page by choosing Excel Add-ins in the Manage list. Disable one at a time where practical so you can identify the cause, and re-enable add-ins you need after testing.
Mac users should not assume the Windows excel /safe command applies. On Mac, check Excel’s add-ins and startup items through the available Excel settings, and update Office using the Microsoft AutoUpdate process or the update route used for that installation. If a specific add-in is required, check with its publisher for current compatibility information.
Look for workbook-specific causes
If other workbooks work normally, focus on the affected file. Large pasted ranges, extensive conditional formatting, external links, data connections, and PivotTables can all make a workbook slow to open or use. A refresh may be waiting on a network or service, while a large import can take time even if the worksheet looks unchanged. A file stored on a network drive or cloud service may also be affected by connectivity or synchronization problems.
When Excel is responsive, try opening a copy of the workbook rather than experimenting on the only original. If the problem happens after a particular action, such as sorting or refreshing, test that action on the copy. You can also try opening Excel first and then using File > Open to select the file. If the workbook is damaged, Windows Excel offers an Open and Repair option: choose File > Open > Browse, select the file, open the arrow next to the Open button, and choose Open and Repair. This option may recover a file, but it cannot guarantee that every formula, feature, or item will be restored.
For workbooks with data connections, determine whether Excel is stuck during refresh or simply slow after the data loads. If the workbook becomes usable when disconnected from a particular source, investigate the connection, credentials, or source availability rather than repeatedly refreshing. Avoid deleting links or data just to make the file open unless you understand what depends on them.
Update or repair Office if every workbook freezes
If blank workbooks and unrelated files also freeze, check for an Excel-wide issue. On Windows, save what you can, close Office apps, then go to File > Account > Update Options > Update Now. The exact update controls can differ if Office was installed through the Microsoft Store or is managed by an organization; managed devices may require an administrator to approve updates.
If updating does not help, Windows users can try repairing Microsoft 365 from Windows Settings. Open Settings > Apps > Installed apps, select Microsoft 365 or Office, choose the available modify or change option, and follow the repair prompts. A Quick Repair is a reasonable first attempt; Online Repair is more comprehensive and may take longer. Names and locations can vary slightly across Windows releases and installation types. Repairing Office is different from repairing a workbook, so keep a separate copy of important files.
On Mac, update Office and restart the Mac before concluding that the installation needs further attention. If the issue continues across multiple workbooks after updates, consult Microsoft support or your organization’s IT team, particularly if the device is managed. Reinstalling Office is not the first step for a problem isolated to one workbook.
Reduce the chance of another freeze
Prevention depends on what caused the delay, but a few habits help limit risk and make diagnosis easier:
- Save frequently with Ctrl+S on Windows or Command+S on Mac, and keep a backup before making major changes.
- Refresh external data only when needed, and check that the source is available before starting a long refresh.
- Use formulas over the necessary data range rather than entire columns when that reduces unnecessary calculation.
- Remove excess formatting from unused regions and review conditional-formatting rules if scrolling or editing is slow.
- Keep Microsoft 365 updated and disable add-ins you do not use, while checking with your organization before changing managed settings.
- For a very large dataset, consider whether it belongs in a database or another data tool instead of being loaded entirely into a worksheet.
Excel for the web can be a useful comparison when a workbook is stored in OneDrive or SharePoint, but it is not a universal fix. Some desktop features, add-ins, and workflows are different or unavailable in the browser. If the file is open in a browser and appears frozen, first allow time for syncing or processing; refreshing the page could interrupt work that has not finished saving.
Frequently Asked Questions
Why does Excel say Not Responding but still use CPU?
Excel may be calculating formulas, refreshing data, or running another operation. CPU use can indicate that work is continuing, but it does not guarantee that the task will finish. Wait briefly, avoid repeated clicks, and try Esc if the operation can be interrupted.
Will I lose my work if I force-close Excel?
Unsaved changes may be lost. After restarting, check the Document Recovery pane and File > Info for available recovered files. Recovery depends on what Excel had saved or captured, so it may not include the latest edits.
How do I know if a workbook or Excel is the problem?
When possible, open a blank workbook or another file. If those respond but one file does not, investigate that workbook’s formulas, data connections, size, or condition. If several unrelated files freeze, check add-ins, updates, and the Office installation.
Can I stop Excel from recalculating automatically?
In Windows Excel, choose Formulas > Calculation Options > Manual. This changes calculation behavior for open workbooks in the session, so results can become outdated until recalculated. Return to automatic calculation when appropriate and verify results before using them.
Does Excel for Mac use the same fixes?
Many workbook checks apply on Mac, but Windows-only steps such as Task Manager and the excel /safe command do not. Use Mac’s app controls to quit a frozen application, review add-ins in Excel, and update Office through the update method for that installation.
Related
- Creating a Four-Quadrant Scatter Plot in Excel: Steps
- CSV Import Wizard in Excel: How to Import Files
- Create a Slicer in Excel: Setup, Filtering, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Sort a Column in Google Sheets: Steps and TipsTo sort a column in Google Sheets, select the data you want to organize, then choose Data >…
- Excel Power Query: Turn a JSON List Into a TableIn Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From JSON,…
- Excel Column Difference Between Two Columns ExplainedIn Excel, “column difference” can mean comparing values in two columns, finding items that appear in one list…
- Excel Page Break Button Locked? Common Causes and FixesIn Excel for Microsoft 365 on Windows, the Page Break command is usually unavailable because Excel is editing…
- Add to a Data Validation List in Excel: Step-by-StepTo add an option to an Excel drop-down list, select a cell that uses the list, open Data…
- How to Clear the AutoComplete Cache in OutlookTo clear every saved recipient suggestion in classic Outlook for Windows, select File > Options > Mail >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.