Excel Will Not Respond? Fixes for a Frozen Workbook

If Excel will not respond, first wait briefly: a large calculation, refresh, or file operation can temporarily make the window appear frozen. If it stays stuck, try to save if possible, identify whether the problem affects one workbook or Excel generally, and then close or troubleshoot Excel using the steps below.

What Excel’s Not Responding message means

In Windows, Not Responding usually means Excel is not handling messages from the operating system promptly. It does not prove that Excel has crashed or that your workbook is damaged. Excel may be calculating formulas, loading a large file, refreshing external data, or waiting for another resource. During that work, the window may stop repainting and Windows may label it unresponsive.

Give Excel a little time when you know it is doing a demanding task, especially immediately after opening a complex workbook or refreshing a connection. Look for signs of activity, such as a changing status message or computer activity. Repeatedly clicking the window or launching more copies of Excel can make it harder to tell what is happening. If the workbook becomes responsive again, save a new copy before continuing to troubleshoot.

A brief pause is different from a persistent hang. If the window remains unresponsive for several minutes with no sign of progress, or this happens every time you open the same file, use a controlled troubleshooting process rather than assuming the only answer is to reinstall Office.

What to do before closing Excel

If Excel accepts input, save the workbook with Ctrl+S on Windows; on a Mac, use Command+S. If the window is not accepting input, the shortcut may do nothing. Avoid repeatedly pressing keys or clicking controls: queued actions can take effect unexpectedly if Excel starts responding again.

Before ending the process, consider what may be running. A workbook with many formulas, a Power Query refresh, a connection to a shared drive, or a macro may take longer than a simple spreadsheet. If Excel does recover, save the file under a different name or location so you preserve a known-good copy while investigating.

If you decide Excel is truly stuck, close it through Windows Task Manager:

Press Ctrl+Shift+Esc to open Task Manager.
Select Microsoft Excel in the list. If necessary, expand the entry or use the Processes view.
Choose End task, then reopen Excel and check for a Document Recovery pane or other recovery prompt.

Ending the task can discard unsaved changes. It is a last resort, not a repair method, and it cannot guarantee recovery. On a Mac, use Apple menu > Force Quit, select Microsoft Excel, and choose Force Quit. The Windows Task Manager steps do not apply to Excel for Mac.

Check whether the problem is Excel or one workbook

After restarting Excel, open a blank workbook. If the blank workbook works normally but one particular file causes a hang, the issue is more likely related to that file, its data connections, formulas, macros, or size. If Excel hangs even with a blank workbook, investigate add-ins, startup files, or the Office installation.

Test the troublesome file without overwriting the original. In Excel, choose File > Open > Browse, select the workbook, click the arrow beside the Open button, and choose Open and Repair. If Excel offers a repair option, try Repair first. If that does not work, Open and Repair may offer Extract Data. The latter may recover values and formulas while losing some workbook features, so keep the original file unchanged.

When a workbook is stored on a network share, removable drive, or cloud-synced folder, make a local copy and open that copy. A slow or interrupted connection can look like an Excel freeze. If the local copy behaves normally, investigate the storage or synchronization route rather than making changes to the workbook content.

Test Excel without add-ins

An add-in can conflict with Excel or take a long time to load. On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the problem disappears there, an add-in or startup customization is a reasonable suspect; Safe Mode is a diagnostic test, not a permanent fix.

To disable COM add-ins in normal Excel, use File > Options > Add-ins. At the bottom, set Manage to COM Add-ins and select Go. Clear the checkboxes, choose OK, and restart Excel. If Excel now works, re-enable add-ins one at a time, restarting as needed, to identify the one associated with the hang. You can also inspect Excel add-ins by choosing Excel Add-ins in the Manage list.

If Excel is too unstable to change these settings normally, use Safe Mode to reach the options. Add-in names and available controls depend on what is installed. On Mac, Windows Safe Mode and the excel /safe command do not apply; check Excel’s installed add-ins and startup items using the options available in that version.

Common workbook causes

Workbooks can demand substantial processing even when they look simple. Large ranges referenced by formulas, volatile functions that recalculate frequently, extensive conditional formatting, complex array formulas, and many linked worksheets can all add work. A formula copied across hundreds of thousands of rows may also be far more expensive than one limited to the actual data.

External data introduces other potential delays. A workbook may be refreshing a query, reaching a database, updating links to another file, or waiting for a network location. If Excel pauses during a refresh, determine whether the refresh completes eventually. Do not repeatedly start the same refresh. For a test, open a copy of the workbook and use Data > Queries & Connections to inspect its connections; avoid deleting connections unless you understand what they supply.

