Excel Not Responding: How to Save Your Work Safely

If Excel says Not Responding, first stop clicking and give it time to finish; if the window still accepts input, press Ctrl+S on Windows to save. If it is completely frozen, you may not be able to save immediately: wait before force-quitting, then use Excel’s Document Recovery or unsaved-workbook recovery options when you reopen it.

What Not Responding means

Not Responding is a Windows status indicating that Excel is not currently processing messages from the desktop. It does not always mean the workbook has crashed. Excel may be calculating formulas, refreshing data, opening a large file, communicating with a network location, or waiting for an add-in or another resource. During that work, the window can stop repainting and ignore clicks even though Excel may eventually recover.

There is no reliable universal wait time: a large calculation or data refresh can take longer than a simple edit. Look for signs of activity, such as a changing status-bar message, a progress indicator, or disk activity. If the file is especially large or stored on a slow network, allow more time before taking action. Repeatedly clicking, typing, or opening additional copies can make it harder to tell what is happening and may add work to a busy application.

Try these steps before closing Excel

Wait and avoid repeated input. Give Excel a chance to finish its current operation. If a calculation or refresh is in progress, interrupting it may not help.
Try a save only if Excel responds. Press Ctrl+S. If the Save dialog appears, choose a location and a recognizable filename. Do not keep pressing keys if nothing responds.
Try Esc once if an operation may be cancellable. For example, Excel may be waiting on a dialog or calculation. Esc can cancel some operations, but it does not recover unsaved changes and will not fix every freeze.
Check for a hidden dialog. A prompt may be behind the workbook or another window. Use Alt+Tab to cycle through open windows and look for a message asking you to confirm an action.
Do not restart Windows as a first response. Restarting can end Excel without giving it another chance to save or recover data.

If Excel becomes responsive again, save a separate copy before troubleshooting further. In Excel for Microsoft 365 on Windows, use File > Save As and choose a different filename or folder. A copy protects the current state while you investigate why the original workbook stalled.

If Excel is frozen completely

If the title bar remains Not Responding and Excel ignores keyboard input for an extended period, saving directly may no longer be possible. Before ending the process, note the workbook’s name and where it was stored, and consider whether a calculation, import, or refresh might still be running. If the workbook is in OneDrive or SharePoint, another device or the web version may show a previously saved copy, but do not assume it contains the latest unsaved desktop edits.

On Windows, open Task Manager with Ctrl+Shift+Esc. Find Microsoft Excel in the list, select it, and choose End task only when you have decided to stop waiting. This closes Excel and can discard changes that were not saved or captured by recovery. If Task Manager shows several Excel processes, avoid ending unrelated applications. After closing Excel, reopen it from the Start menu and look for the Document Recovery pane.

On a Mac, the equivalent force-quit command is Option+Command+Esc; select Microsoft Excel and choose Force Quit. Mac menu names and recovery settings can differ from Windows. If Excel is still active enough to use its menus, try saving before force-quitting. On Excel for the web, the browser may show a page that is not responding; wait first, then try reloading only after considering whether the latest edits have synced.

Recover changes after reopening

After an unexpected closure, Excel for Windows may show a Document Recovery pane with one or more recovered versions. Open the version with the most recent time, compare it with what you remember changing, and use File > Save As to save a copy under a new name. A recovered file is not a guarantee that every last edit survived; AutoRecover captures work periodically, so changes made after its last recovery point may be missing.

If the pane does not appear, check for an unsaved workbook through File > Info > Manage Workbook > Recover Unsaved Workbooks. The exact available entries depend on whether Excel created a recovery copy and on the app’s version and settings. Open a candidate and save it promptly to a normal folder. Do not overwrite the original until you have checked which file contains the edits you need.

For a workbook saved to OneDrive or SharePoint, check its version history if the file was saved or synced there. In Excel, the version-history command is available from the workbook name or through File > Info > Version History, depending on the interface. Earlier saved versions can help restore a state, but version history is not the same thing as recovering every unsaved keystroke. Make a copy before restoring or replacing a file if you need to preserve the current version too.

Understand AutoSave and AutoRecover

AutoSave and AutoRecover are related but different. AutoSave continuously saves changes for eligible files stored in OneDrive or SharePoint when the AutoSave switch is on. It is not a promise that every edit has reached the cloud at the instant Excel freezes; syncing can be delayed by connectivity or other issues. A workbook saved only on the computer generally does not get the same continuous AutoSave behavior.

