Excel Frozen Not Responding? Steps to Recover Safely

If Excel says Not Responding, stop clicking and give it a little time: it may be calculating, opening a large file, or waiting on another resource. If it stays frozen, try to preserve your work first; then reopen Excel and troubleshoot the file, add-ins, or Office installation rather than repeatedly forcing the app to close.

Why Excel freezes or stops responding

Not Responding is a Windows status, not a diagnosis. It means Excel is not currently responding to Windows messages; it does not, by itself, prove that the program has crashed or that the workbook is lost. A long calculation, a large paste, a file stored on a slow or unavailable network location, or a busy computer can temporarily make the window appear stuck.

The cause may be the workbook, Excel, or something outside the app. Workbooks with many formulas, links to other files, large data models, complex formatting, or macros can take time to recalculate or load. An add-in may also interfere, and a damaged workbook or an outdated Office installation can cause recurring problems. If only one particular file triggers the freeze, investigate that file before assuming Excel itself is broken.

Look for clues before intervening. If the computer is still busy and Excel has just started a demanding task, waiting may let it finish. If the same state continues, the window never updates, and no progress is apparent, move on to careful recovery steps. Do not treat a busy-looking screen as a guarantee either way: Windows cannot reliably tell you whether Excel will eventually recover.

What to do first when Excel is unresponsive

Stop sending commands. Repeated clicks, keystrokes, or attempts to open the same file can queue more work and make it harder to tell what Excel is doing.
Wait briefly if a task may be underway. Give a calculation, refresh, or large file operation time to complete. The appropriate wait depends on the workbook and computer; there is no universal time limit.
Check whether Excel has opened a prompt. A dialog box can be hidden behind another window, making the main workbook seem frozen. Use Alt+Tab on Windows to check open windows. On Mac, use Command+Tab to switch apps and Mission Control or the Window menu to look for Excel dialogs.
Consider whether the file is on a network or cloud location. A disconnected VPN, weak connection, or sync issue can delay access. Avoid creating several duplicate copies while the original might still be saving.
Close Excel only if it does not recover. On Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. On Mac, press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. These actions can discard unsaved changes, so use them as a last resort.

If Excel is responding again, save a new copy of the workbook before continuing with major edits or troubleshooting. Use File > Save As and choose a clear name and a location you can access. If the workbook is stored in OneDrive or SharePoint and AutoSave is on, check the saved status before assuming every recent change has synchronized.

How to recover work after closing Excel

When Excel starts again after an unexpected close, it may show the Document Recovery pane with versions it could restore. Review the available entries, open the most recent useful version, and save it under a new name. Recovery depends on what Excel managed to record before the freeze; it may not include the last few edits.

If the pane does not appear, check for an unsaved workbook in Excel for Microsoft 365 on Windows: choose File > Info > Manage Workbook > Recover Unsaved Workbooks, if that option is available. Open any relevant recovery file and save it promptly. The exact recovery options can depend on the version and whether the workbook had been saved before.

AutoSave and AutoRecover are different. AutoSave can continuously save supported files stored in OneDrive or SharePoint, when the feature is enabled and the connection works. AutoRecover periodically stores recovery information to help restore work after a failure; it is not a substitute for saving and does not promise to capture every change. On Mac, look for recovered files when Excel reopens, then use File > Save As to make a separate saved copy.

If the file was already saved, check its location and file name before opening it again. For a cloud file, confirm that it has finished syncing and that you are signed in to the intended account. If several versions exist, compare their modification times and open copies rather than overwriting the only version that might contain useful data.

Find out whether the problem is Excel or one workbook

A simple comparison helps narrow the cause. Open Excel without opening the affected workbook, then create a blank workbook. If the blank workbook works normally but one file repeatedly freezes Excel, focus on that workbook: its size, formulas, external links, data connections, macros, or file integrity may be involved. If even a blank workbook freezes, investigate Excel, add-ins, the computer, or Office instead.

On Windows, Safe Mode can help test whether startup settings or add-ins are involved. Close Excel, press Windows key+R, type excel /safe, and press Enter. If Excel behaves better in Safe Mode, that is a useful clue, not proof of a particular cause. Safe Mode does not repair a workbook, and it may not load features you normally use.

To test COM add-ins in regular Excel, choose File > Options > Add-ins. At the bottom, set Manage to COM Add-ins and select Go. Note which items are enabled, clear the check boxes, and restart Excel. If the freeze stops, re-enable add-ins one at a time, restarting between tests, to identify a possible conflict. You can return to the same dialog to turn needed add-ins back on. Excel for Mac has different add-in controls, so these Windows instructions do not apply directly.

Check calculation load and workbook features

Calculation can make a workbook appear frozen, especially after changing a cell that affects many formulas. Volatile formulas, extensive conditional formatting, whole-column references in large models, external links, and data connections can add work. A refresh or macro may also be running. If the status changes or the computer remains busy, interrupting Excel can lose progress or leave work incomplete.

