sodcalculator

10 Tech How-To

Excel Frozen but Not Crashed: Fix It

Guide 10-57591 · Updated · Step by step

If Excel is frozen but not crashed, the program is still running but has stopped responding to clicks or keystrokes. You can usually recover your unsaved work by waiting a few seconds, forcing a repaint, or ending the Excel process and reopening the file. Below are the most effective fixes, what causes the freeze, and how to prevent it from happening again.

Why Excel Freezes Instead of Crashing

A freeze (also called a hang) happens when Excel’s main thread is stuck waiting on something—often a calculation, a COM add-in, or a network drive. The program still occupies memory and may even show a normal window, but it doesn’t process new input. A crash, by contrast, is when the process terminates abruptly and Windows shows an error dialog. Knowing the difference matters because a frozen Excel can often be revived without losing data, while a crash usually requires recovery from the AutoRecover folder.

Common triggers include:

  • Volatile functions like NOW(), TODAY(), RAND(), or OFFSET() recalculating on every change.
  • External links to workbooks on slow or disconnected network shares.
  • Add-ins (especially third-party ones) that hook into Excel’s event system.
  • Conditional formatting rules applied to entire columns or rows.
  • Huge arrays or formulas that reference full columns (e.g., SUM(A:A)).
  • Clipboard issues when copying very large ranges.

First Steps: Wait and Try to Interact

Before doing anything drastic, give Excel 10–15 seconds. Sometimes a massive calculation finishes and the program becomes responsive again. While waiting, try pressing Esc once—this can cancel a stuck calculation or a modal dialog that is hidden behind the window. If the title bar shows “(Not Responding)” in Windows, the operating system has already detected the hang, but Excel may still recover on its own.

If waiting doesn’t help, try these in order:

  1. Click once on the Excel window to give it focus, then press Esc.
  2. Press Ctrl+Home to jump to A1—this sometimes forces a repaint.
  3. Move the window slightly by dragging its title bar. If the window moves, Excel’s UI thread is alive and the freeze may be in a calculation thread.
  4. Press Alt+Tab to switch to another app and back.

If none of these work, you need to force-close Excel. Use Task Manager (Ctrl+Shift+Esc), find Microsoft Excel under “Processes,” right-click it, and choose End task. This is safe—Excel’s AutoRecover feature saves a copy of your workbook every few minutes (default is every 10 minutes, but you can change it). When you reopen Excel, it will show a “Document Recovery” pane on the left with the last autosaved version.

How to Recover Unsaved Work After a Freeze

If you ended the task, the next time you start Excel you should see a Document Recovery pane. If not, go to File > Open > Recent and click Recover Unsaved Workbooks at the bottom. That folder contains any files Excel autosaved, even if you never manually saved them.

For a file you had saved before the freeze, the recovered version may be older than your last changes. Compare the timestamps and choose the one with the most recent “Last Saved” time. If the recovery pane doesn’t appear, you can browse to the AutoRecover file location manually:

  • In Excel, go to File > Options > Save.
  • Note the path under AutoRecover file location (e.g., C:\Users\YourName\AppData\Roaming\Microsoft\Excel\).
  • Open that folder in File Explorer and look for files with the .xlsb extension or names like “~$WorkbookName.xlsx”.

How to Prevent Future Freezes

Once your work is safe, you can reduce the chance of another freeze with these changes:

  • Turn off automatic calculation for heavy workbooks: Formulas > Calculation Options > Manual. Press F9 to recalculate when needed.
  • Disable unnecessary add-ins: File > Options & gt; Add-ins, select “COM Add-ins” in the Manage box, and uncheck any you don’t need.
  • Avoid full-column references in formulas. Use explicit ranges like SUM(A1:A1000) instead of SUM(A:A).
  • Limit conditional formatting to the used range, not entire columns.
  • Break external links if the source files are on a slow network drive: Data > Edit Links and choose “Break Links” (save a backup first).
  • Reduce the number of volatile functions—replace OFFSET with INDEX where possible.

Excel Freezes on Open or on a Specific File

If Excel freezes every time you open a particular workbook, the file itself may be corrupted or contain a problematic element. Try opening Excel in Safe Mode (hold Ctrl while clicking the Excel icon, or run excel /safe from the Run dialog). Safe Mode disables add-ins and some customization. If the file opens in Safe Mode, the culprit is likely an add-in or a custom ribbon setting.

If the file still freezes in Safe Mode, the workbook may be damaged. Try these recovery steps:

  1. Open Excel, go to File > Open, select the file, click the arrow next to Open, and choose Open and Repair.
  2. If that fails, use the “Extract data” option to pull values and formulas into a new workbook.
  3. Copy the data into a new file manually (if you can open it at all).

When to Use Windows Tools Instead of Excel Fixes

Sometimes the freeze is caused by the system itself—low memory, a failing hard drive, or a display driver issue. If Excel freezes in multiple files and also other programs freeze, check your system resources:

  • Open Task Manager and look at the Performance tab for CPU, memory, and disk usage.
  • If memory is at 100%, close other programs or restart the computer.
  • If the disk is at 100%, check for a failing drive or run chkdsk from an admin command prompt (this is a general Windows repair, not specific to Excel).

Frequently Asked Questions

Will I lose my work if I force-close Excel?
Not necessarily. Excel’s AutoRecover saves a copy every 10 minutes by default. When you reopen Excel, the Document Recovery pane shows the last autosaved version. You can also change the AutoRecover interval to every 1 minute in File > Options > Save.

Why does Excel say “Not Responding” but never closes?
That message appears when the program hasn’t processed messages for a few seconds. It often happens during a long calculation or when waiting on a network resource. Waiting or pressing Esc may resolve it.

Can a virus cause Excel to freeze?
Malware can interfere with any program, but most Excel freezes are due to calculation load, add-ins, or file corruption. If you suspect malware, run a full antivirus scan.

How do I change the AutoRecover time interval?
Go to File > Options > Save, and under “Save workbooks,” set “Save AutoRecover information every” to a smaller number like 1 or 2 minutes. This increases the frequency of saves, which can reduce data loss.

Is there a keyboard shortcut to force Excel to recalculate?
Yes. F9 recalculates all open workbooks. Shift+F9 recalculates only the active sheet. If calculation is set to Manual, these shortcuts are essential to refresh values.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →