Excel Workbook Keeps Freezing? Troubleshooting Guide

If an Excel workbook keeps freezing, first give it a minute to finish, then save a copy if Excel responds; if the problem returns, open Excel in Safe Mode and test whether add-ins or the workbook itself are responsible. On Windows, also check calculation load, file size, and available memory before repairing Office or force-closing the app.

First identify what is actually freezing

Excel can appear frozen for several different reasons: it may be calculating, waiting for a file or network connection, handling a large paste, or genuinely stuck. Look at the status bar and title bar, watch for a progress indicator, and notice whether the same action causes the pause each time. A pause after editing one particular formula points to a different cause than Excel becoming unresponsive immediately after launch.

Wait briefly before clicking repeatedly. Repeated clicks and key presses can queue up, then run all at once when Excel recovers. If the workbook is stored in OneDrive, SharePoint, a network folder, or an external drive, a slow or interrupted connection may also delay saving or opening. If Excel shows “Not Responding,” it does not prove the workbook is lost; the program may still be processing.

Try to distinguish a workbook-specific problem from an Excel-wide one. Open a blank workbook and perform a simple action, such as entering a value. If that works normally while one file repeatedly hangs, focus on that file’s formulas, formatting, links, or contents. If blank files also freeze, investigate add-ins, Office updates, and the computer’s available resources.

Protect your work before troubleshooting

If Excel becomes responsive again, save the workbook under a new name before making major changes. Use File > Save As and choose a local folder, such as Documents, for the diagnostic copy. This preserves the original and helps separate workbook problems from synchronization or network problems. If the file is macro-enabled, keep its .xlsm extension; saving it as .xlsx removes VBA macros.

If Excel is completely unresponsive, avoid ending the task immediately. Wait for any calculation or save operation to finish. If you must close Excel, Windows may offer a recovery pane the next time the application starts. Excel’s AutoRecover settings can preserve versions of unsaved work, but recovery is not guaranteed, so treat it as a fallback rather than a substitute for saving.

To review recovery settings in Excel for Microsoft 365 on Windows, open File > Options > Save and check that Save AutoRecover information is enabled. The displayed interval controls how often recovery information is saved; it does not mean every change is permanently written to the workbook. Excel for Mac has separate settings under Excel > Settings, including AutoSave and AutoRecover options, and the available controls can differ by release.

Use Safe Mode to check add-ins

Excel Safe Mode starts the Windows application with many startup customizations and add-ins disabled. Close Excel, press Windows key + R, type excel /safe, and press Enter. If the workbook stops freezing in Safe Mode, an add-in or startup customization is a likely cause. Safe Mode is a diagnostic test, not a repair: it does not prove which component is responsible.

Disable add-ins one at a time in normal Excel so you can identify the cause. Go to File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage, choose Go, and clear one add-in’s checkbox. Repeat with Excel Add-ins if needed, restarting Excel between tests. If the freezing stops after disabling one, check with the add-in’s publisher for an update or leave it disabled if you do not need it.

Excel for Mac does not use the Windows /safe launch command. Instead, test by disabling available add-ins in Excel > Settings > Add-ins, then restart Excel and reopen the workbook. Menu names can vary by Mac release. If you use a company-managed device, an administrator may control which add-ins are available.

Check calculation settings and formula load

A workbook with many formulas can appear frozen while Excel recalculates. This is especially likely after changing a cell that feeds thousands of other formulas, opening a file with automatic calculation enabled, or refreshing data. In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options and check whether Automatic is selected. Manual calculation can reduce repeated recalculation, but it also means displayed formula results may be out of date until you calculate again.

If you switch to Manual as a temporary test, remember to restore Automatic when finished unless you deliberately want manual calculation. Press F9 to calculate open workbooks; Ctrl+Alt+F9 forces a full calculation of all formulas. On Mac, F9 may require the Fn key depending on keyboard settings, and the recalculation shortcuts differ by keyboard and Excel release. The Formulas menu is a reliable way to inspect calculation options on either platform.

Look for formulas that do unnecessary work. References to entire columns, such as A:A, can make some calculations more demanding than references limited to the actual data range, particularly in array calculations or formulas repeated across many cells. Volatile functions such as NOW, TODAY, RAND, and OFFSET recalculate more often than ordinary formulas. Large numbers of conditional-formatting rules, complex array formulas, and what-if data tables can add further calculation work.

For example, if a workbook has 80,000 rows of records but a summary formula scans a million-row column repeatedly, restricting the reference to the used rows or converting the data to an Excel table may improve responsiveness. Make changes in a copy and verify totals afterward. Do not delete formulas or change calculation mode permanently just because the workbook opens faster; first confirm that the results remain correct and current.

Reduce workbook size and complexity

File size alone does not determine whether a workbook will freeze, but oversized or structurally complex files are more difficult to open, calculate, save, and synchronize. Common contributors include pasted images, embedded objects, extensive cell formatting, hidden sheets, large pivot caches, and imported data that is no longer needed. A workbook can also have a large used range if formatting has been applied far beyond the visible data.

In a copy of the file, inspect the workbook for unnecessary sheets, objects, and duplicate formatting. If you know that blank rows and columns beyond the real data contain accidental formatting, remove that formatting carefully and save the copy. Avoid selecting a huge range and applying new formatting as a quick fix: that can make the used area larger. For data-heavy work, consider whether Power Query, a data model, or a database is a better fit than storing every intermediate result as worksheet cells.

