Excel Freezing? Fix a Workbook That Stops Responding

If Excel is freezing, first wait briefly to see whether it is finishing a calculation or loading a large workbook; then save your work if possible, close other demanding apps, and restart Excel. If the problem keeps happening, open Excel in Safe Mode, check add-ins, and test whether the freeze is limited to one workbook before changing settings or repairing Microsoft 365.

First, identify what is freezing

“Freezing” can describe several different problems: Excel may stop responding entirely, take a long time after a particular action, or appear stuck while calculating. The distinction matters. A large workbook can temporarily use substantial memory and processor time without being broken, while a freeze that happens every time you open Excel may point to an add-in, startup file, or installation issue.

Notice what you were doing immediately before the slowdown. Did it begin when opening one file, refreshing a query, sorting a large range, editing a formula, or switching worksheets? Also check whether only Excel is affected. If other programs respond normally, focus on Excel and the workbook; if the whole computer is sluggish, close other resource-intensive apps and check available system resources.

Wait briefly if Excel is calculating or processing a large operation. Repeatedly clicking buttons can queue extra commands and make the apparent delay worse.
Look for a status message at the bottom of the Excel window, such as a calculation or data-refresh indication.
Try a different workbook if Excel becomes responsive again. A problem confined to one file suggests workbook-specific causes.
Keep recovery in mind: if Excel is unresponsive, avoid ending the task until you have allowed it time to recover, especially if the workbook contains unsaved changes.

One terminology trap: “Freeze Panes” is an Excel view feature that keeps selected rows or columns visible while scrolling. It does not mean Excel has stopped responding. If the program itself will not respond to clicks or typing, use the troubleshooting steps below.

Try low-risk fixes before closing Excel

If the window is still responding intermittently, save the workbook with Ctrl+S on Windows. On a Mac, use Command+S. If Excel is blocked by an operation, Windows users can try Ctrl+Break to request that a calculation or running operation stop; on many keyboards, Break may require a function-key combination. This is not guaranteed to work when Excel is completely unresponsive, and interrupting a process may leave the current operation incomplete.

Do not repeatedly click the workbook or press keys while the application is not responding. Give it time, particularly during a large calculation or data refresh. If Excel recovers, save a separate copy before experimenting with formulas, connections, or workbook settings. Close unrelated programs to free system resources, then reopen the workbook and see whether the same action triggers the issue.

If you must force Excel to close on Windows, open Task Manager with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. Unsaved changes may be lost, although Document Recovery may offer recovered files when Excel starts again. On Mac, use Option+Command+Esc to open Force Quit. Force quitting also risks losing unsaved work, so treat it as a last resort rather than a routine fix.

Use Safe Mode to check add-ins

An add-in can interfere with startup or with certain Excel tasks. Safe Mode starts Excel with many startup customizations and add-ins bypassed, making it a useful diagnostic test. On Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens, test the same workbook or action that caused the freeze. If it works normally in Safe Mode but not in a regular session, an add-in or startup item is a plausible cause; Safe Mode does not prove which one.

To test add-ins in normal Excel, open File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go. Clear the checkboxes to temporarily disable the listed COM add-ins, restart Excel, and test again. You can also inspect Excel add-ins by choosing Excel Add-ins from the Manage list and selecting Go.

If disabling add-ins resolves the problem, re-enable them one at a time, restarting and testing after each change. That helps isolate the conflict without permanently removing software you need. The Windows Safe Mode command is not the same as macOS startup behavior; on a Mac, check Excel add-ins from Excel’s Preferences or Settings and test by disabling them there. Menu labels can vary with the Office for Mac release.

Check whether one workbook is responsible

If a new blank workbook works but one particular file freezes Excel, investigate that file before reinstalling Office. Make a backup copy first. If the workbook is stored on a network drive, SharePoint, OneDrive, or another synced location, try opening a local copy where permitted. A slow connection, sync activity, or a file that is still being updated can add delays that look like an Excel problem.

Large or complicated workbooks may take time to calculate, save, or refresh. Common contributors include formulas that reference very large ranges, extensive conditional formatting, many pivot tables, external links, data connections, and large numbers of shapes or images. Volatile functions such as NOW and RAND recalculate frequently; OFFSET and INDIRECT can also contribute to recalculation work in some designs. These are not automatically wrong, but a workbook with many such formulas may respond slowly.

Try narrowing the test: open a copy, wait for any calculation to finish, and then change one feature at a time. For example, if a freeze happens only when refreshing a query, test whether other workbook actions remain responsive before investigating the query or its data source. Avoid deleting formulas or connections from the only copy. If a workbook is essential, ask its owner or administrator before changing its structure.

Review calculation settings carefully

When a workbook freezes after formula edits or data changes, recalculation may be the trigger. On Windows, check Formulas > Calculation Options. If Excel is set to Automatic, changing a cell can cause dependent formulas to recalculate. A workbook with a large dependency chain may take time to update, even though Excel is working as designed.

