When Excel shows “Not Responding,” first wait briefly in case it is calculating or loading a large file; then try Esc to stop a running operation. If it stays frozen, reopen Excel in Safe Mode, disable add-ins, and check whether the problem affects one workbook or every workbook. Before closing Excel, consider whether it may still be saving, because forcing it to quit can lose recent changes.
What “Not Responding” Usually Means
Windows displays this message when an app is not responding to messages from the operating system. It does not necessarily mean Excel has crashed or that your workbook is damaged. Excel may be busy recalculating formulas, refreshing a connection, opening a large file, or waiting for another resource. A status message can be hard to distinguish from a genuine freeze, so give the program time to finish before taking a more disruptive step.
The cause can be in Excel itself, an add-in, a particular workbook, or the computer’s available resources. A file that suddenly becomes slow may contain a new formula, a large amount of formatting, a broken external link, or a data refresh that takes longer than expected. If all workbooks are affected, the issue is more likely to involve Excel’s settings, an add-in, an update, or Windows rather than just one file.
There is no single fix that suits every freeze. The safest approach is to move from low-risk actions to more disruptive ones: wait, try to cancel the task, save if Excel responds, isolate the problem, and only then close or repair the application.
Try These Immediate Steps First
Check whether Excel is making progress before ending the process. Look for a changing status-bar message, a calculation indicator, or activity in the workbook. A large calculation or data refresh can take several minutes, particularly on a computer with limited memory or when the file is stored on a slow network location.
- Wait and avoid repeated clicks. Clicking repeatedly can queue more actions while Excel is busy. Wait a minute or two for an ordinary file, and longer if you know it is recalculating or refreshing substantial data.
- Press Esc once. This can cancel certain operations, such as a calculation or a dialog-driven action, but it cannot interrupt every task. If Excel responds, save the workbook using Ctrl+S.
- Check for a hidden dialog. Excel may appear frozen while a prompt is open behind another window. Use Alt+Tab to look for a message such as a link-update, file-access, or confirmation prompt.
- Check the computer’s resources. Press Ctrl+Shift+Esc to open Task Manager and see whether Excel is using CPU or memory. High activity may mean it is still working; no activity does not prove that it is safe to close.
- Close Excel only if it remains stuck. In Task Manager, select Microsoft Excel and choose End task. This can discard unsaved changes, so treat it as a last resort rather than the first response.
On a Mac, use Esc where applicable and check whether a dialog is hidden. If Excel will not respond, use the Apple menu > Force Quit, select Microsoft Excel, and choose Force Quit. The Windows Task Manager steps and Safe Mode shortcut described below do not apply in the same way on Mac.
Recover Changes After Excel Closes
After an unexpected close, start Excel again and look for a Document Recovery pane. Open the most recent recovered version and check its contents before saving it over the original. If the pane does not appear, in Excel for Microsoft 365 on Windows go to File > Info > Manage Workbook > Recover Unsaved Workbooks. The available options can vary depending on how the file was stored and whether recovery information was created.
AutoRecover and AutoSave are not interchangeable. AutoRecover stores recovery information at intervals configured in Excel; it can help after a crash, but it is not a guarantee that every recent edit will be preserved. To review its settings, go to File > Options > Save and check the AutoRecover options. AutoSave is generally available for eligible files saved to OneDrive or SharePoint, and its availability depends on the account and file setup. A local file may not have the same continuous saving protection.
If Excel opens a recovered copy, compare it with the original and confirm that formulas, recent entries, and formatting are intact. Save a recovered version under a new name first if you are uncertain. For important work, save regularly with Ctrl+S and keep a separate backup; recovery features complement backups rather than replace them.
Use Safe Mode to Test Add-Ins
Safe Mode starts Excel with many customizations and add-ins bypassed, making it useful for diagnosing problems. Close Excel if possible, press Windows key+R, type excel /safe, and press Enter. If Excel behaves normally in Safe Mode but freezes during a normal start, an add-in or customization is a plausible cause. This test is a clue, not proof: a workbook-specific issue may still be involved.
To test add-ins in normal Excel, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, choose Go, and clear the check boxes to disable them temporarily. You can also inspect Excel Add-ins by choosing that item in the Manage list and selecting Go. Restart Excel and see whether the freeze returns. If the problem disappears, re-enable add-ins one at a time, restarting and checking after each change, to identify the likely trigger.
Do not remove an add-in that your organization requires without checking with its IT support team. An add-in may provide a business system connection or a specialized feature. If disabling one resolves the issue, check with its publisher or your administrator for an update or compatible replacement. To leave Safe Mode, close Excel and open it normally from the Start menu or a workbook.
On Mac, Windows’ excel /safe command is not the appropriate procedure. Try opening Excel without loading optional add-ins by reviewing Excel > Settings or Preferences and the Add-ins controls available in your installed version. Menu labels can differ by Mac release. You can also test with a new blank workbook and install updates through Microsoft AutoUpdate.
Find Out Whether the Workbook or Excel Is the Cause
Open a blank workbook with File > New > Blank workbook. If the blank workbook works while one particular file freezes, focus on that file. Make a copy before changing it, especially if it contains business-critical data. If every file freezes, test Safe Mode and check for updates before investing time in rebuilding an individual workbook.
For a troublesome workbook, consider what changed just before the problem began. A newly added formula, external data source, PivotTable refresh, linked workbook, or unusually large paste operation can make opening or editing take longer. If the file is stored on a shared drive or cloud service, test a local copy where permitted. This can help distinguish workbook processing from network delay, but it does not prove the local copy is the authoritative version.
Large or complicated formulas can slow calculation. Functions that recalculate frequently, formulas applied across entire columns, and extensive arrays may make a workbook do much more work than intended. A practical test is to copy the file, then temporarily remove or simplify the recently changed area in the copy. Avoid changing formulas in the only original when you are still diagnosing the cause.
File corruption is possible, but a freeze alone does not establish that a workbook is corrupt. If Excel offers a recovery or repair option when opening the file, make a backup first and follow the prompt carefully. You can also create a new workbook and move sheets or data in stages, checking whether the problem follows a particular sheet. This method may not preserve every workbook feature, so verify formulas, links, macros, and formatting afterward.
Reduce Workload in a Slow Workbook
A workbook’s visible data is not the whole measure of its workload. Formatting applied to thousands of unused rows, excessive conditional-formatting rules, many formulas, images, pivot caches, and external connections can all contribute to size or delay. The useful question is not simply “Is the file large?” but “Which operation makes it slow?” Opening, recalculating, filtering, saving, and refreshing data can each have different causes.
- Check calculation settings. In Formulas > Calculation Options, see whether calculation is set to Automatic. Manual calculation can reduce repeated recalculation in some large workbooks, but it also means results may not update until calculation is requested. Do not change this without understanding how users rely on current results.
- Review conditional formatting. Select a relevant range and use Home > Conditional Formatting > Manage Rules to inspect rules and their ranges. Duplicated or unnecessarily broad rules can add overhead and make maintenance harder.
- Limit unnecessary formatting and formulas. Apply formatting to the data range actually used, and avoid copying formulas far beyond the rows needed. In a copy of the file, test changes and compare the results before adopting them.
- Inspect connections and links. A refresh or external reference may wait for another file, database, or network. Identify the source and check whether it is available rather than repeatedly refreshing a connection that cannot be reached.
- Save a backup before cleanup. Removing sheets, links, or formatting can change the workbook’s behavior. Keep the original until the revised copy has been checked.
Turning calculation to Manual is not a universal performance fix. It can leave displayed results out of date, which is especially risky if someone assumes the workbook recalculates automatically. If used for diagnosis, record the original setting and restore it when the test is finished unless the workbook’s owners have deliberately chosen a different calculation policy.
Update or Repair Microsoft 365
If Excel freezes across multiple files, install available Office updates. In Excel for Microsoft 365 on Windows, go to File > Account > Update Options > Update Now. If Excel cannot stay open long enough to update, use the Microsoft 365 update or repair options available through Windows instead. Company-managed devices may receive updates on an IT schedule, so contact the administrator if the controls are unavailable.
When the issue continues, Windows can repair the Office installation. Open Settings > Apps > Installed apps, find Microsoft 365 or your Office installation, select the three-dot menu, and choose Modify. Depending on the installation, choose Quick Repair first. If that does not help, Online Repair is a more comprehensive option and may require an internet connection and a sign-in afterward. Save your work and close Office apps before starting either repair.
Repairing Office is different from repairing a workbook: it targets the installed program, not the contents of a specific file. It may not fix a problem caused by a third-party add-in, a network source, or a damaged workbook. If the freeze began immediately after a Windows or Office change, note the timing and any error message before contacting Microsoft support or your organization’s IT team.
Prevent Future Freezes
Prevention is mostly about making recovery reliable and keeping a workbook’s workload understandable. Save important files in an approved location, use version history when available, and create separate backup copies before major edits. For local workbooks, check the AutoRecover interval under File > Options > Save rather than assuming every keystroke is preserved. For cloud files, confirm that AutoSave is on and that the file has finished syncing.
Keep Excel and trusted add-ins current, and remove or disable add-ins that are no longer needed. Break very large tasks into smaller, testable steps where practical. For example, refresh one data connection at a time and save a copy before replacing a complicated formula across an entire sheet. These habits make it easier to identify what caused a slowdown and reduce the risk that one failed operation affects all recent work.
If you repeatedly need to inspect or update data but the desktop workbook is too demanding, consider whether a lighter workflow is suitable. Excel for the web can handle many everyday spreadsheet tasks, but feature availability and behavior are not identical to desktop Excel; some advanced features, connections, or macros may require the desktop app. A web version is an alternative to test, not a guarantee that a particular workbook will run better.
Frequently Asked Questions
Should I wait or force close Excel?
Wait if Excel may be calculating, saving, or refreshing data, and check for a hidden dialog. If it remains unresponsive and shows no sign of progress, you may need to end the task, but unsaved changes can be lost. Reopen Excel afterward and check Document Recovery.
How do I open Excel in Safe Mode?
On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode helps test whether add-ins or customizations are involved. It is a diagnostic start, not a permanent repair.
Why does Excel freeze only with one file?
That points toward something specific to the workbook, such as complex formulas, formatting, a data refresh, external links, or possible file damage. Work from a copy and test the suspected sheet or operation rather than altering the only original.
Can I recover an Excel file after ending the task?
Possibly. Look for the Document Recovery pane when Excel reopens, or check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel saved recovery information, so it may not include the latest edits.
Does Excel for the web fix the Not Responding problem?
It may help you continue with ordinary spreadsheet work, but it is not a universal fix. The web app has different feature support from desktop Excel, and a complex workbook or unavailable data source can still cause problems. Keep a safe copy and confirm that essential features work before relying on it.
Related
- Can You Search in an Excel Slicer? How to Find Items
- Can You Merge Cells in an Excel Table? What to Do Instead
- Can You Password Protect a Sheet in Excel? Here’s How
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel #REF! Error: Fixing Broken Cell References in FormulasA #REF! error in Excel means a formula contains a cell reference that is no longer valid. If…
- LEFT Excel Formula Not Working? Fix ItIf your LEFT formula is not working, check that the formula starts with an equals sign, refers to…
- Dollar Signs Not Lining Up in Excel? Fix the FormatIf dollar signs are not lining up in Excel, select the cells and choose Home > Number >…
- XLOOKUP and VLOOKUP Not Working? Fix Common ErrorsIf XLOOKUP or VLOOKUP is not working, first check that the lookup value and lookup column contain the…
- Ctrl+L Excel Shortcut: Create a Table and Fix IssuesIn Excel for Microsoft 365 on Windows, Ctrl+L opens the Create Table dialog for turning a selected data…
- Clean an Excel Table: Fix Messy DataTo clean an Excel table, first make a copy of the workbook, convert the data range to a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.