Excel Workbook Frozen? Causes, Checks, and Fixes

If Excel seems frozen, first wait briefly and avoid clicking repeatedly; if it responds, save with Ctrl+S and check whether a long calculation, dialog box, or editing mode is holding it up. If the whole app remains unresponsive, give it time to finish, then close Excel only as a last resort and use its recovery options to look for unsaved work.

First identify what is frozen

People use “frozen” to describe several different Excel problems, and the right fix depends on what you see. Excel may be processing a large workbook, waiting for an input, or genuinely not responding. Sometimes the program works normally but rows or columns stay visible while you scroll because Freeze Panes is enabled. A frozen-looking screen is not always a crashed workbook.

Look for clues before closing anything:

The title bar says Not Responding: Excel may be busy, or it may have stopped responding. Wait a few minutes if the file is large or a calculation has just started.
A dialog box is open: A prompt about links, file formats, passwords, or printing can be hidden behind another window. Use Alt+Tab to look for it on Windows.
A cell has a border or cursor: You may be editing a cell. Press Esc to cancel the edit, or Enter to accept it.
Rows or columns remain in view as you scroll: This is usually Freeze Panes, not an unresponsive workbook.
Only one file has the problem: The workbook may contain heavy formulas, damaged content, external connections, or a file-specific setting.

On Excel for Mac, the interface and shortcuts differ: use Command+Option+Esc to open Force Quit if the app is unresponsive. Excel for the web runs inside a browser, so check whether the browser or internet connection is also stalled before treating the workbook itself as the cause.

Try the safest steps before force-closing

When Excel is still responding intermittently, protect the work before investigating. Press Ctrl+S on Windows. If the workbook is stored in OneDrive or SharePoint and AutoSave is on, check the AutoSave status near the top of Excel, but do not assume every recent change has synchronized while the app is stuck. For a local file, a successful save is the clearest sign that the latest changes are on disk.

Then try these low-risk checks:

Wait, especially after opening a large file, refreshing data, or changing a formula that affects many cells. Excel may become responsive again once the operation finishes.
Press Esc once to cancel a pending operation or leave a menu. If a cell is being edited, Esc cancels that edit; Enter commits it.
Use Alt+Tab to find a hidden dialog, then respond to it. Do not choose an option you do not understand, such as breaking links or replacing a file, just to dismiss the prompt.
If Excel becomes responsive, save a copy with File > Save As before attempting structural repairs.

If the app is completely unresponsive, repeated clicks and key presses can queue up and make it harder to tell what happened when Excel recovers. Give it a reasonable chance to finish. On Windows, open Task Manager with Ctrl+Shift+Esc and check whether Excel is still running. Ending the task can discard changes that have not been saved, so use it only when waiting is no longer practical. On Mac, Force Quit has the same unsaved-work risk.

Recover changes after Excel closes unexpectedly

After an unexpected shutdown, reopen Excel and look for the Document Recovery pane. It may offer one or more recovered versions; open the most recent useful copy and save it under a new name before replacing the original. Recovery is not guaranteed to include every change, because it depends on when Excel last saved or created recovery information.

If the recovery pane does not appear, check Excel’s recovery options. In many Microsoft 365 Windows builds, use File > Info > Manage Workbook and look for Recover Unsaved Workbooks. The exact label or location can vary by build. You can also check File > Options > Save for the AutoRecover settings and the displayed AutoRecover file location. AutoRecover periodically preserves recovery data; it is not a substitute for saving. AutoSave is a separate feature generally associated with files stored in OneDrive or SharePoint.

Keep any recovered version separate until you have checked its contents. Compare key sheets, dates, and recent entries against what you remember. If you need to investigate the original file, make a backup copy first. Opening and repairing a workbook or removing content may change it, and recovery tools cannot always restore every formula, formatting choice, or external connection.

Check calculation and workbook workload

Excel can appear stuck while calculating formulas, especially when a workbook contains many dependent calculations, large ranges, volatile functions, or formulas copied down entire columns. A data refresh, pivot operation, or complicated paste can also take time. On a slower computer, a workbook that eventually completes may simply need more time than expected.

If Excel becomes usable, inspect the status bar for a calculation message and consider whether the slowdown began after a particular edit. On Windows, review Formulas > Calculation Options. Automatic calculation is the usual setting; switching to Manual can reduce repeated recalculation in a large model, but it also means formula results may remain out of date until you calculate. Use Manual only when you understand that trade-off. Press F9 to recalculate formulas in open workbooks, or use Formulas > Calculate Now when available. Do not trigger a full recalculation while Excel is already struggling.

To make a workbook lighter, look for formulas referencing unnecessarily broad ranges, duplicated calculations, excessive conditional formatting, and unused rows or columns containing formatting. Reduce the size of imported data where possible, and avoid repeatedly refreshing connections while editing. Before changing a business-critical model, save a separate copy and verify that results still update correctly.

