Excel Not Responding: How to Fix Freezes and Hangs

If Excel keeps showing “Not Responding,” first give it a little time if it may be calculating or opening a large file; repeatedly clicking the window can make the delay worse. If it remains stuck, protect any recoverable work, then narrow down whether the cause is a particular workbook, an add-in, Excel itself, or a Windows resource problem.

What the message means

“Not Responding” is a Windows status indicating that an application is not currently processing window messages quickly enough to respond to clicks or redraw its interface. It does not, by itself, prove that Excel has crashed or that your file is lost. Excel may be busy calculating formulas, loading data, refreshing a connection, or waiting on another component.

A short pause can be normal with a large workbook, especially after changing a formula used across many rows or opening a file with external links. A freeze that lasts several minutes, repeats with a small workbook, or returns every time you perform the same action points to a problem worth investigating. There is no universal waiting time: the workbook size, computer speed, and task all matter.

Before troubleshooting, note what was happening when the message appeared. Did Excel freeze while starting, opening one specific file, calculating, printing, or using a particular command? That clue helps distinguish an Excel-wide issue from a workbook-specific one.

First steps that protect your work

When the window stops responding, avoid clicking repeatedly or immediately ending the task. Windows may show “Not Responding” while a demanding operation is still running. Check whether the computer is active and give Excel time, particularly if the file is large or the action normally takes a while.

Wait and observe: Look for signs that the computer is still working, such as disk activity or changing CPU use in Task Manager. These signs do not guarantee Excel will recover, but they can help you avoid interrupting an operation prematurely.
Check for a hidden prompt: Use Alt+Tab to see whether a file warning, sign-in dialog, or other Excel window is waiting behind the main window.
If Excel recovers, save a separate copy: Use File > Save As to preserve the current state before testing fixes. If the workbook is important, avoid experimenting on the only copy.
If it stays frozen: Open Task Manager with Ctrl+Shift+Esc. Select Microsoft Excel and choose End task only if you have decided it is no longer progressing. Unsaved changes may be lost, although Excel may offer recovery the next time it starts.

Excel’s AutoRecover feature may have a recent version, but it is not a substitute for saving. After a forced close, reopen Excel and check the Document Recovery pane if it appears. You can also look under File > Info > Manage Workbook for available recovery options. The exact items shown depend on what Excel was able to save. AutoSave is different: it generally applies to files saved to OneDrive or SharePoint, and its availability depends on the file and account.

Find out whether the workbook or Excel is the problem

Try opening Excel without opening the troublesome workbook, then create a blank workbook and perform a simple action such as typing into a cell. If Excel works normally, the original file or something it loads is a stronger suspect. If Excel freezes before you open any file, investigate add-ins, updates, and the Office installation first.

For a workbook-specific check, make a copy and open that copy. If the file opens, try a simpler version of the task that caused the freeze. A workbook may be slow because of extensive formulas, conditional formatting, volatile calculations, large imported data, links to other files, or a damaged feature. For example, a formula copied down hundreds of thousands of rows can create much more work than the same formula in a short table.

External links and data connections can also make opening or refreshing a file seem like a freeze, especially if the source is unavailable or on a slow network. If Excel offers a prompt about updating links or enabling content, read it rather than clicking through automatically. Only enable content in files you trust. If the workbook is stored on a network drive or synchronized folder, test a copy saved locally; this can help identify a connection or synchronization delay, but it does not repair a damaged original.

Start Excel in Safe Mode

Safe Mode starts Excel with certain customizations and add-ins bypassed, making it a useful diagnostic test. On Windows, press Windows key+R, enter excel /safe, and press Enter. If Excel opens in Safe Mode and behaves normally, an add-in, startup file, or customization may be involved. Safe Mode is a test, not a permanent fix, and it does not establish which component is responsible.

If Excel will not start from the Run box, use Windows Search to locate Excel and try opening it while holding Ctrl; depending on the prompt, confirm that you want to start in Safe Mode. If you use Excel for Mac, the Windows command and Windows ribbon paths below do not apply. Mac has its own startup and add-in controls; do not use Windows repair instructions on a Mac installation.

Check add-ins and startup items

If Safe Mode works, disable add-ins and test Excel in normal mode. In Excel for Microsoft 365 on Windows, go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then choose Go. Clear the selected items and restart Excel. To check Excel add-ins, repeat the process with Excel Add-ins selected in the Manage list.

Turn off add-ins as a diagnostic step, not a reason to remove every feature permanently. If the freeze stops, re-enable items one at a time, restarting and repeating the action that caused the problem. When the issue returns, the last item enabled is a useful lead. Check with the add-in’s publisher for an update or compatibility guidance. If the controls are managed by your workplace, ask your IT administrator before changing them.

