Excel Not Responding: How to Fix It

If Excel says Not Responding, first give it a few minutes to finish any calculation or file operation, then try opening Excel in Safe Mode with excel /safe. If it responds there, disable add-ins; if it still freezes, check the workbook, update or repair Microsoft 365, and recover unsaved work before forcing Excel to close. These steps are for Excel for Microsoft 365 on Windows.

Before troubleshooting, note whether the problem affects one workbook or every workbook. If the file contains important unsaved changes, avoid ending the Excel task until you have allowed time for it to recover. Excel for Mac and Excel for the web have different startup and repair controls; their differences are noted below.

What You’ll Need

A Windows account that can open Excel and, if necessary, change Microsoft 365 settings.
The workbook’s location, such as a local folder, OneDrive, or a network drive. If possible, keep a separate copy of the original file.
An internet connection for Microsoft 365 updates and Online Repair. Quick Repair may work without downloading the full repair files.

Step-by-Step

Wait and check whether Excel is busy. A large workbook, complex formulas, a refresh, or a connection to a network location can make Excel appear frozen while it works. Wait several minutes, especially after opening a large file or starting a calculation. Look for a progress indicator or changing status in Excel. Avoid repeatedly clicking the window or pressing keys; queued commands can make it harder to tell whether the app has recovered. If Excel responds, save a copy using File > Save As before trying changes.
Check whether the freeze is limited to one workbook. If Excel becomes usable, open a blank workbook with Ctrl+N. If the blank workbook works but the original does not, focus on that file: it may be damaged, unusually large, or dependent on links, queries, or add-ins. If Excel freezes even when opening a blank workbook, continue with Safe Mode and the Office checks below. You can also test another existing workbook, but do not overwrite the original while diagnosing it.
Close Excel only if it has not recovered. If it remains unresponsive after a reasonable wait, press Ctrl+Shift+Esc to open Task Manager. Select Microsoft Excel and choose End task only as a last resort, because unsaved changes may be lost. Restart the computer if Excel will not reopen or if other applications are also stuck. When Excel starts again, check for a Document Recovery pane and open the newest recovered version. Save it under a new name so the original file remains untouched.
Start Excel in Safe Mode. Press Windows key+R, type excel /safe (including the space), and press Enter. Safe Mode starts Excel without most add-ins and custom startup settings. Open the affected workbook if Excel launches. If it works in Safe Mode but freezes during a normal launch, an add-in or startup customization is a likely cause. If Windows says it cannot find Excel, open the Start menu, search for Excel, and try launching it while holding Ctrl; confirm the prompt to start in Safe Mode if it appears.
Disable add-ins that may be causing the freeze. In normal Excel, go to File > Options > Add-ins. At the bottom, next to Manage, select COM Add-ins and choose Go. Clear the check boxes to disable the listed add-ins, then select OK and restart Excel. If the problem continues, return to the same screen and check Excel Add-ins from the Manage list; choose Go and temporarily clear those check boxes too. If the freeze stops, re-enable add-ins one at a time, restarting Excel after each change, to identify the one responsible. Only leave an add-in disabled if you do not need it or its provider advises you to do so.
Install Microsoft 365 updates. If Excel opens, select File > Account > Update Options > Update Now. Allow the update to finish, then close and reopen Excel. If the app will not stay open long enough, use another Office app such as Word and follow the same File > Account route. On a Mac, use Help > Check for Updates to open Microsoft AutoUpdate. Excel for the web updates automatically, so close and reopen the browser tab and check that your browser is current instead.
Repair the Microsoft 365 installation. Close all Office apps. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select its three-dot menu, and choose Modify. In Windows 10, open Settings > Apps > Apps & features, select Microsoft 365, and choose Modify. Run Quick Repair first and test Excel. If it still freezes, repeat the process and choose Online Repair; this takes longer and needs an internet connection. The repair options do not appear in Excel for the web, and Mac has different Office repair steps, so use Microsoft’s current Mac support instructions rather than Windows menu paths.
Try to repair a workbook that appears damaged. Make a copy of the file before attempting repair. In Excel, choose File > Open > Browse, select the workbook, then use the arrow beside the Open button and choose Open and Repair. Try Repair first. If that does not work, repeat the process and choose Extract Data, if available, to retrieve values and formulas. For a file stored in OneDrive or SharePoint, check its version history before replacing anything; an earlier version may be usable. Repair cannot guarantee that all formatting, formulas, or data will be restored.
Reduce the load in a workbook that is simply too demanding. If it opens but then hangs, try a copy and work on one change at a time. Close other large workbooks, stop unnecessary refreshes, and check whether the file contains extensive conditional formatting, volatile formulas, large ranges, external links, or many images. If Excel is calculating, wait for completion before changing calculation settings. For a temporary test, use Formulas > Calculation Options > Manual, but remember that formulas will not update automatically. Return to Automatic when finished if that is the workbook’s intended behavior, and recalculate before relying on results.

