Excel Freezing? Causes, Fixes, and Prevention

If an Excel file keeps freezing, first wait briefly to see whether Excel is calculating or loading; if it becomes responsive, save a copy, then troubleshoot add-ins, workbook size, formulas, and the file itself. If the problem happens with only one workbook, focus on that file; if Excel freezes with every workbook, check Excel, its add-ins, and your computer.

First, tell a temporary pause from a true freeze

A workbook can appear stuck while Excel performs a demanding task, such as recalculating formulas, refreshing a connection, opening a large file, or updating a PivotTable. A status message such as “Calculating” or “Refreshing” can be a clue that work is still underway. Give Excel time, especially after a large refresh or calculation, and avoid repeatedly clicking the window: extra actions can queue up and make it harder to tell when the program responds.

On Windows, open Task Manager with Ctrl+Shift+Esc and look at Excel’s status and resource use. On a Mac, Option+Command+Esc opens the Force Quit window, but it does not provide the same resource details as Activity Monitor. High CPU use can mean Excel is working, though it does not prove that a calculation will finish. A “Not Responding” label also does not by itself prove the workbook is permanently stuck.

If Excel recovers, save immediately using Ctrl+S on Windows or Command+S on Mac. If it remains unresponsive for a long time and you must close it, unsaved changes may be lost. AutoSave can help with files stored in supported OneDrive or SharePoint locations, but it is not a guarantee that every recent change has been saved. After restarting Excel, check for a Document Recovery pane or available recovery files before assuming the work is gone.

Start with low-risk checks

Before changing the workbook, try simple checks that can distinguish a resource problem from a damaged file. Close other demanding applications and make sure the computer has free storage. If the workbook is on a network drive, removable drive, or synced folder, make a local copy and open that copy. A slow or interrupted connection can look like an Excel freeze while the application is waiting for file access.

Restart Excel, then open a small, unrelated workbook. If it works normally, the original workbook is a more likely source of the problem.
Restart the computer if Excel remains sluggish across files. This clears temporary system issues, though it will not repair a damaged workbook.
Check whether Excel is waiting for a prompt behind another window, such as a link-update or sign-in dialog. Use Alt+Tab on Windows to look through open windows.
Confirm that the file is not being edited in conflicting places or repeatedly synchronized by another process. If practical, pause the sync briefly and work on a separate copy.

Do not repeatedly force-close Excel as a first response. Ending the process can discard unsaved work and interrupt a save or refresh. If the workbook is important, preserve the original before attempting repairs or removing content.

Find out whether the workbook or Excel is the cause

Compare the problem across files. If one particular workbook freezes but a new blank workbook does not, investigate that workbook’s formulas, data connections, formatting, size, or possible corruption. If several unrelated workbooks freeze, investigate add-ins, updates, and the Office installation. This simple comparison saves time because repairing a workbook will not fix a broken add-in, and reinstalling Office is unlikely to solve a problem limited to one oversized file.

Windows users can start Excel in Safe Mode by pressing Windows key+R, typing excel /safe, and pressing Enter. Open the troublesome workbook there. If it works in Safe Mode but not in a normal start, an add-in or another startup component is a strong possibility. Safe Mode is a diagnostic step, not a repair; some features may be unavailable while it is running. Excel for Mac does not use this Windows Safe Mode command.

Also compare the desktop app with Excel for the web if the file is stored in OneDrive or SharePoint and your account permits web editing. If the browser version opens the file but desktop Excel does not, desktop add-ins or installation issues become more plausible. If both struggle with the same workbook, the workbook’s structure, data, or size may be contributing. The web version has different feature support, so a file that relies on particular desktop features may not behave identically there.

Reduce calculation and workbook load

Large workbooks can slow down because Excel recalculates formulas when inputs change. Volatile functions, extensive formulas across whole columns, repeated lookups over large ranges, and complex array calculations can add work. External links, data connections, Power Query refreshes, and PivotTables can also make opening or updating a file take longer. A pause during a refresh is not necessarily evidence of corruption.

If the workbook is usable between pauses, inspect formulas and connections before deleting anything. For example, formulas that refer to a full column may make Excel evaluate far more cells than the actual data requires. Replacing an unnecessarily broad range with the real data range can reduce work, but verify results carefully. If many formulas repeat the same calculation, a helper column or a more efficient formula design may help; changing formulas without checking dependencies can alter the workbook’s results.

For a workbook that recalculates constantly, you can test manual calculation on a copy. In Windows Excel for Microsoft 365, use Formulas > Calculation Options > Manual. This stops automatic recalculation until you request it, so displayed formula results may be out of date. Press F9 to calculate open workbooks or Shift+F9 to calculate the active worksheet, then return the setting to Automatic when appropriate. Calculation settings can affect other open workbooks, so note the original setting and do not treat manual mode as a permanent cure.

