Excel File Not Responding: Fix Freezes and Crashes

If an Excel file says Not Responding, first wait a minute or two without clicking repeatedly; a large calculation, refresh, or save may still be running. If it remains frozen, try opening Excel in Safe Mode, disable add-ins, and test whether the problem affects one workbook or every workbook; save recovered work to a new file if Excel becomes responsive.

What the Not Responding message means

Windows shows Not Responding when an application is not processing messages quickly enough to respond to the operating system. It does not necessarily mean Excel has crashed or that the workbook is lost. A workbook may be calculating formulas, loading a data connection, saving to a slow drive, or using more memory than usual. Excel may recover once that task finishes.

Give Excel time when the status bar shows a calculation or refresh, the file is unusually large, or the computer is busy. Repeated clicks and key presses can queue up actions, making it harder to tell whether Excel has resumed. If there is no progress after several minutes, the same freeze returns repeatedly, or Windows offers to close the application, move on to troubleshooting. Avoid ending Excel until you have considered whether a save or recovery is possible.

Start with the safest checks

Before changing settings, note whether the problem happens with one file or with any workbook. If Excel is still responsive enough, use File > Save As to make a separate copy before experimenting. If the workbook is stored in OneDrive or SharePoint, check that the internet connection is stable and that synchronization is not paused. A file opened from a network drive, email attachment, USB drive, or shared folder may also be affected by access delays.

Wait briefly and check whether Excel is calculating, refreshing data, or displaying a save-progress indicator.
Close other demanding applications if the computer is low on available memory or processing capacity.
If the workbook is on a shared or cloud location, try opening a local copy, if permitted, and compare the result. Do not overwrite a shared copy while another person is editing it.
Restart Windows only after giving Excel a reasonable chance to finish. A restart can discard unsaved work in other applications too.

If Excel becomes usable, save a copy under a different name. That gives you a safer version to troubleshoot and helps show whether the original file or Excel itself is involved.

Open Excel in Safe Mode

Safe Mode starts Excel with some startup features and add-ins disabled, making it a useful test for problems caused by extensions or custom startup settings. Close Excel if possible. In Windows, press Windows key + R, type excel /safe, and press Enter. If Excel opens, use File > Open to open the affected workbook. If the file works in Safe Mode but freezes during a normal launch, an add-in or startup component is a likely cause.

Safe Mode is a diagnostic step, not a permanent fix. It can change which features are available during that session, so do not assume the workbook itself has been repaired. If Safe Mode also freezes, test a new blank workbook. A blank workbook that works while one particular file does not points toward a workbook-specific issue; if even a blank workbook freezes, focus on add-ins, updates, or the Office installation.

Excel for Mac does not use the same Windows Safe Mode command. On a Mac, test with a new blank workbook and disable Excel add-ins through Tools > Excel Add-ins, then reopen Excel. The exact options can differ by Excel release.

Disable add-ins that may be blocking Excel

An add-in can extend Excel with tools for analysis, document management, or other tasks, but an outdated or incompatible one can slow startup or interfere with a workbook. In Windows Excel, open File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go. Clear the check boxes to disable the selected items, then restart Excel and test again. If the issue remains, return to the same dialog and check Excel Add-ins as well.

Disable add-ins as a test rather than removing them all permanently. If the problem goes away, re-enable one item at a time, restarting and testing after each change. This can identify the cause without leaving useful tools disabled. If you rely on a workplace add-in, ask your organization’s support team before removing or changing it. Mac users can review Tools > Excel Add-ins; add-in controls and availability vary by platform.

Check whether the workbook itself is the problem

If other workbooks open normally, investigate the affected file. Make a copy first and work on the copy. A workbook can become slow because it contains extensive formulas, large data ranges, external links, complex formatting, or connections that wait for a remote source. A recent change, such as adding a large number of formulas or importing data, can also reveal a performance limit.

Try opening the file from Excel with File > Open rather than double-clicking it in File Explorer. If the file opens with a warning banner, read the warning before choosing to enable content.
For a damaged workbook, in Windows choose File > Open > Browse, select the file, choose the arrow beside the Open button, and select Open and Repair. This may repair some workbook problems, but it cannot guarantee recovery.
If the file is stored in OneDrive or SharePoint, check its version history for a usable earlier version. Restoring an earlier version can replace newer changes, so compare versions or save a separate copy where possible.
If the workbook contains data connections, test whether the connection source is available. A slow or inaccessible source can make a refresh appear stuck.