Macros can also make Excel appear unresponsive, particularly if they process a large range or wait for another application. If a macro is running, Excel may not respond to ordinary clicks until it finishes. Only enable macros in files from sources you trust. If the hang occurs when a specific macro runs, make a separate copy and ask the workbook’s author or administrator to review the macro rather than changing security settings broadly.

Recover unsaved changes and protect the file

When Excel restarts after an unexpected close, check the Document Recovery pane. Open the recovered version and save it under a new name before comparing it with the last saved file. A recovered copy may contain only the changes captured by AutoRecover, not every edit made before the freeze.

If no recovery pane appears, check File > Info > Manage Workbook for an available recovered or unsaved version. Excel’s options at File > Options > Save control AutoRecover settings, including the save interval and the location used for recovery files. These settings can improve the chance of recovering work, but AutoRecover is not the same as saving and should not replace frequent saves.

For workbooks saved to OneDrive or SharePoint, version history may provide an earlier copy. In desktop Excel, look under File > Info for Version History when it is available; the exact experience can depend on the account and storage location. Excel for the web also provides version history for supported cloud files. Keep in mind that restoring an older version can replace newer content, so compare or download a copy first when possible.

Improve performance and prevent repeat hangs

Once Excel opens reliably, reduce avoidable work and make recovery easier. The right changes depend on the workbook; a large file is not automatically broken. Try changes on a copy and check that the results remain correct.

Use formulas and formatting only across the rows and columns that contain relevant data, rather than entire columns when that creates unnecessary calculation work.
Remove unused worksheets, excessive conditional formatting, and obsolete external links only after confirming they are no longer needed.
For a workbook that recalculates heavily, review File > Options > Formulas. Calculation can be set to Manual, but then formulas may not update automatically. Use this only when you understand the implications, and recalculate before relying on results.
Refresh external data deliberately and confirm that network drives or source files are available. If refreshes are the trigger, check the connection and query settings with the file owner.
Save important work regularly and keep a separate backup before major edits, repairs, or macro runs.

Changing calculation to Manual is a common misconception as a universal fix. It can make editing more responsive in a calculation-heavy workbook, but it can also leave displayed results out of date. It does not repair a damaged file, and users may forget to recalculate before sharing or using the workbook.

Update or repair Microsoft 365

If Excel hangs with blank workbooks and the issue persists after checking add-ins, install available Office updates. In Excel for Windows, choose File > Account > Update Options > Update Now. Some organizations manage updates centrally, so the option may be restricted or unavailable.

If the problem continues, repair Microsoft 365 from Windows settings. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the menu beside it, and choose Modify. In Windows 10, use Settings > Apps > Apps & features, select Microsoft 365, and choose Modify. Start with Quick Repair; if that does not help, Online Repair is a more thorough option and may require an internet connection and sign-in afterward. Close Office apps before starting. Menu labels can vary slightly by Windows build and installation type.

If only a work-managed computer is affected, contact the organization’s IT support before changing installations or removing add-ins. Administrators may control updates, security settings, or data connections. For a persistent issue, note whether it affects all files, when it began, and any error message; those details help narrow down the cause.

Frequently Asked Questions

Should I wait or force close Excel?

Wait briefly if Excel may be calculating, opening a large file, or refreshing data. If it remains unresponsive without signs of progress, and you cannot save, ending the task may be necessary. Force closing can lose unsaved changes, so check for recovered files when Excel reopens.

Why does Excel say Not Responding when calculating?

A calculation-intensive workbook can temporarily occupy Excel while formulas update. Large ranges, complex formulas, or many dependent calculations can increase the delay. If it repeatedly takes too long, work on a copy and review workbook size and formula design; do not assume the message means the file is corrupt.

How do I open Excel in Safe Mode?

On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. If Excel is stable in Safe Mode, check add-ins and startup customizations. This Windows command is not the way to start Excel in Safe Mode on a Mac.

Can I recover a workbook after Excel freezes?

Possibly. Reopen Excel and inspect Document Recovery, then check File > Info > Manage Workbook for available unsaved versions. Recovery depends on what Excel saved before the interruption; it may not include the latest edits. Cloud version history may offer another option for OneDrive or SharePoint files.

Why does only one Excel file freeze?

The file may contain demanding formulas, a slow data connection, a problematic add-in interaction, a macro, or damaged content. Test a copy, try Open and Repair, and compare behavior with a blank workbook. If a local copy works but a network copy does not, investigate the storage connection as well.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.