If Excel says “Not Responding,” first wait a few minutes, especially if the workbook is large or Excel is calculating; then try saving with Ctrl+S if the window becomes responsive. If it stays frozen, close Excel only after allowing time for recovery, reopen it, and test whether the problem affects one workbook or Excel generally. The distinction helps you choose a fix without risking unsaved work unnecessarily.
What “Not Responding” means
In Windows, “Not Responding” means the program has stopped processing messages from the operating system for a period of time. It does not prove that Excel has crashed or that your file is damaged. Excel may be busy calculating formulas, refreshing external data, opening a large file, or waiting for another component such as an add-in or printer driver.
A brief pause can be normal after a demanding operation. For example, a workbook with many formulas, conditional formatting rules, or links to external files may take longer to recalculate after a change. Repeated freezes, long pauses on simple actions, or the same failure every time you open one file point to a problem that needs investigation.
Before troubleshooting, note what happened just before the freeze: opening a particular workbook, refreshing a query, pasting a large range, printing, or using a specific add-in. That clue can narrow the cause. If a cloud-synced file is involved, also note whether the local copy behaves differently from the copy opened through Excel for the web.
What to do first without risking your work
Give Excel a short opportunity to finish, and avoid repeatedly clicking the window or pressing keys. Extra input can queue up and make it harder to tell whether the program has recovered. If the status bar indicates calculation or a data refresh is underway, waiting is especially sensible. When Excel responds again, save a new copy before making further changes.
- Check whether Excel is still busy. Look for a changing status message, a calculation indicator, or activity in Windows Task Manager. A busy CPU can be a sign of work in progress, though it is not conclusive.
- Try Ctrl+S only if Excel accepts input. On a Mac, use Command+S. If the workbook is stored in OneDrive or SharePoint, check that synchronization has completed before relying on the cloud copy.
- If Excel remains frozen, open Task Manager with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This can discard changes that were not saved. On a Mac, open Force Quit with Option+Command+Esc and choose Excel; unsaved work may also be lost.
- Reopen Excel and look for a Document Recovery pane or recovered files. Save any recovered version under a new name so it does not overwrite a known-good copy.
- Open a different workbook or a blank workbook. If those work normally, the issue may be specific to the original file rather than the whole Excel installation.
There is no reliable way to preserve every unsaved change after forcibly ending a frozen process. AutoRecover can help, but it is not a substitute for saving regularly.
Common causes of Excel freezing
The cause is often one of a handful of workload, workbook, or software issues. A workbook may be large in file size, but file size alone does not explain performance: formulas, formatting, connections, and the number of objects can matter just as much.
- Heavy calculation: Volatile formulas, extensive array calculations, or formulas covering whole columns can make recalculation slow. A change in one cell may trigger work across many dependent formulas.
- External data and links: A workbook can pause while it refreshes a query, connects to a database, or looks for linked files on a network or unavailable drive.
- Add-ins: An Excel or COM add-in may conflict with a particular workbook or take a long time to respond.
- Workbook complexity: Excessive conditional formatting, styles, shapes, charts, or unused rows and columns can make a file harder to open and edit.
- Office or Windows issues: An outdated installation, damaged Office files, low available memory, or a driver problem can affect Excel.
For instance, if a workbook freezes only while printing, investigate the selected printer and its driver before rebuilding formulas. If it freezes only during refresh, check the data source and connection rather than assuming that Excel itself is broken.
Test Excel in Safe Mode and check add-ins
Excel Safe Mode starts the Windows desktop application with many startup customizations and add-ins bypassed. It is a useful diagnostic: if the same workbook behaves normally in Safe Mode, an add-in or startup setting may be involved. Safe Mode does not repair a damaged workbook, and it is not the same as running Excel permanently without add-ins.
- Close Excel if possible. In Windows, press Windows key+R, type
excel /safe, and press Enter. - Open the problem workbook from Excel and try the action that normally causes the freeze.
- If the problem disappears, close Excel normally, then open it again without Safe Mode.
- Go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, choose Go, and clear an add-in’s checkbox to disable it. You can also inspect Excel Add-ins in the same Manage list.
- Restart Excel and test. If the issue remains fixed, re-enable add-ins one at a time to identify the likely cause; check with the add-in publisher for an update.
On Mac, the Windows Safe Mode command and COM Add-ins dialog do not apply. To inspect Excel add-ins, use Tools > Excel Add-ins where available, and disable an item for testing. Menu availability can vary with the installed add-in and Excel version.
Update or repair Microsoft 365
If Excel freezes in multiple workbooks and Safe Mode does not change the behavior, update Office and consider repairing the installation. In Excel for Microsoft 365 on Windows, use File > Account > Update Options > Update Now. If Update Options is missing or controlled by an organization, ask the Microsoft 365 administrator about update policy rather than trying to bypass it.
On Windows, close Office apps and open Settings > Apps > Installed apps. Find Microsoft 365, choose the three-dot menu, then Modify. Depending on the installation, select Quick Repair first; if the problem continues, try Online Repair. Online Repair may require an internet connection and can take longer. The exact labels can differ slightly across Windows releases and Office installation types.
On a Mac, install available Office updates through Help > Check for Updates if Microsoft AutoUpdate is present, or use the update method provided by your organization. Windows repair instructions do not apply to macOS. If only one workbook fails, make a backup before trying file-specific recovery or structural changes.
Reduce workload in a problem workbook
If the problem is limited to one file, work on a copy. This protects the original while you test changes. Start with reversible steps and make one change at a time, reopening the workbook after each test.
- Use Formulas > Calculation Options > Manual temporarily if repeated recalculation is the suspected cause. Excel will not automatically update all formulas after each change in this mode; press F9 to calculate when appropriate. Return to Automatic when finished so results do not remain out of date. On Mac, the Calculation Options control is also on the Formulas tab, though shortcut behavior can differ.
- Reduce oversized formula ranges where practical. For example, a formula that checks a million rows can do unnecessary work if the actual data contains only a few thousand.
- Inspect Home > Conditional Formatting > Manage Rules for duplicated or unnecessarily broad rules. Remove only rules you understand, preferably in a copy.
- Remove unused shapes, sheets, or formatting carefully. Large-scale deletion can change workbook behavior, especially where charts, macros, or named ranges depend on those items.
- For a refresh-related freeze, check whether the source is reachable and whether a query is refreshing in the background. Do not repeatedly start the same refresh while Excel is already working.
Manual calculation is a diagnostic and workload-management option, not a general cure. If values appear stale, check the calculation setting before trusting results or sharing the workbook.
Recover a workbook and prevent repeat freezes
After Excel closes unexpectedly, reopen it and inspect the Document Recovery pane if it appears. Open the most recent candidate, verify that important sheets and recent edits are present, and immediately use File > Save As to create a separate copy. If recovery is not offered, check File > Info > Manage Workbook for available unsaved-workbook options; what appears depends on the file and recovery settings.
To reduce the chance of losing work, save frequently with Ctrl+S on Windows or Command+S on Mac. For important workbooks, keep versioned copies or use a managed cloud location with version history, while confirming that synchronization is complete. AutoRecover settings are under File > Options > Save on Windows; the exact options differ on Mac. AutoRecover can preserve periodic snapshots, but it may not include the latest edits or every type of change.
For prevention, keep Microsoft 365 updated, remove add-ins you do not need, and avoid keeping many high-demand workbooks open at once if the computer has limited memory. When sharing a file that repeatedly freezes, note the steps that reproduce the problem and whether it happens on another computer. That information is more useful than simply describing the workbook as “too large.”
Excel desktop, Excel for the web, and Mac differences
These steps primarily describe Excel for Microsoft 365 on Windows. Excel for the web runs in a browser, so it does not have the Windows Task Manager process controls, Windows Safe Mode command, or desktop add-in settings described above. If a web workbook stops responding, wait briefly, check the browser and network connection, and try reopening the file in a new tab after confirming synchronization. Avoid closing a tab during an active edit if changes may not have synced.
Excel for Mac has different recovery and force-quit controls, as noted above, and Windows-specific Office repair steps do not apply. A workbook that freezes in both desktop and web versions may point toward the workbook or its data; one that freezes only in one environment may instead involve that app, device, add-in, or connection. Testing a copy in another environment can help distinguish these possibilities, but it does not by itself identify the cause.
Frequently Asked Questions
Should I wait or close Excel when it says Not Responding?
Wait first, particularly during calculation, a refresh, or a large file operation. If there is no sign of progress after a reasonable period and Excel remains unusable, ending the task may be necessary, but unsaved changes can be lost.
How do I open Excel in Safe Mode?
On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode is a troubleshooting test; it does not permanently disable add-ins or repair the workbook.
Why does Excel freeze only with one file?
The workbook may contain complex formulas, external connections, extensive formatting, or damaged content. Save a copy, test the file in Safe Mode, and compare its behavior with a blank workbook before changing or removing workbook components.
Will AutoRecover restore everything?
No. AutoRecover may provide a recent recovery copy, but it is not guaranteed to contain the latest edits. Check the recovered workbook carefully and save it under a new name.
Is Excel Not Responding a sign that my file is corrupted?
Not necessarily. Excel can display that message while it is busy. If only one file repeatedly causes the issue, corruption is one possibility, but calculation load, links, formatting, and add-ins can produce similar symptoms.
Related
- How Excel Files Become Corrupted: Causes and Risks
- How to Activate Flash Fill in Excel: Shortcuts and Fixes
- How to Insert a Row in an Excel Spreadsheet: Quick Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Automatic Page Numbers in Microsoft WordTo add automatic page numbers in Word, open the Insert tab, choose Page Number, select where the numbers…
- How to Find the Text Import Wizard in ExcelIn Excel for Microsoft 365 on Windows, enable the legacy Text Import Wizard at File > Options >…
- Solver in Excel: Where to Find It and How to Enable ItIn Excel for Microsoft 365 on Windows, find Solver on the Data tab, in the Analysis group. If…
- How to Share a Team Calendar in Outlook with PermissionsTo share a team calendar in Outlook, open Calendar, select the calendar you want coworkers to use, and…
- Delete a Next Page Section Break in Microsoft WordTo delete a Next Page section break in Word, show formatting marks with Home > ¶, locate the…
- Power BI File Corrupted? Check Its Excel DataA Power BI file can show corrupted-looking Excel data, but importing an Excel workbook into Power BI normally…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.