Do not disable Protected View or enable macros simply to make a file open. If a file came from an unexpected email or an unfamiliar source, confirm that it is trustworthy first. Security warnings are separate from performance errors, and bypassing them may expose your computer or data to harmful content.

Reduce calculation and file workload

Some workbooks repeatedly recalculate large ranges or depend on many linked files. If Excel responds eventually but becomes unresponsive during calculation, inspect recent formula, data, or formatting changes. Avoid applying formatting or formulas to entire columns when only a limited data range is needed, and remove obsolete links or queries only if you understand their purpose. Large workbooks may also take longer when stored on a slow or unreliable connection.

As a temporary diagnostic, Windows users can choose Formulas > Calculation Options > Manual to stop automatic recalculation while investigating. This affects calculation behavior and may leave displayed formula results out of date. Press F9 to calculate when needed, and restore Automatic when you finish. Use this cautiously, especially in workbooks used for decisions or shared with others. Excel for Mac has calculation settings too, but the menu location can vary by version.

If the workbook has many external links or queries, avoid repeatedly refreshing them while troubleshooting. Close other copies of the same workbook and allow any active refresh or save to finish before trying another operation. If a file is consistently too large or complex for its current setup, consider splitting unrelated data into separate workbooks or using an appropriate database or reporting tool instead of continuing to add more content.

Update or repair Microsoft 365

If several workbooks freeze, check for Office updates. In Excel for Windows, go to File > Account > Update Options > Update Now, if that option is available. Work or school devices may be managed by an administrator, so update controls can be restricted. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is installed and available.

If updating does not help, Windows users can repair Microsoft 365. Open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, and select Modify. Choose Quick Repair first. If the problem persists, Online Repair is a more thorough option and may require an internet connection and a fresh sign-in. The labels can vary slightly between Windows releases. Save your work and close Office applications before repair. On Mac, Office repair options differ; updating or reinstalling Microsoft 365 may be appropriate, but check that important files are backed up first.

Recover unsaved work and prevent another loss

If Excel has to close, reopen it and look for the Document Recovery pane, which may list automatically recovered workbooks. In Windows Excel, also check File > Info > Manage Workbook for the option to recover unsaved workbooks. Available recovery files depend on Excel’s settings and whether it had time to create them, so recovery is not guaranteed. Save any recovered version under a new name and compare it with the last saved copy.

For future work, save regularly with Ctrl + S in Windows; on Mac, use Command + S. AutoSave is available for eligible files stored in OneDrive or SharePoint when it is enabled, but it is not a substitute for checking that the latest changes have synchronized. Keep a separate backup of important workbooks, especially before major edits or repairs. If a freeze recurs, record the workbook location, the action that triggers it, and whether Safe Mode changes the behavior; those details make further support more effective.

Frequently Asked Questions

Should I wait or force close Excel?

Wait if Excel may be calculating, saving, or refreshing data, and avoid repeated clicks. If there is no progress after several minutes and the application remains stuck, you may need to close it. On Windows, Ctrl + Shift + Esc opens Task Manager; on Mac, Option + Command + Esc opens Force Quit. Unsaved changes may be lost, so treat force closing as a last resort.

Why does Excel freeze only with one file?

A single-file problem often points to workbook size, formulas, external links, data connections, or possible file damage rather than a general Excel failure. Test a copy, try Open and Repair in Windows, and compare the file with an earlier version if one is available.

Will Safe Mode delete my workbook or change it?

Safe Mode is intended to help diagnose Excel startup problems; opening Excel in that mode does not by itself delete the workbook. Still, save a separate copy before making changes, and remember that some add-ins or features may not be available during the Safe Mode session.

What if Excel freezes while saving to OneDrive?

Check the connection and synchronization status, then wait before closing Excel so the save has a chance to finish. If you can, save a separate local copy using Save As, and check OneDrive or SharePoint version history before replacing a cloud file.

Can I recover a workbook after force closing Excel?

Possibly. Reopen Excel and check the Document Recovery pane or, in Windows, File > Info > Manage Workbook for recoverable unsaved work. Recovery depends on what Excel saved automatically, so it is not certain. Save any recovered file separately.

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.