Manual calculation can be a temporary diagnostic option for a workbook that recalculates too often. However, it can leave displayed formula results out of date until you recalculate. If you change the setting, remember to use F9 to calculate open workbooks when appropriate, or restore Automatic when finished. Be especially cautious with workbooks used for financial, operational, or safety-related decisions: stale results can be misleading.

On Excel for Mac, calculation settings are also available from the Formulas tab, though the ribbon layout can differ by release. Excel for the web has fewer desktop controls and may behave differently with large workbooks. If the file freezes only in the browser, try the desktop app if your Microsoft 365 license and organization allow it, or test the workbook in another supported browser.

Save, recover, and protect the workbook

After Excel recovers, save the workbook under a new name or make a copy before attempting repairs. This preserves the original if a troubleshooting step changes formulas, links, or formatting. For a file that will not open normally, Windows desktop Excel may offer Open and Repair: choose File > Open > Browse, select the file, choose the arrow beside the Open button, and select Open and Repair. The option may not be available in Excel for the web, and repair attempts can alter or remove damaged content.

If Excel closes unexpectedly, look for Document Recovery when you restart the application. You can also review AutoRecover options under File > Options > Save on Windows. AutoRecover is intended to help recover work after interruptions; it is not a substitute for saving regularly, and it may not restore every recent change. Recovery behavior can differ on Mac and in the web app.

For files stored in OneDrive or SharePoint, version history may provide a way to restore an earlier version, depending on the account and permissions. Before reverting, check whether the latest version contains work that needs to be preserved. If the workbook contains sensitive information, use only storage and recovery locations approved by your organization.

Update Excel or repair Microsoft 365

Install available Office updates if Excel continues to freeze across multiple workbooks. In Windows desktop Excel, go to File > Account > Update Options > Update Now, if that option is available. Some work or school installations are managed by an organization, so update controls may be restricted or updates may arrive on a managed schedule. Save and close Office apps before installing updates when prompted.

If the issue persists, Windows users can try repairing the Microsoft 365 installation. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365 or Office, choose its menu, and select Modify. Follow the prompts for Quick Repair; if that does not help, an Online Repair may be available. The exact labels can vary by Windows version and installation type. Online Repair may require an internet connection and can take longer.

On Mac, Office updates and app troubleshooting use different controls from Windows. Check for updates through Microsoft AutoUpdate or the update option provided with Office, and consult your organization’s support team if the Mac is managed. Repairing or reinstalling Office should generally come after testing a blank workbook, Safe Mode or add-ins, and the affected file—not as the first step.

Reduce the chance of future freezes

Prevention is mostly about limiting unnecessary work and keeping recoverable copies. Save regularly, keep Excel and the operating system updated through approved channels, and avoid opening several very large workbooks at once on a device with limited memory. If a workbook has grown over time, remove obsolete formatting and unused objects from a copy, and review whether external links and data connections are still needed.

Use smaller, clearly defined data ranges where practical instead of applying formulas or formatting to far more cells than the data requires.
Refresh external data when needed rather than repeatedly triggering refreshes while Excel is busy.
Keep a backup before changing calculation mode, removing add-ins, repairing a file, or editing a complex workbook.
Record what action causes the freeze and whether it occurs in other files; that detail makes support requests much easier to diagnose.

There is no single fix for every freeze. A temporary pause during a heavy calculation is different from Excel becoming unresponsive every time it launches. Working from the least disruptive tests toward file repair or Office repair reduces the risk of losing work and helps identify the cause rather than masking it.

Frequently Asked Questions

Why does Excel keep saying Not Responding?
Excel may be busy calculating, loading, refreshing data, or saving, or it may be blocked by an add-in or workbook problem. Wait briefly, note what action triggered it, and test a blank workbook or Safe Mode if the issue recurs.

How do I unfreeze Excel without losing work?
Wait to see whether Excel recovers and try saving if the window responds. On Windows, Ctrl+Break may interrupt a calculation; it cannot guarantee recovery. Force-closing can lose unsaved changes, so use it only when waiting and safer options fail.

Why does Excel freeze only when I open one file?
The file may contain heavy formulas, external data connections, links, or damaged content. Test a copy, compare with a blank workbook, and consider Open and Repair on Windows if the file will not open normally.

Can add-ins make Excel freeze?
Yes. Testing Excel in Safe Mode and temporarily disabling add-ins can help identify whether one is involved. Re-enable them one at a time to find a specific conflict, rather than removing all add-ins permanently.

Will changing Excel to Manual calculation fix freezing?
It may reduce repeated recalculation in some workbooks, but it does not address every cause and can leave formula results outdated. Treat it as a temporary test, recalculate when needed, and restore Automatic if that is the workbook’s intended setting.

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.