Save a copy in the current Excel format, .xlsx or .xlsm as appropriate, rather than repeatedly converting between formats. Older .xls files have format limits and may behave differently. If the workbook contains macros, external connections, or specialized features, check that they still work after any format conversion. A smaller file is not automatically a healthier file, so validate formulas, charts, and outputs after cleanup.

Investigate external links, refreshes, and synchronization

A workbook may pause while it updates links to other workbooks, refreshes a query, or contacts a data source. If the freeze occurs during opening, look for prompts about updating links or refreshing connections. In a diagnostic copy, use Data > Queries & Connections to review available connections; the exact pane options depend on the connection type. Do not remove a connection unless you understand what uses it, because formulas, reports, or refresh workflows may depend on it.

Test a synchronized workbook from a local copy. If the local copy opens and saves normally but the cloud-stored file does not, the issue may involve synchronization, permissions, or the connection rather than calculation. Make sure only one person or process is not repeatedly replacing or locking the file. For shared workbooks, allow synchronization to finish before closing Excel, and avoid editing a local copy and a cloud copy as if they were the same live file.

If a refresh itself is slow, identify which query or connection is responsible rather than repeatedly refreshing everything. A source may be unavailable, require sign-in, or return much more data than the workbook needs. Check with the owner of the data source before changing credentials or connection settings, especially on a managed work computer.

Check updates, memory, and Office health

Close other demanding applications and confirm that the computer has free storage and memory. Large workbooks, browser tabs, video calls, and other Office applications can compete for resources. Restarting the computer may clear a temporary resource problem, but it will not correct a workbook with inefficient formulas or a faulty add-in. If Excel freezes only after a particular recent change, undo that change when possible or return to the saved copy.

On Windows, check for Microsoft 365 updates from Excel using File > Account > Update Options > Update Now. Menu availability can be controlled by an organization. If Excel continues to freeze across multiple files after add-ins and resource pressure are ruled out, repair Office from Windows Settings > Apps > Installed apps: select Microsoft 365, choose Modify, and try Quick Repair first. Online Repair is more thorough and may require an internet connection and sign-in afterward.

On Mac, update Office through Microsoft AutoUpdate, commonly available from Help > Check for Updates in an Office app, or through the update method provided by your organization. Windows repair instructions do not apply to macOS. If the issue affects only one workbook after updates, preserve the original and test a copy; repairing Office is less likely to fix damaged or unusually complex content within a single file.

When to recover or rebuild a damaged workbook

If one workbook alone freezes or fails to open, start Excel first and use File > Open > Browse. Select the file, choose the arrow beside the Open button, and try Open and Repair if that option is available. Excel may offer to repair the workbook or extract data. Results vary, and a repair can remove damaged elements, so keep the original untouched.

If the file opens after repair, inspect key worksheets, formulas, charts, named ranges, and connections. Compare important totals with a previous version or another trusted source. You can also copy healthy sheets into a new workbook, but copying may not bring across every workbook-level feature, such as names, connections, macros, or formatting behavior. Rebuilding should be a measured last resort, not the first response to a temporary delay.

Prevent future freezes

Save regularly, keep a separate version before substantial edits, and use version history when it is available in OneDrive or SharePoint. Keep Excel and necessary add-ins updated, remove add-ins you no longer use, and refresh only the data connections you need. For recurring large-data work, use tables and bounded data ranges, avoid excess formatting, and document whether the workbook depends on manual calculation or external sources.

It also helps to record the action that triggers the freeze, the workbook location, and whether other files are affected. Those details make troubleshooting more efficient: a freeze during a refresh suggests a connection issue, while a freeze after entering a formula suggests calculation load. If the file belongs to an organization, share those observations with IT rather than changing managed settings or deleting shared connections.

Frequently Asked Questions

Why does Excel freeze when I open one specific workbook?
The file may be recalculating formulas, updating external links, refreshing data, loading many objects, or contain damaged content. Test a local copy, try Excel Safe Mode on Windows, and compare its behavior with a blank workbook before changing the original.

Should I force close Excel when it says Not Responding?
Not immediately. Excel may still be calculating or saving, so wait and watch for progress if possible. Force-closing can lose unsaved changes. If it remains stuck, end the task only when necessary, then check for Document Recovery when Excel restarts.

Will switching calculation to Manual fix a freezing workbook?
It can reduce repeated recalculation in a formula-heavy file, but it does not remove the underlying workload. Formula results can become stale in Manual mode. Use it as a controlled test, calculate before relying on results, and restore Automatic if manual calculation is not part of your normal workflow.

Why does Excel freeze when I paste data?
A large paste can trigger formula recalculation, conditional formatting, data validation, or other workbook rules across the destination range. Try a smaller batch in a copy, check whether the destination contains extensive formatting or formulas, and allow the calculation to finish before repeating the paste.

Can I recover an Excel file after a freeze?
Sometimes. Reopen Excel and look for Document Recovery, or check AutoRecover and version history if enabled. Recovery depends on what was saved before the freeze, so verify recovered formulas and data against a trusted version and keep the original file.

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.