Excel can also load files from startup locations. A workbook or add-in in a startup folder may make Excel hang as it opens. If the problem occurs at launch even with ordinary add-ins disabled, check whether Excel opens normally when startup files are not being loaded, or ask support to review the setup. Do not delete unfamiliar files from Office folders; identify what they are and keep a backup before changing startup items.

Update Office and repair the installation

An outdated Office build or damaged program files can cause freezes that affect multiple workbooks. To check for updates in Excel for Microsoft 365 on Windows, choose File > Account > Update Options > Update Now. If Update Options is missing or unavailable, Office may be controlled by an organization or installed through a different channel; contact the person who manages it rather than trying to bypass those controls.

If updates do not help, close Office apps and use Windows settings to repair Microsoft 365. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, then Modify. In Windows 10, the corresponding route is Settings > Apps > Apps & features, then select Microsoft 365 and choose Modify. Run Quick Repair first. If the problem remains, Online Repair is a more thorough option and may require an internet connection and sign-in afterward. The labels can differ slightly by Windows or Office installation.

Repairing Office is not the same as repairing a workbook. Save your files and close Office before starting. If Excel still hangs after an Office repair, or the computer is managed by an employer or school, get help from the administrator before removing or reinstalling Office.

Look for performance and calculation bottlenecks

Some apparent freezes are workload problems. Excel may be calculating a complex workbook, refreshing a query, loading a pivot table, or processing a large range. Large formulas, repeated lookups, whole-column references in complex calculations, and extensive conditional formatting can all add work. The effect depends on the workbook design and computer; there is no single setting that makes every file faster.

If a workbook becomes unresponsive immediately after an edit, make a copy and consider whether that edit caused many dependent formulas to recalculate. You can check the calculation setting under Formulas > Calculation Options. Manual calculation can reduce automatic recalculation while you make changes, but formulas may then show outdated results until you calculate. Use it only when you understand that trade-off, and restore the appropriate setting before relying on the results.

Other programs competing for memory or processing time can contribute to slow responses. Close applications you do not need, and check that the computer has adequate free storage. If a freeze happens mainly when printing or previewing, update or troubleshoot the printer driver; Excel interacts with the selected printer when laying out a sheet. For workbooks using network data, test connectivity and ask the data owner whether the source is available.

When Excel will not recover or the file will not open

If Excel repeatedly hangs on one file, preserve an untouched copy before attempting repair. From Excel, use File > Open > Browse, select the workbook, choose the arrow next to Open, and select Open and Repair if that option is available. Excel may offer to repair the workbook or extract data. Repair can discard damaged elements, so keep the original and compare the recovered file carefully; a repair is not guaranteed to restore everything.

If the problem affects all files, write down the steps that trigger it, your Excel version, and whether Safe Mode changes the behavior. That information is more useful to IT support than simply reporting that Excel is slow. Include whether the file is local, on a network, or in OneDrive or SharePoint, and whether the freeze began after an update or a new add-in.

For Excel on the web, a Windows desktop repair is not the right first fix. Try refreshing the browser page only after considering unsaved changes, and check the service or file’s access status. Test another supported browser or a private browsing window to help identify an extension or browser-session issue. If the workbook behaves normally in the desktop app but not in the browser, the difference may involve browser resources, a feature not supported in that environment, or the connection.

Frequently Asked Questions

Should I wait or close Excel when it says Not Responding?
Wait first if Excel may be calculating, opening a large file, or refreshing data. If there is no progress and the application remains stuck, ending the task in Task Manager may be necessary, but unsaved work can be lost. Reopen Excel and check for recovery files afterward.

How do I stop Excel from freezing when I open a file?
Test whether Excel opens by itself and whether a blank workbook works. If only one file causes the freeze, work with a copy and check links, connections, formulas, and file health. If Excel hangs on every launch, test Safe Mode and investigate add-ins or Office updates.

Can I recover an Excel file after force-closing the app?
Possibly. Reopen Excel and check the Document Recovery pane, or look under File > Info > Manage Workbook for available recovery versions. Recovery depends on the last save and AutoRecover state, so it may not include the most recent edits.

Does Not Responding mean my workbook is corrupted?
No. It only indicates that Excel is not responding promptly to Windows. A demanding calculation, add-in, slow data source, low system resources, or a damaged workbook can produce similar symptoms. Testing a blank workbook helps separate some of these causes.

Why does Excel freeze only when I print?
Printing involves page layout and communication with the selected printer, so a printer driver or unavailable printer can be involved. Check that the intended printer is available, update its driver through the printer maker or your IT department, and see whether the same workbook behaves differently with another available printer.

Will reinstalling Excel fix the problem?
It may help if the Office installation is damaged, but it is not the best first step. Test Safe Mode, update Office, and try Quick Repair before considering Online Repair or a reinstall. If the device is managed, consult its administrator before changing the installation.

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.