Excel Not Responding? Fix It Without Losing Your Save

If Excel says “Not Responding,” don’t force-quit it straight away: wait briefly, avoid clicking repeatedly, and try saving with Ctrl+S if the window becomes responsive. If Excel has truly stopped, reopen it only after giving it time to recover; Microsoft 365 may show a Document Recovery pane or offer an AutoRecover copy, but neither feature guarantees that every unsaved change can be restored.

Why Excel freezes—and why waiting can help

“Not Responding” usually means Windows is not receiving a timely response from Excel’s window, not necessarily that the workbook is permanently lost. Excel may be busy recalculating formulas, refreshing a query, opening a large file, loading an add-in, or waiting on a network drive. A workbook with many formulas, large data ranges, linked files, or complex formatting can take noticeably longer to finish an operation.

Look for signs that work is continuing. The status bar may show a calculation or refresh, the mouse pointer may change, or Excel may become responsive again after a pause. A fan running or high CPU use can also suggest the computer is busy, though neither proves that Excel will recover. If the file is on OneDrive or SharePoint, a sync delay or connection problem may add time.

There is no safe universal number of seconds to wait. A small workbook that normally opens quickly may warrant concern after a long freeze; a large workbook doing a substantial refresh may need several minutes. Repeatedly clicking the sheet, pressing keys, or opening more Excel windows can queue up actions and make it harder to tell whether the program is recovering.

What to try before closing Excel

Stop interacting for a moment. Give Excel time to complete its current task, especially during opening, saving, calculation, or data refresh.
Try Esc once. If Excel is responsive enough, Esc can cancel some operations, such as an in-progress formula entry or selection. It will not safely cancel every calculation or refresh.
Try Ctrl+Break if a calculation or macro appears stuck. On some keyboards, you may need Fn with the Break key. Excel may offer an option to interrupt the operation. Don’t use this repeatedly if no prompt appears.
Check for a hidden dialog. Use Alt+Tab to see whether a message box is waiting behind the workbook. A dialog can make the main window appear stuck until you answer it.
When Excel responds, save immediately. Press Ctrl+S and wait for the save to finish. If the file is important, use File > Save As to create a separate copy with a new name or in a different folder.

On a Mac, use Command+S rather than Ctrl+S to save. Mac versions of Excel have different menus and interruption behavior; don’t assume a Windows keyboard shortcut will work there. If the workbook contains unsaved edits, avoid force-quitting from the operating system until you have tried the less destructive options.

How AutoSave and AutoRecover protect work

AutoSave and AutoRecover are different safeguards. AutoSave is intended for supported files stored in OneDrive or SharePoint and can save changes as you work when it is turned on and the file is connected. It is not a promise that every keystroke has reached the server instantly. Check the AutoSave switch near the top of Excel and the file’s save or sync status when the program is responsive.

AutoRecover periodically saves recovery information while you work. It can help after Excel closes unexpectedly, but it is not the same as a normal workbook save and may not include the most recent minutes of editing. Its interval and related options are in File > Options > Save. There you can review “Save AutoRecover information every” and “Keep the last autorecovered version if I close without saving.” Available wording or options can vary by Excel build.

AutoRecover does not replace saving the actual workbook. It may be disabled, its recovery copy may be older than your latest changes, or Excel may not have created a usable copy before the freeze. If you regularly work on important files, save with Ctrl+S at meaningful milestones and keep the original in a reliable location.

Recover changes after Excel closes

If Excel has stopped responding for a long time and you have no workable way to save, closing it may be the only option. On Windows, first try closing the Excel window normally. If Windows asks whether to wait or close the program, choose to wait if you still think it may finish. Use Task Manager to end Excel only as a last resort, because unsaved changes since the last successful save can be lost.

After restarting Excel, look for the Document Recovery pane. If it lists more than one version, compare the names and timestamps, open the most recent plausible copy, and save it immediately as a new workbook. Don’t assume the newest-looking entry is complete: inspect important sheets, formulas, and recent edits before replacing your normal file.

If the pane does not appear, try File > Info > Manage Workbook > Recover Unsaved Workbooks. Open a candidate and use Save As to store it under a new name. The recovery list may be empty, and a recovered workbook may not contain all work after the last AutoRecover point. If the original file was stored on OneDrive or SharePoint, check its Version History as well; a previous saved version may restore an earlier state, although restoring it can replace the current version. Save a separate copy before making that choice.

Restart safely and find a recurring cause

