Excel Freezing Up and Not Responding? What to Do Now

If Excel is freezing or showing “Not Responding,” first wait briefly if it may be calculating or loading a large file, then try to save with Ctrl+S. If it stays stuck, note whether the problem affects one workbook or every workbook, and use the steps below to recover safely and isolate the cause.

What “Not Responding” means

In Windows, “Not Responding” usually means Excel is not processing normal input at that moment. It does not by itself prove that Excel has crashed or that the workbook is lost. Excel may be busy recalculating formulas, opening a connection, refreshing a PivotTable, processing a large paste, or waiting for another component. A short pause can be normal; a freeze that continues for several minutes or recurs whenever you take the same action needs investigation.

Before forcing Excel to close, give it time if the workbook is large or the operation was substantial. Watch for activity such as a changing progress indicator, disk activity, or the calculation status in the bottom bar. Avoid repeatedly clicking the window or pressing keys: once Excel resumes, queued clicks or keystrokes can trigger unwanted actions. If Excel becomes responsive, save a new copy using File > Save As before continuing to troubleshoot.

Recover unsaved work before troubleshooting

If Excel closes unexpectedly, reopen it and look for the Document Recovery pane. Open the most recent recovered version, compare it with the saved file if needed, and save it under a new name. Recovery is not guaranteed to contain every recent change, so check important sheets and formulas rather than assuming the recovered copy is complete.

For an open workbook that is still frozen, ending the task can discard changes made since the last save. Use that as a last resort, not as the first response. On Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task only if Excel remains unresponsive. On Mac, use Option+Command+Esc, select Microsoft Excel, and choose Force Quit. Reopen Excel afterward and check for recovery options.

To make future recovery more likely, Windows users can review File > Options > Save and check that Save AutoRecover information is enabled and that the interval is appropriate. AutoRecover is a recovery aid, not a substitute for saving. AutoSave is different: it works for supported files stored in OneDrive or SharePoint, and its availability depends on the file and account. On Mac, check Excel > Settings (or Preferences in some releases) > Save for AutoRecover options. Labels can vary slightly by Microsoft 365 update.

Find out whether the workbook or Excel is the problem

Open a blank workbook and try basic actions such as entering a value and saving it. If the blank workbook works but one particular file freezes, the issue is more likely tied to that workbook, its size, formulas, links, data connections, or formatting. If new and existing workbooks all freeze, look more broadly at Excel, add-ins, Office updates, available memory, or the computer itself.

Then test the same workbook on another computer, if one is available, or open another workbook with similar data. Note what action triggers the pause: opening the file, editing a specific cell, filtering, printing, refreshing data, or saving. A repeatable trigger is useful evidence. For example, if typing into one formula-heavy sheet causes a freeze but navigating other sheets does not, automatic recalculation may be involved; if every file stalls only during printing, check the printer and its driver.

Try low-risk fixes first

Wait, then save. If Excel recovers, save a separate copy before making further changes.
Close unnecessary programs. A computer low on available memory may struggle with Excel and other demanding applications at once. Close browser tabs or programs you do not need, then try again.
Restart the computer. A restart can clear a temporary system or resource problem. Save other work first, and do not restart while Excel is still making visible progress.
Check storage and file location. Ensure the computer has free disk space. If a workbook is on a network share or a synchronized folder, copy it to a local folder and test that copy. Do not edit two copies as though they were the same live file.
Update Microsoft 365. In Excel for Windows, go to File > Account > Update Options > Update Now when that option is available. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is installed. Save files and close Office apps before applying updates.

These checks are deliberately simple: they can distinguish a temporary resource issue from a repeatable workbook or installation problem without changing the original file.

Test Excel without add-ins

Add-ins can extend Excel, but an incompatible or malfunctioning add-in may slow startup or interfere with particular operations. On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with certain startup features and add-ins disabled. If the same workbook behaves normally in Safe Mode, an add-in or startup customization becomes a reasonable suspect, though the test does not identify which one.

To check add-ins in standard Excel for Windows, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, choose Go, and clear the checkboxes to disable them temporarily. You can also inspect Excel Add-ins through the same Manage list. Restart Excel normally and test; re-enable items one at a time to identify a possible conflict. Keep a note of what you change.

