If Excel frequently shows “Not Responding,” first give it a short time to finish, especially if it is calculating or opening a large workbook; then try Esc and save if the window responds. If the problem keeps returning, isolate whether it affects one workbook or Excel generally, then check add-ins, updates, workbook workload, and available system resources before repairing Office.
What “Not Responding” means
Windows displays “Not Responding” when an application is not processing messages from the desktop promptly. It does not necessarily mean Excel has crashed or that your data is gone. Excel may be occupied with a calculation, a slow file operation, a connection to another service, or an add-in that is taking too long. During that work, the window can stop repainting and appear frozen.
The length of a reasonable wait depends on the task. A large calculation, refresh, or file open may take longer than routine editing. Look for clues: does the status bar show progress, does a progress window appear, or does the computer’s activity suggest work is continuing? Repeatedly clicking the window or launching another copy of the same workbook is unlikely to help and can make it harder to tell which operation is active.
Before ending Excel, consider whether the workbook contains unsaved changes. If the application eventually responds, use Save As to create a separate copy before attempting major repairs. If it does not, forced closure can lose changes since the last save or AutoRecover point. No recovery method can guarantee that every unsaved edit will be restored.
First determine whether the issue is one file or all of Excel
This simple comparison narrows the cause. Open Excel without opening the problem workbook, then create a blank workbook and try a few ordinary actions. If that works but one particular file repeatedly hangs, focus on that workbook’s size, formulas, connections, or file structure. If even a blank workbook is slow, investigate Excel’s add-ins, Office installation, updates, and the computer itself.
- One workbook freezes: make a copy, then test the copy. Consider whether the file has complex formulas, extensive formatting, external links, macros, or data refreshes.
- Every workbook freezes: test Excel in Safe Mode and check add-ins. If Safe Mode is stable, an add-in or startup item becomes a leading suspect.
- Excel freezes during a particular action: note whether it happens while opening, saving, calculating, printing, refreshing data, or editing a specific sheet. A repeatable trigger is useful evidence.
Also check whether the same file behaves differently on another computer or in Excel for the web, if available. That comparison can help separate a local Excel or device problem from a workbook or storage issue. Excel for the web does not support every desktop feature, so a difference in behavior is a clue, not proof that the desktop version is at fault.
Try Excel Safe Mode and check add-ins
On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the same task works reliably there, test add-ins before changing the workbook. Safe Mode is a diagnostic step, not a permanent fix.
To review COM add-ins in Microsoft 365 for Windows, open File > Options > Add-ins. At the bottom, next to Manage, select COM Add-ins, choose Go, and clear a checked add-in to disable it. Restart Excel and test. If the problem disappears, re-enable add-ins one at a time, restarting and testing after each change, to identify a likely cause. You can also review Excel add-ins using the Manage list on that page.
Add-ins can provide specialist tools, connect Excel to other services, or add commands. Disabling one may remove functions you rely on, so note what you change and restore anything that is not responsible. If your organization manages your Office setup, ask its IT support before changing a required business add-in. On Mac, Excel has its own add-in controls under Tools > Excel Add-ins; Windows Safe Mode instructions do not apply in the same way.
Look for workbook features that create heavy work
A workbook may appear frozen because Excel is doing more work than expected. Large ranges, complicated formulas, repeated lookups, and formulas that recalculate often can slow recalculation. Volatile functions such as NOW and INDIRECT can recalculate in more situations than ordinary formulas. The effect depends on the workbook’s design and the computer; a large file is not automatically defective.
Other common sources of load include conditional formatting applied to entire columns, many pictures or shapes, data models, pivot tables, macros, and links to files stored on a slow network location. External data connections can also wait on a server or service. If the freeze happens during refresh, check the connection and whether the source is reachable rather than repeatedly pressing Refresh.
For a cautious test, work on a copy and change one thing at a time. For example, remove unnecessary formatting from unused rows, reduce formulas that refer to whole columns where practical, or temporarily disconnect an external source. If a workbook contains macros, do not enable or run unfamiliar code just to troubleshoot a freeze. Ask the workbook’s owner or your organization’s support team what the code and connections are intended to do.
Excel’s calculation mode is another factor. On Windows, check Formulas > Calculation Options. Manual calculation can reduce automatic recalculation, but it also means displayed results may be out of date until you calculate. Do not switch modes as a casual fix in a shared or important workbook without telling other users and understanding the consequences. Restore the intended setting when testing is complete.
Check memory, storage, and file location
Excel shares computer resources with Windows and other open apps. Large workbooks, many open browser tabs, background tasks, or limited available memory can make response times worse. Close applications you do not need, then reopen the workbook and compare. Avoid routinely terminating processes you do not recognize in Task Manager; ending a system or work application can cause other problems.
Files opened from a network share, removable drive, or cloud-synced folder may respond slowly when the connection is weak or synchronization is busy. If permitted, save a copy to a local folder and test it there. If the local copy works but the original does not, investigate the location, permissions, connection, or sync status. A local test does not establish that it is safe to replace the original; preserve the original and follow your organization’s storage rules.
Older or constrained computers can also struggle with very large workbooks. The 32-bit edition of Office has a more limited address space than 64-bit Office, which can matter for memory-intensive workbooks and add-ins. Changing Office architecture is not a first-line troubleshooting step: compatibility with existing add-ins and other software needs to be considered, and installation changes may require administrator help.
Update Excel and repair the Office installation
Install available Office updates if Excel is unstable across workbooks. In Microsoft 365 for Windows, open File > Account > Update Options > Update Now, if that control is available. Work-managed installations may be updated by an administrator or may show different options. Save your work and close Office apps before updating when prompted.
If updates and add-in tests do not resolve a broad problem, use Windows’ repair options. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365 or Office, open its options, and choose Modify if shown. A Quick Repair is a reasonable first attempt; Online Repair is more comprehensive and may take longer or require an internet connection. Labels and available choices can vary by Office installation. Follow the prompts and make sure important files are saved first.
Repairing Office is different from repairing a particular workbook. If only one file is affected, preserve a backup before trying workbook-specific changes. If repair requires administrator access or the computer is managed by an employer or school, contact the administrator rather than changing the installation yourself.
Protect and recover your work
If Excel has become unresponsive, wait briefly before forcing it closed. If it recovers, save a new copy under a different name and confirm that the file opens. If you must close Excel from Task Manager, understand that unsaved changes may be lost. On Windows, Ctrl+Shift+Esc opens Task Manager; select Excel and choose End task only after deciding that waiting is no longer useful. On Mac, use Command+Option+Esc to open Force Quit, then select Excel.
After an unexpected close, look for Excel’s Document Recovery pane when it reopens. You can also check File > Info > Manage Workbook for recovery options, including unsaved workbooks where available. The exact options depend on whether the workbook had been saved and on Excel’s settings. To review AutoRecover settings on Windows, see File > Options > Save. AutoRecover can help after a disruption, but it is not a substitute for saving regularly.
For files stored on OneDrive or SharePoint, AutoSave and version history may provide additional protection when available and enabled. Confirm that the file has finished saving or syncing before relying on a recent version. If a workbook is important, keep an appropriate backup and avoid troubleshooting on the only copy.
When to contact support
Contact your organization’s IT support or Microsoft support if Excel continues to freeze in Safe Mode, Office repair fails, several users encounter the same issue, or the problem involves a business-critical file or managed data connection. Give support practical details: your Excel and Windows versions, whether the issue affects one file or all files, the action that triggers it, and what tests you have already tried.
If a workbook contains confidential or regulated information, do not upload it to an unfamiliar repair service or share it publicly. Ask the responsible support team how to provide diagnostic information safely. A reproducible problem in a copy of the file is often easier to investigate without risking the original data.
Frequently Asked Questions
Should I close Excel when it says Not Responding?
Not immediately. Give it time if it may be calculating, opening, or refreshing a large file. If it stays unresponsive and you cannot continue, ending the task may be necessary, but unsaved changes can be lost.
Why does Excel freeze only when I open one file?
That points toward something specific to the workbook, such as complex calculations, large formatting ranges, macros, external links, or data connections. Test a copy and note the action that triggers the freeze.
Will Excel Safe Mode delete my files?
No. Safe Mode is a way to start Excel with some customizations and add-ins bypassed; it is not a file-cleanup tool. Still, save important work before troubleshooting, as you would for any application problem.
Can I recover an unsaved Excel workbook?
Sometimes. Check the Document Recovery pane after reopening Excel and look under File > Info > Manage Workbook for available recovery options. Recovery depends on what Excel saved before the interruption.
Why does Excel say Not Responding while calculating?
A complex or large calculation can temporarily keep Excel busy. Wait for it to finish if progress is being made. If the same workbook repeatedly takes too long, test a copy and review formulas, calculation settings, and workbook size.
Related
- Excel Solver Add-In: How It Works and How to Use It
- Excel Remove Duplicates: Steps and Safer Options
- Excel Data Heat Map: Create, Read, and Troubleshoot One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Apps Script Documentation: How to Use ItGoogle Sheets Apps Script documentation is available in Google’s official Apps Script developer documentation, especially the Spreadsheet service…
- Excel Regression Analysis Output: What Each Statistic MeansExcel regression output summarizes how well a linear model fits your data and how each predictor relates to…
- Percentage Difference Formula in Google SheetsIn Google Sheets, percentage difference is the absolute difference between two values divided by their average. If A2…
- Insert Key in Excel: What It Does and How to Use It SafelyTo use the Insert key in Excel for Microsoft 365 on Windows, open File > Options > Advanced,…
- Conditional Formatting Greyed Out? Excel FixesIf Conditional Formatting is greyed out in Excel for Microsoft 365 on Windows, first check whether you are…
- Excel Open Shortcut Keys for Windows and Mac UsersIn Excel for Microsoft 365 on Windows, press Ctrl+O to open the Open screen, or press Ctrl+F12 to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.