Test add-ins, startup files, and external connections

An add-in or startup workbook can make Excel slow, unstable, or unable to open normally. To test without changing the original workbook, start Excel in Safe Mode on Windows: press Windows key+R, type excel /safe, and press Enter. If Excel behaves normally in Safe Mode, an add-in or customization is one possible cause; it does not prove which one is responsible.

To investigate add-ins in a normal Excel session, open File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go, then clear a selected add-in to test. Excel add-ins can be checked separately by choosing Excel Add-ins in the same Manage list. Change one item at a time, restart Excel, and re-enable items individually if the problem continues. This makes it easier to identify a cause than disabling everything permanently.

External links and data connections can also delay opening or refreshing. If Excel displays a prompt about updating links, identify the source before choosing whether to update. For a workbook that hangs during refresh, try opening a copy and, if it becomes responsive, review Data > Queries & Connections. A disconnected network location, unavailable database, or very large query may explain the delay. Do not delete a connection just to make the prompt disappear if other people or reports rely on it.

When only one workbook will not open properly

If other workbooks work normally, focus on the affected file. First make a copy using File Explorer, if possible, and try opening the copy. If it is an Excel workbook on Windows, use File > Open > Browse, select the file, open the arrow beside the Open button, and choose Open and Repair. Excel may offer to repair the workbook or extract data. Repair can help with certain file problems, but it is not a guarantee and may remove damaged elements.

Other useful checks include opening the file from its original folder rather than a temporary attachment preview, confirming that you have permission to access it, and checking whether the file is unusually large. If it came from email or a download, save it locally before troubleshooting. A workbook that fails on one computer but opens on another may point to a local add-in, available memory, network access, or Excel configuration rather than damage to the file itself.

If repair does not work, ask the file’s owner for an earlier copy or version history if the file is stored in a service that provides it. Avoid uploading sensitive workbooks to unknown online repair sites. For important financial, legal, or operational files, keep the original untouched and involve your organization’s IT or data-support team before using recovery utilities.

Make sure Freeze Panes is not the real issue

Freeze Panes keeps selected rows or columns visible while the rest of a worksheet scrolls. It can make the sheet look fixed if you expect the top row or first columns to move. On Windows, go to View > Freeze Panes > Unfreeze Panes to remove the setting. On Mac, use the View tab or View menu and choose the corresponding Unfreeze Panes command; the placement can vary slightly by Excel release. In Excel for the web, look under View for the freeze-pane controls.

Another possible source of confusion is a selected cell or a split worksheet. A thick line between rows or columns can indicate frozen panes or a split. If the ribbon and other workbooks respond, but scrolling behaves unexpectedly in just one sheet, check the View controls before closing Excel. These display settings do not normally mean that the workbook has stopped calculating or that data has been lost.

Reduce the chance of another freeze

There is no single setting that prevents every freeze, but basic file and system habits reduce the risk and make recovery easier. Save important work regularly, keep a separate backup of critical workbooks, and avoid running several demanding refreshes or calculations at once. Store shared files in an approved location with version history when available, and confirm that synchronization has completed before shutting down.

Install Microsoft 365 and operating-system updates through your organization’s approved process.
Remove or update add-ins that are no longer needed, especially if problems began after installing one.
Keep large workbooks organized and limit formulas, formatting, and imported data to what the analysis needs.
Use a descriptive new filename when testing repairs or substantial changes, preserving the source file.
For repeated failures, note the workbook, action, and error message involved; that information helps IT distinguish a file issue from a wider Excel problem.

Frequently Asked Questions

Should I wait or close Excel when it says Not Responding?
Wait first, particularly if Excel has just opened a large workbook or started a calculation. If it remains unresponsive for a long time and no dialog or progress is visible, you may have to close it, but unsaved changes can be lost. Check for recovered versions when you reopen Excel.

Does Excel recover every unsaved change?
No. AutoRecover may preserve a recent recovery copy, but it can lag behind your latest edits or be unavailable. Save regularly, and treat recovered files as possible partial copies that need checking.

Why can I scroll but some rows do not move?
Freeze Panes may be enabled, keeping selected rows or columns visible. Choose View > Freeze Panes > Unfreeze Panes in Windows Excel to remove it. This behavior is different from the entire application being frozen.

Will opening a workbook in Safe Mode delete anything?
Starting Excel with excel /safe on Windows is a diagnostic test, not a workbook repair. It starts Excel with certain features and customizations disabled. Do not save changes to a workbook unless you intend to keep them.

What if Excel freezes every time I open the same file?
Make a copy and try opening that copy with Open and Repair, then check add-ins, external links, and data connections if Excel becomes usable. If the file contains important data, preserve the original and ask the owner or IT support for help before attempting destructive changes.

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.