AutoRecover periodically saves recovery information so Excel can offer a version after an unexpected closure. It is a safety net, not a replacement for saving normally, and its interval means the latest edits can be absent. On Windows, review its settings in File > Options > Save. The page includes the AutoRecover interval and options for retaining the last AutoRecovered version if you close without saving. Setting a shorter interval may create recovery points more often, but it cannot prevent every loss or fix a workbook that is already damaged.

For important work, use Ctrl+S after meaningful changes even when AutoSave is on. If a file is stored locally, save it to a dependable location and consider a separate backup. If it is in a cloud folder, check that the status indicates synchronization has completed before shutting down or disconnecting from the network.

Why a workbook may stop responding

Finding the cause helps prevent another interruption. Common triggers include heavy formulas recalculating across many rows, large pivot tables, external data connections, add-ins, and workbooks with extensive formatting or embedded objects. A slow network or cloud connection can also make an otherwise normal save appear stuck. A freeze that happens every time you open one particular workbook may point to that file or one of its contents; a freeze across unrelated workbooks suggests looking at Excel, an add-in, or the computer.

Once you have saved or recovered a safe copy, try opening Excel in Safe Mode on Windows by holding Ctrl while starting Excel and confirming the prompt. Safe Mode can help identify whether an add-in or startup customization is involved; it is a diagnostic step, not a repair for damaged data. If Excel behaves normally there, review enabled add-ins through File > Options > Add-ins. Change one item at a time and reopen normally to see whether the problem returns. Do not remove an add-in your organization requires without checking with its administrator.

If the issue continues, make sure Office and Windows are up to date, and check whether the workbook is stored on a location that is available and writable. For a workbook that repeatedly hangs, test a copy rather than experimenting on the only original. If other files also fail, your organization’s IT support or Microsoft support may be able to help investigate installation, permissions, or device-specific causes.

Habits that reduce the risk of losing work

Save early with Ctrl+S, then repeat after substantial edits or before a long calculation, refresh, or other risky operation.
Use File > Save As to create a clearly named working copy before changing a complex or important workbook.
For collaborative cloud files, confirm AutoSave is on and allow time for synchronization; keep a backup when the work is especially important.
Close unnecessary workbooks and applications if memory or processing capacity is limited, and avoid running several large refreshes at once.
Do not treat AutoRecover as a permanent archive. Keep deliberate backups or use version history where available.

These habits do not guarantee that Excel will never freeze, but they give you more ways to return to a recent saved state. The most useful distinction is whether Excel is temporarily busy or completely unable to accept input: wait and save when it responds, and use recovery tools only after an unavoidable closure.

Frequently Asked Questions

Can I save an Excel file while it says Not Responding? Only if Excel still processes the save command. Wait, then try Ctrl+S once if the application accepts input. If it is fully frozen, you usually cannot force a normal save from that window; recovery may be available after reopening.

Will force-closing Excel delete my work? It can discard edits that were not saved or captured by AutoRecover. Before ending the task, wait if Excel may be busy. After reopening, inspect Document Recovery and save any useful recovered version under a new name.

Where do I find an unsaved Excel file? In Excel for Microsoft 365 on Windows, try File > Info > Manage Workbook > Recover Unsaved Workbooks, and check the Document Recovery pane after an unexpected closure. Excel can only offer files it actually retained, so recovery is not guaranteed.

Does AutoSave save every change immediately? No. AutoSave is designed for eligible OneDrive and SharePoint files, but synchronization can take time or be interrupted. AutoRecover is a separate periodic recovery feature. Use normal saves and verify cloud sync for important work.

Why does Excel keep freezing on one workbook? The workbook may contain resource-intensive calculations, connections, objects, or other content that causes a delay. Save a copy if possible, then test that copy and consider whether an add-in or external connection is involved. If many unrelated files freeze, investigate Excel or the computer as well.

Is Excel for the web different when it stops responding? Yes. It runs in a browser and depends on the browser and network connection. Wait for the page to recover and check whether changes have synced before reloading. Desktop Windows recovery paths such as Task Manager and the Document Recovery pane do not apply in exactly the same way in the browser.

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.