Other common sources of excess work include a very large used range, extensive conditional formatting, and many embedded objects or images. Press Ctrl+End on Windows to see where Excel considers the worksheet’s used area to end. If it jumps far beyond the real data, investigate unnecessary formatting or content on a copy. Deleting rows or clearing formats indiscriminately can damage layouts, formulas, or print settings, so remove only what you can identify as unnecessary.

Check add-ins and update Excel

Add-ins can add features to Excel, but a malfunctioning or incompatible one may cause slow starts, freezes, or crashes. If Safe Mode helped, disable add-ins in normal Excel and test again. In Windows, go to File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage box and select Go; clear a checkbox to turn off an add-in temporarily. You can also check Excel Add-ins in the same Manage box. Disable one at a time and reopen the workbook so you can identify the one associated with the change.

On Mac, add-in controls and menus differ from Windows; Excel add-ins are managed through Tools > Excel Add-ins, while third-party add-ins may have their own instructions. Excel for the web does not use Windows COM add-ins. If disabling an add-in makes no difference, restore it before testing the next one, and check with the add-in’s publisher for compatibility information.

Install available Microsoft 365 updates, since updates can include reliability fixes. In Windows Excel, use File > Account > Update Options > Update Now when that option is available. Managed work or school devices may receive updates through an administrator instead. If Excel freezes across many files even after updates and add-in checks, consider repairing Microsoft 365 from Windows Settings > Apps > Installed apps: select Microsoft 365, choose Modify, and try Quick Repair first. Online Repair is a more extensive option and may require an internet connection and sign-in afterward.

Recover a workbook that will not open

Keep an untouched copy before attempting file repair. In Windows Excel, use File > Open > Browse, select the workbook, open the arrow beside the Open button, and choose Open and Repair. If Excel offers repair or data extraction, follow the prompts and save any recovered version under a new name. This feature can help with some damaged files, but it cannot promise to restore every formula, format, or object.

If the file is stored in OneDrive or SharePoint, check its version history and restore or download an earlier version to a separate file. A previous version may help if the freezing began after a recent edit, but restoring over the current file can remove later changes. For local files, check Excel’s recovery options after a crash. In Windows, File > Info may include Manage Workbook and Recover Unsaved Workbooks; the command is available only when Excel has recovery data to show. Recovery is not a substitute for saving regular copies.

When the workbook opens but becomes unusable during a specific action, note exactly what triggers the problem: opening a sheet, refreshing a connection, editing a cell, or running a macro. That detail can narrow the cause. If the workbook contains important business data, preserve the original and involve your organization’s IT support before removing links, macros, or data connections.

Prevent repeat freezes

Prevention is mostly about reducing avoidable work and keeping recoverable copies. Save regularly, use version history where available, and keep a separate backup before major structural changes. Avoid storing the only copy of a critical workbook on a removable drive or in a location with unreliable connectivity. If multiple people edit a shared file, use a supported cloud location and coordinate changes rather than passing competing copies around.

Keep formulas and formatting limited to the rows and columns that need them.
Refresh external data only when needed, and close other workbooks or programs that consume substantial memory.
Remove obsolete links, queries, images, or conditional-formatting rules only after confirming they are no longer needed.
Update Excel and review add-ins after a freeze begins, especially if the issue started after installing new software.
Maintain a clear original and a working copy when testing repairs, calculation settings, or structural changes.

There is no single file-size threshold that guarantees trouble. Performance depends on the workbook’s formulas, formatting, connections, available computer resources, and Excel features in use. A smaller workbook with complex calculations can be slower than a larger one containing mostly static values, so the trigger and workload matter more than file size alone.

Frequently Asked Questions

Why does Excel say Not Responding? Excel may be busy recalculating, loading, refreshing data, or waiting on a file location. It can also be stalled by an add-in, a damaged workbook, or limited system resources. Wait briefly, then compare the problem with a blank workbook and, on Windows, test Excel in Safe Mode.

Will I lose my work if I force Excel to close? You can lose changes that were not saved. AutoSave may protect some changes in supported cloud files, but it is not guaranteed to capture the latest edit. If possible, wait for Excel to recover and save a copy; after a crash, check Document Recovery and available recovery files.

Why does only one Excel file freeze? That file may contain demanding formulas, a data refresh, extensive formatting, embedded objects, external links, or damaged content. Open a copy, test it in Safe Mode, and use Open and Repair if it will not open. Preserve the original while investigating.

Does a large Excel file always cause freezing? No. File size alone does not determine performance. Formula complexity, whole-column references, formatting, data connections, and available memory can matter more than the number of megabytes. Look for the action that triggers the slowdown and check whether Excel is calculating or refreshing.

What should I try if Excel freezes on every file? Test a blank workbook and start Excel in Windows Safe Mode. If Safe Mode helps, review add-ins; if not, update Microsoft 365, restart the computer, and consider Quick Repair. On a managed device, ask IT support before changing installation settings.

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.