If you can access the workbook after it responds, save a copy before testing changes. On Windows, you can inspect formulas and calculation settings through the Formulas tab and Formulas > Calculation Options. Switching calculation to Manual can reduce repeated recalculation in some large workbooks, but it also means formula results may be out of date until you calculate again. Do not leave a shared or decision-critical workbook in Manual mode without making that status clear to other users. On Mac, the Formulas tab also provides calculation options, though layouts can vary by release.

For a file that freezes during opening, try opening a copy rather than repeatedly opening the original. If you suspect damage, Excel for Windows provides File > Open > Browse; select the file, choose the arrow beside Open, and select Open and Repair. This option may recover some workbook content, but it is not guaranteed to restore everything. Keep the original unchanged, and save any repaired result with a different name.

For a workbook with external links or connections, note whether Excel is waiting for a source file, server, or sign-in. If the workbook eventually opens, check Data > Queries & Connections and the workbook’s links or connection settings as relevant. Do not break links or remove queries blindly: those changes can alter how the workbook is meant to work.

Update or repair Microsoft 365

If Excel freezes across multiple workbooks, install available Office updates. In Excel for Windows, choose File > Account > Update Options > Update Now, if those controls are available for your installation. Managed work or school devices may receive updates through an administrator, and the menu can differ with the organization’s update channel. On Mac, use Help > Check for Updates when Microsoft AutoUpdate is installed, or update Office through the method used for that Mac.

If updates do not help, Windows users can try an Office repair. Open Windows Settings, choose Apps > Installed apps, find Microsoft 365 or Microsoft Office, select the three-dot menu, and choose Modify. If offered, try Quick Repair first; Online Repair is more thorough and may take longer or require an internet connection. Save work and close Office apps before repairing. Menu labels can vary by Windows version and installation type. Mac does not use this Windows repair path; reinstalling Office is a separate step and should follow Microsoft’s current support instructions.

Excel for the web and Mac differences

Excel for the web runs in a browser, so a stalled tab may relate to the browser, an extension, the network, or the workbook as well as Excel. First wait for a save or refresh to finish. If the tab remains stuck, check the connection and browser status before closing it; unsaved edits may be lost. Reopen the workbook from its OneDrive or SharePoint location and check the version history if you need to compare saved versions.

Desktop instructions such as Windows Safe Mode, Task Manager, and the COM Add-ins dialog do not apply to Excel for the web. In a browser, test the workbook in a current browser window without unnecessary extensions if practical, and try another supported browser only as a diagnostic. If the same file also freezes in the desktop app, compare the behavior there and investigate the workbook itself.

On Mac, use Option+Command+Esc to force quit an app that will not recover, and remember that this risks unsaved work. Ribbon names and some repair options differ from Windows. If Excel for Mac repeatedly freezes in multiple files, update Office and macOS through the available update tools, then consult Microsoft support for version-specific troubleshooting rather than applying Windows-only steps.

Reduce the chance of another freeze

Save regularly, and use a clear backup copy before making substantial changes to an important workbook.
Keep Microsoft 365 and the operating system reasonably current, subject to workplace update policies.
Remove or update add-ins you do not need, and investigate a newly installed add-in if freezes begin afterward.
Break very large tasks into smaller steps where practical, and allow lengthy refreshes or calculations to finish before starting more work.
Keep a reliable local or cloud copy of important files, and confirm cloud synchronization has completed before shutting down or switching devices.
Record when the freeze occurs and which workbook, action, or add-in was involved. A repeatable pattern is much more useful for troubleshooting than the message alone.

Frequently Asked Questions

Should I wait or force close Excel? Wait if Excel may be calculating, refreshing data, or opening a large file. If it remains unresponsive and you have checked for a hidden dialog, force closing may be necessary, but it can discard unsaved work. Try recovery options when Excel restarts.

Will I lose my unsaved Excel work? Possibly, but not always. Document Recovery or Recover Unsaved Workbooks may have a recent version. AutoRecover is periodic, and AutoSave depends on a supported cloud file and working synchronization; neither guarantees every last edit.

Why does Excel freeze only with one file? The workbook may be unusually large, contain complex formulas or connections, include macros, or be damaged. Test a blank workbook, preserve a copy, and consider Open and Repair on Windows if the file itself appears to be the issue.

Can I stop Excel from recalculating? If the workbook is responsive, you can choose Formulas > Calculation Options > Manual. This can reduce automatic recalculation but leaves results potentially stale until you calculate. Save a copy first and remember to restore Automatic calculation if appropriate.

Does Not Responding mean the workbook is corrupted? No. It only indicates that Windows is not receiving a timely response from Excel. A temporary calculation, an add-in, a slow connection, or another bottleneck can cause the same status. A repeated freeze limited to one workbook makes file-specific troubleshooting more relevant, but does not prove corruption.

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.