Once recovered work is saved, restart Excel and check whether the problem happens with one workbook or every workbook. If only one file freezes, the cause may be its size, formulas, connections, corruption, or a feature within that file. If blank workbooks also freeze, suspect an add-in, Excel startup setting, printer or driver interaction, or a broader Office or Windows issue.

To check whether an add-in or startup customization is involved, close Excel and open the Windows Run dialog with Windows key+R. Enter excel /safe and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the problem disappears there, close Excel and review File > Options > Add-ins. At the bottom, select a relevant add-in type in the Manage list, choose Go, and disable an add-in temporarily. Restart normally and test; re-enable add-ins one at a time if needed. Avoid disabling an add-in your workplace depends on without checking with IT.

For a workbook-specific problem, test a copy rather than experimenting on the only file. If Excel can open it, save a duplicate first. You can also try File > Open > Browse, select the workbook, choose the arrow beside Open, and select Open and Repair. This option may help with a damaged file, but it cannot guarantee recovery, so keep the untouched original and review any repaired copy before relying on it.

Workbook features that commonly cause slowdowns

A freeze is not always a software failure. Some workbook designs require substantial calculation or repeated access to external data. For example, a workbook that refreshes several large queries on opening may look unresponsive while Excel waits for those queries. A formula-heavy file may also pause while recalculating after a large paste or a change to a calculation-driving cell.

Large or inefficient ranges: Formulas and conditional formatting applied to entire columns can make a workbook do more work than intended, especially when repeated across many sheets.
External connections: Links to unavailable files, database queries, or network locations can delay opening or refreshing. If Excel responds, review the workbook’s connections and refresh settings rather than repeatedly restarting.
Macros and add-ins: A macro can take time or wait for user input; an add-in can affect Excel even when the workbook itself is small.
Large data and formatting: Very large sheets, extensive styles, images, and complex charts can increase memory use and make saving or editing slower.

Once the workbook is safe, consider narrowing formula ranges to the data actually used, removing unnecessary formatting, or refreshing external data only when needed. Change one thing at a time and compare behavior. A freeze during a large refresh does not by itself mean the workbook is corrupted.

Prevent the next freeze from costing work

Prevention is more dependable than trying to recover a file after a forced shutdown. Save before a long refresh, macro, or major edit, and save again after it finishes. For an important workbook, use Save As to keep a dated working copy before making risky structural changes. If it is stored in OneDrive or SharePoint, confirm AutoSave is on and that the file has finished syncing before shutting down or disconnecting.

Review the AutoRecover interval in File > Options > Save and make sure recovery is enabled where appropriate.
Keep a separate backup for work that cannot be recreated. A synced folder is useful, but synchronization is not always the same as an independent backup.
Allow large calculations, queries, or saves to finish before closing the lid, shutting down, or disconnecting from a network.
Install Office and Windows updates through your organization’s approved process, particularly if the issue affects multiple files.
Record what was happening when Excel froze: the workbook, operation, data source, and any error message. That pattern can help distinguish a file issue from an Excel-wide issue.

For Mac users, save with Command+S and use the Mac version’s recovery and file menus, which differ from the Windows paths above. The same practical rule applies: preserve the original, let Excel finish if it is still working, and treat recovery copies as possible partial snapshots rather than guaranteed backups.

Frequently Asked Questions

Will I lose my work if I force-quit Excel?
Possibly. Changes since the last successful save may be lost. AutoRecover, Document Recovery, or cloud Version History might provide a usable copy, but none is guaranteed to contain every recent edit.

How long should I wait when Excel says Not Responding?
It depends on what Excel is doing and how large the workbook is. Wait longer during a calculation, refresh, or save, and avoid repeated clicks. If it remains frozen and there is no sign of progress, consider closing it only after trying the safe steps above.

Where are unsaved Excel files recovered?
After a crash, check the Document Recovery pane when Excel restarts. You can also look under File > Info > Manage Workbook > Recover Unsaved Workbooks. The location may have no usable file if recovery was unavailable or no snapshot had been created.

Does AutoSave mean I can close a frozen workbook safely?
No. AutoSave helps save supported cloud-stored workbooks, but a freeze or connection interruption can prevent a recent edit from syncing. Check the save status when Excel responds, and don’t treat AutoSave as a substitute for a backup.

Why does Excel freeze only with one workbook?
That file may contain heavy formulas, large data, external connections, extensive formatting, a macro, or damaged workbook content. Save a copy first, then test whether Open and Repair or a change to the workbook’s connections or calculations helps.

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.