Common Mistakes

Ending the task too quickly. Excel can take time to calculate or refresh data. Force-closing it immediately can lose unsaved work and interrupt a file operation. Wait first, then close it only if it remains stuck.
Changing several things at once. If you disable add-ins, update Office, and alter workbook settings together, you may not discover which change helped. Make one change, restart Excel, and test the same file.
Saving over the only copy. Repair attempts and changes to a complex workbook can have unexpected results. Keep an untouched copy and use Save As for recovered or modified versions.
Assuming Safe Mode fixes the workbook. Safe Mode is a diagnostic test, not a permanent repair. If the workbook still freezes there, investigate the file itself or the Office installation.
Leaving calculation set to Manual. This can make formulas show outdated results. If you changed it for diagnosis, restore the appropriate calculation mode and recalculate before using the workbook’s figures.

Tips

Write down what was happening just before the freeze: opening a particular file, refreshing a query, printing, using a specific add-in, or entering a formula. This clue can narrow the cause quickly.
Keep a working copy of large or important workbooks, and use OneDrive or SharePoint version history where available. Version history is useful, but it is not a substitute for checking that changes have synced.
When a workbook opens, save a copy before removing links, changing formulas, or deleting formatting. A smaller test copy makes it easier to isolate performance problems without risking the original data.
For recurring freezes, record the Excel version shown at File > Account and whether the issue affects one file or all files. Those details help an IT administrator or Microsoft Support investigate.

Troubleshooting

Excel freezes in Safe Mode too: This points away from a typical add-in problem. Restart Windows, install available Office updates, and run Quick Repair followed by Online Repair if needed. If other Office apps also freeze, mention that when contacting your administrator or Microsoft Support.

Only a file on a shared drive freezes: First copy the file to a local folder if you have permission, then test the copy. A slow or interrupted network connection, permissions, or a sync conflict may be involved. Do not create competing edits in separate copies and later merge them without checking which version contains the latest data.

The workbook will not open or repair: Check for a OneDrive or SharePoint earlier version, or ask the file owner for a fresh copy. If Excel offers Document Recovery, save recovered content under a new name. Do not rename the file extension as a repair method; that does not fix damaged workbook contents.

Excel for the web is unresponsive: Wait briefly, then reload the tab after confirming any changes have saved. Try a current browser, close extra tabs, or open the workbook in the desktop app if your account permits. Browser reloads can discard unsaved edits, so use them only after checking the save status.

Frequently Asked Questions

Should I wait or force-close Excel?
Wait if Excel may be calculating, opening a large workbook, or refreshing data. If it remains unresponsive for several minutes with no sign of progress, you can end the task in Task Manager, but unsaved changes may be lost. Check for recovered files when Excel restarts.

How do I recover an unsaved Excel workbook?
After restarting Excel, look for the Document Recovery pane. You can also check File > Info > Manage Workbook for a Recover Unsaved Workbooks option. Availability depends on whether Excel created a recovery copy and on the app’s settings, so recovery is not guaranteed. Save any recovered file with a new name.

Why does Excel freeze only when I open one file?
That workbook may be damaged, very large, or contain intensive formulas, links, queries, or formatting. Test a copy, try Open and Repair, and compare its behavior with a blank workbook. If the copy is stored online, check version history and connection status.

Can an add-in make Excel stop responding?
Yes. Add-ins can conflict with Excel or perform work that takes a long time. If Excel works in Safe Mode, disable COM Add-ins and Excel Add-ins, then re-enable them one by one to find the source. Check with the add-in provider before reinstalling or updating business-critical software.

Do these steps work on a Mac?
Some ideas, such as testing a different workbook and disabling add-ins, apply, but the Windows Safe Mode command and Windows repair menus do not. On Mac, update through Help > Check for Updates and manage Excel add-ins through the Mac app’s menus. For a workbook that will not open, make a copy first and follow current Microsoft guidance for Excel for Mac.

What if Excel keeps freezing after repair?
Note whether the problem affects every workbook, only files in one location, or a particular action. Record your Microsoft 365 version and the steps that reproduce the freeze, then contact your organization’s IT team or Microsoft Support. Avoid repeated repair attempts on the only copy of an important file.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.