The excel /safe command is for Windows, not Mac. Excel for Mac has different add-in and startup behavior. To inspect Excel add-ins there, use Tools > Excel Add-ins and temporarily clear selected items, then restart Excel and retest. If the problem persists, restore the settings you changed before moving on.

When one workbook keeps freezing

A workbook can become slow because it asks Excel to do a great deal of work on every edit. Volatile functions, formulas applied to entire columns, extensive conditional formatting, large numbers of styles, and complex links or data connections can all contribute in some files. A workbook with many formulas is not automatically defective, but recalculating a large dependency chain after each change can take time.

Work on a copy when investigating. If the file opens, try saving a copy in the modern Excel Workbook format (.xlsx) if it is not already in that format, and remove only features you understand. Check Data > Queries & Connections for connections that refresh, and review formulas or conditional formatting in the affected sheets. Avoid deleting links, macros, or data sources just to see whether performance improves: that can change what the workbook does.

If opening the file itself is the trigger, try Excel’s Open dialog and use the arrow beside Open to select Open and Repair, where available. This is a repair attempt, not a guaranteed recovery method; keep the untouched original. If the workbook is stored in OneDrive or SharePoint, check version history before making major changes. You may be able to restore an earlier version, but confirm that it contains the data you need.

Calculation, data refresh, and large files

Excel may appear frozen while recalculating formulas or refreshing external data. A workbook that uses many formulas, array calculations, linked workbooks, or external queries can take longer after a change than it does to open. If the status bar says Calculating or shows refresh activity, allow the task to finish before closing Excel, especially if the operation is normally lengthy.

For a workbook where recalculation is clearly the bottleneck, Windows users can inspect Formulas > Calculation Options. Changing from Automatic to Manual stops Excel from recalculating formulas after every relevant change, but it also means displayed results may be out of date until calculation is triggered. This setting can affect the workbook session, so record the original setting and return to Automatic when appropriate. Do not use Manual as a general fix for an unexplained freeze.

When a refresh hangs, check whether the source is reachable and whether sign-in is required. A query pointed at a moved file, an unavailable network folder, or an online service needing authentication may wait or fail. Cancel only when Excel offers a responsive cancel option; otherwise, give the operation time and investigate the source after saving or reopening safely.

When to repair Office or seek help

If blank workbooks also freeze, add-ins are ruled out, and the issue continues after updates and a restart, repair Office on Windows. Open Windows Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, then Modify. Quick Repair is a reasonable first attempt; Online Repair is more thorough and may take longer or require internet access. The exact Windows labels can differ by release. Close Office apps and make sure important work is saved before starting.

On Mac, update Office and macOS, restart, and test with a new blank workbook. If Excel still fails across files, consult Microsoft Support or your organization’s IT administrator rather than deleting application files or changing system settings without guidance. For a work-managed computer, policy or centrally installed add-ins may be involved.

When asking for help, include your Excel and operating-system versions, whether the problem affects one workbook or all files, where the file is stored, the action that triggers the freeze, and any error message. Do not send confidential workbook contents unless your organization permits it. Those details help distinguish a workbook-specific problem from an installation or environment issue.

Frequently Asked Questions

Should I wait or close Excel when it says Not Responding?
Wait if Excel may be calculating, refreshing, or opening a large file, especially if there are signs of activity. If it remains unresponsive and no progress is visible, try recovery options after closing; force-quit only when necessary because unsaved changes may be lost.

Can I recover an Excel file I did not save?
Possibly. Reopen Excel and check the Document Recovery pane or the available unsaved-workbook recovery options. What is available depends on AutoRecover settings and how Excel closed, so recovery cannot be promised. Save any recovered version under a new name.

Why does Excel freeze only when I edit one cell?
That edit may trigger recalculation, conditional formatting, a data validation rule, a query, or other workbook logic. Test a copy, note the exact cell and action, and compare behavior in a blank workbook. Avoid removing workbook features until you know what they do.

Will Safe Mode delete my files or settings?
No. Windows Safe Mode is a diagnostic way to start Excel with certain features disabled; it does not itself delete workbook files. It can help reveal an add-in or startup issue, but normal Excel settings should be restored and tested after diagnosis.

Does AutoSave prevent lost work?
AutoSave can continuously save supported files stored in OneDrive or SharePoint, but it is not available for every file or setup and does not replace version history or sensible backups. AutoRecover is a separate feature intended to help restore work after an unexpected shutdown.

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.