Excel File Freezing: Causes and Fixes

If an Excel file freezes, first wait briefly and try Ctrl+S; if Excel remains unresponsive, reopen Excel in Windows Safe Mode, then test the workbook with add-ins disabled and repair the file if needed. Save a separate copy before attempting repairs, and distinguish an unresponsive workbook from Freeze Panes, which only keeps selected rows or columns visible while you scroll.

What “freezing” means in Excel

People use “Excel is freezing” to describe several different problems. Excel may stop responding completely, pause during a calculation, take a long time to open one workbook, or display a workbook that seems stuck while another program is running. The cause and best fix depend on which behavior you see.

Freeze Panes is a separate viewing feature. It does not lock the application or prevent edits. If the issue is that rows or columns remain visible while scrolling, use View > Freeze Panes > Unfreeze Panes. On Excel for Mac, use the View menu and choose Freeze Panes or Unfreeze Panes. If the entire window is unresponsive, changing this setting will not solve the problem.

What to do when Excel stops responding

Give Excel a moment before closing it. A large calculation, refresh, or file save can make the window look stuck even though Excel is working. Check whether the status bar shows a calculation or other progress, and watch for signs that the computer is still busy. Press Esc once to try to cancel a current operation; repeated clicks or key presses can make it harder to tell whether the program has recovered.

If Excel responds, save a new copy using File > Save As before further troubleshooting. If it does not respond, avoid ending the task immediately if you can wait safely: unsaved changes may be lost. On Windows, Ctrl+Shift+Esc opens Task Manager; select Microsoft Excel and choose End task only when waiting is no longer useful. On Mac, Option+Command+Esc opens the Force Quit window. After restarting Excel, look for Document Recovery and save any recovered version under a new name.

For a workbook that opens but calculates slowly, wait for calculation to finish before changing settings.
For one file that freezes while other workbooks behave normally, focus on that workbook or its links and data.
For every workbook freezing, investigate Excel, add-ins, Office updates, and available computer resources.

Check whether an add-in or Excel itself is responsible

On Windows, start Excel in Safe Mode by pressing Windows key+R, entering excel /safe, and pressing Enter. Safe Mode starts Excel with certain customizations and add-ins disabled. Open the affected workbook from that window. If it works normally there, an add-in or customization is a plausible cause; Safe Mode is a diagnostic test, not a permanent repair.

To test COM add-ins in normal Excel, open File > Options > Add-ins. In the Manage box at the bottom, select COM Add-ins and click Go. Clear the check boxes, restart Excel, and test the workbook. If that fixes the problem, re-enable add-ins one at a time, restarting and testing between changes, to identify the likely cause. Excel add-ins can be checked from the same Manage box by selecting Excel Add-ins. Turn off only add-ins you recognize or no longer need, and check with your organization before changing managed software.

If the workbook also freezes in Safe Mode, an add-in becomes less likely, but the test does not prove the workbook is damaged. Try a blank workbook and another existing file. If only the original file is affected, investigate its contents; if all files are affected, update or repair Excel and check the computer for broader performance problems.

Open and repair a workbook that may be damaged

Make a copy of the affected file in File Explorer before trying repair steps. Then open Excel, choose File > Open > Browse, select the copy, click the arrow beside the Open button, and choose Open and Repair. If offered, try Repair first. If that does not work, use Extract Data to try to recover values and formulas. Recovery may not preserve every element, such as formatting, charts, or macros, so compare the result with the original when possible.

If the file opens on another computer, save a fresh copy in a current Excel workbook format such as .xlsx, or .xlsm if it contains macros. A different computer can help distinguish a file-specific issue from a local Excel or system issue, but it does not establish that the file is completely healthy. If the workbook is stored on a network drive or synced folder, copy it to a local folder and test that copy; connection interruptions can complicate opening and saving.

For an important workbook that remains inaccessible, ask the file owner or IT support about a prior version, backup, or SharePoint/OneDrive version history if the file is stored there. Avoid repeatedly overwriting the only copy with a file that fails to open correctly.

Reduce calculation and workbook bottlenecks

A workbook can appear frozen because Excel is recalculating a large set of formulas. This is more likely with extensive formulas, large data ranges, external links, or functions that recalculate often. For example, formulas copied down hundreds of thousands of rows can make edits and saves take noticeably longer than a smaller, focused range. PivotTable refreshes, Power Query refreshes, and data connections can also take time, particularly when the source is remote.

To check calculation behavior, use Formulas > Calculation Options. Automatic is the normal setting for most workbooks. Manual calculation can reduce repeated recalculation while you make substantial changes, but results may remain out of date until you calculate. If you use Manual, recalculate deliberately before relying on figures or sharing the file; F9 calculates open workbooks in Excel for Windows. On Mac, use the Calculate Now command from the Formulas tab when available, since keyboard shortcuts can differ by keyboard and Excel version.

Other useful performance checks include:

Close other large workbooks and applications to free computer resources.
Remove unnecessary formatting applied to entire columns or rows, and limit formulas to the rows that contain data.
Review external links and data connections; refresh only sources the workbook actually needs.
In large files, consider whether a PivotTable or a database-style data model is more suitable than thousands of repeated formulas.
Use a current 64-bit edition of Microsoft 365 when appropriate for your organization. It can address some memory limits associated with 32-bit Excel, but it cannot remove limits imposed by the computer or make an inefficient workbook fast by itself.

Update or repair Microsoft 365

If multiple workbooks freeze, install available Office updates: in Excel, choose File > Account > Update Options > Update Now. The labels can vary slightly if an organization manages Office updates. Restart the computer afterward if prompted, then test Excel again.

On Windows, if updating does not help, use Windows Settings > Apps > Installed apps, select Microsoft 365, choose the three-dot menu, and select Modify. Quick Repair is a sensible first option; Online Repair is more thorough and may take longer or require an internet connection. Save your work and close Office apps before either repair. The exact labels can differ across Windows versions and installation types. On Mac, Office repair options are different; update Office through Microsoft AutoUpdate or contact your administrator if the installation itself appears damaged.

Prevent repeat freezes and protect your work

Save regularly with Ctrl+S on Windows or Command+S on Mac, and keep a separate backup when making major changes. AutoRecover can help restore work after an unexpected closure, but it is not a replacement for saving. Its interval and file location can be reviewed under File > Options > Save on Windows; organizations may control these settings. For critical files stored in OneDrive or SharePoint, confirm that syncing has completed and use version history where available.

Keep workbooks manageable: avoid unnecessary duplicate formulas, remove obsolete connections, and use descriptive file names so repaired copies are not mistaken for originals. When a workbook grows substantially, identify whether its size comes from data, formulas, formatting, embedded objects, or refreshable connections before deleting content. If an organization provides a standard add-in or template, ask support before removing it; disabling it may fix a symptom but affect other workflows.

When to use Excel for the web or another option

Opening a copy in Excel for the web can help determine whether the issue is limited to the desktop installation, and it may be convenient for basic review or collaboration. It is not a universal repair: some desktop features, connections, macros, and workbook operations behave differently or are unavailable in the web version. Do not assume that an online copy will preserve every feature of a complex workbook. For files that repeatedly exceed practical limits or need simultaneous data processing, an approved database, reporting tool, or redesigned workbook may be a better long-term choice.

Frequently Asked Questions

Why does Excel keep saying Not Responding?
Excel may be calculating, refreshing data, opening a large file, waiting on a connection, or encountering an add-in problem. If the status bar shows progress, allow time for the operation. If this happens across workbooks, test Safe Mode and install available updates.

Will force-closing Excel delete my file?
Force-closing can discard changes made since the last save, but it usually does not erase the saved file itself. After reopening Excel, check Document Recovery and save any recovered work as a separate copy. Recovery is not guaranteed, so save regularly.

Does Freeze Panes make a workbook freeze?
No. Freeze Panes keeps selected rows or columns visible as you scroll; it does not make the workbook unresponsive. To remove it, choose View > Freeze Panes > Unfreeze Panes.

Should I switch calculation to Manual to stop freezing?
Only as a temporary measure when repeated recalculation is the likely cause. Manual mode can leave displayed results outdated. Recalculate before using or sharing the figures, and return to Automatic if you do not intend to manage calculation yourself.

Why does only one Excel file freeze?
That points toward something specific to the workbook, such as its formulas, data connections, size, or possible file damage. Test a copy, try Open and Repair, and compare behavior on another computer or in Safe Mode before replacing the original.

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.