Excel Is Not Responding: How to Save Your Work

If Excel is not responding, wait briefly for it to finish, then try Ctrl+S once on Windows (or Command+S on Mac). If it remains frozen, avoid force-closing it until you have tried the recovery steps below; after Excel restarts, check the Document Recovery pane and Recover Unsaved Workbooks for a recoverable copy.

Why Excel may stop responding

The message does not always mean that Excel has crashed permanently. Excel can temporarily appear frozen while it recalculates formulas, refreshes a query, opens a large workbook, saves to a network location, or processes a complex chart or data model. A workbook with many formulas, volatile calculations, external links, or conditional formatting rules may take longer to respond than a small file.

Give it a moment before taking action. Look for signs of activity, such as a changing status message, a progress bar, or disk activity. On Windows, Task Manager may show that Excel is using CPU or memory, but that alone does not prove it is making progress. If a calculation or refresh has started, repeatedly clicking the window or pressing keys can queue up actions that happen later when Excel becomes responsive.

There is an important difference between a temporary pause and a fully unresponsive process. If the workbook is performing a task, waiting may preserve your work. If Excel has stopped responding entirely, Windows or macOS may eventually offer a way to close it, but ending the process can discard changes that have not been saved.

What to try before closing Excel

Work through these low-risk checks before using Task Manager or Force Quit. They may not recover a completely frozen workbook, but they can help you save without making the situation worse.

Wait a few minutes. Allow time for a large calculation, file transfer, or refresh to finish. Avoid clicking repeatedly while the window is unresponsive.
Try saving once. Press Ctrl+S on Windows or Command+S on Mac. If Excel is still processing, the shortcut may not take effect immediately. Do not keep pressing it.
Try Esc once. If a dialog, cell edit, or operation is blocking the workbook, Esc may cancel that action. It will not reliably stop every calculation or repair a frozen application.
Check for a hidden prompt. Use Alt+Tab on Windows or Command+Tab on Mac to look for a file-format, overwrite, sign-in, or external-link prompt behind another window. Answer only if you understand what the prompt is asking.
Check whether the file is stored online. If the workbook is on OneDrive or SharePoint and AutoSave is on, some recent edits may already have been saved. Do not assume this if the file is local or AutoSave is off.

If Excel becomes responsive, save immediately. If saving to the original location fails, choose File > Save As and save a separate copy to a location you can access, such as your Documents folder. Keep the original file until you have checked that the copy opens and contains the expected sheets and recent changes.

When force-closing is the only option

If Excel stays unresponsive and no prompt or save action works, you may have to close it. 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 in the Force Quit window, and choose Force Quit. These commands terminate the application; they do not create a saved copy of unsaved changes.

Before doing this, consider whether Excel may still be handling an important operation, such as refreshing data or saving to a slow network drive. If it has been inactive for a long time and the operating system reports it is not responding, waiting indefinitely is unlikely to help. After closing it, reopen Excel and let any recovery prompt finish loading before opening the workbook normally. If recovery files appear, save the recovered version under a new name first.

Do not repeatedly end Excel from Task Manager and restart it in quick succession. Give the application time to reopen and display its recovery options. If Windows itself is frozen, forcing a computer restart has broader risks and should be a last resort; unsaved work in other programs may also be lost.

Recover work after restarting Excel

When Excel starts after an unexpected closure, it may display a Document Recovery pane containing one or more versions of the workbook. Open the most recent candidate and inspect it before saving. The pane may show a timestamp or indicate whether the file was recovered automatically. Choose Save As and use a new filename if you need to preserve both the recovered copy and the original.

If no recovery pane appears, try Excel’s built-in unsaved-workbook command. In Excel for Microsoft 365 on Windows, select File > Info > Manage Workbook > Recover Unsaved Workbooks. The available files depend on what Excel managed to create and how the application is configured. Open a candidate, verify its contents, and save it promptly to a normal folder.

Recovery is not guaranteed. AutoRecover keeps temporary recovery information according to its settings and timing; it is not a continuous record of every keystroke. Changes made after the latest recovery snapshot may be missing. A file may also be absent if Excel did not have time to create recovery data, if the feature was disabled, or if temporary files were removed.

AutoRecover, AutoSave, and ordinary saving

These terms describe different protections. Save writes your current workbook to its chosen file. AutoRecover periodically stores recovery information that can help after Excel closes unexpectedly. AutoSave continuously saves changes for supported files stored in OneDrive or SharePoint when the feature is available and switched on. AutoSave is not the same as AutoRecover, and neither replaces a deliberate backup.

On Windows, review AutoRecover in File > Options > Save. There you can check whether Save AutoRecover information is enabled, how often recovery information is saved, and whether the option to keep the last AutoRecovered version when closing without saving is selected. Exact labels can vary slightly by update. A shorter interval can reduce the amount of work at risk, but it does not guarantee recovery of every edit or protect against every storage failure.

For AutoSave, check the switch near the top-left of the Excel window and confirm that the workbook is saved to OneDrive or SharePoint. A local file generally does not receive the same cloud AutoSave behavior. On Mac, the available AutoRecover settings are in Excel’s Save preferences or settings, depending on the version; AutoSave availability likewise depends on the file being stored in a supported cloud location. Excel for the web generally saves supported changes automatically while connected, but connectivity problems can interrupt syncing.

Cloud storage can provide another recovery route through version history. For a OneDrive or SharePoint workbook, use the file’s version history to inspect or restore an earlier version if recent edits were overwritten or damaged. Before restoring, consider downloading or duplicating the current file so you do not replace changes you still need.

How to reduce the chance of losing work

A few habits make an interruption less costly, especially when a workbook contains hours of manual work or a complicated analysis.

Save at milestones. Press Ctrl+S or Command+S after substantial edits, before refreshing data, and before closing a workbook. Use Save As for a separate checkpoint before major restructuring.
Use a cloud location when appropriate. OneDrive or SharePoint can enable AutoSave and version history, provided the file is syncing correctly. Confirm the cloud status rather than assuming a recent edit has uploaded.
Keep a backup for important files. A second copy in a separate folder or approved backup service protects against accidental deletion and file damage. Avoid making multiple copies with unclear names that could later be mistaken for the current version.
Keep AutoRecover enabled. Check the interval and the option to retain the last recovered version. Recovery files are a safety net, not a substitute for saving.
Save before risky operations. Before changing a large formula range, refreshing a query, or running a macro, create a copy. A macro can make changes that are difficult to reverse, and saving beforehand gives you a fallback.

When a workbook repeatedly freezes

If the problem returns with one workbook, the file itself or an operation within it may be responsible. Make a copy before troubleshooting. If the copy opens, try identifying whether a particular sheet, external data connection, add-in, or recent change triggers the pause. A large calculation can take time, but persistent freezes may also result from a damaged workbook, insufficient available memory, or a network or cloud-sync issue.

On Windows, you can test whether an Excel add-in is involved by starting Excel in Safe Mode: close Excel, press Windows+R, enter excel /safe, and press Enter. Safe Mode starts Excel without loading certain add-ins and customizations. If the workbook behaves differently there, review active add-ins through File > Options > Add-ins, but disable them cautiously and re-enable them one at a time to identify a cause. Safe Mode is a diagnostic step, not a repair for a damaged workbook.

If the issue happens with many workbooks, check whether Excel or Windows needs updates, whether the file is being opened from a slow or disconnected location, and whether available memory is low. For a workbook that freezes during data refresh, try opening a saved copy without refreshing immediately, then investigate its connections. Avoid deleting temporary or recovery files as a troubleshooting shortcut; they may be the only remaining recovery material.

Frequently Asked Questions

Can I save an Excel file if the program is completely frozen?
If Excel cannot process input, you cannot reliably force it to save from the frozen window. Wait, try Ctrl+S once, and check for a hidden prompt. If you must close Excel, look for Document Recovery and Recover Unsaved Workbooks after reopening.

Where does Excel save AutoRecover files?
The location can depend on Excel’s settings and installation, so use File > Info > Manage Workbook > Recover Unsaved Workbooks rather than relying on a guessed folder. The command only lists recovery files Excel still has available.

Does AutoSave mean I will not lose anything?
No. AutoSave helps save supported cloud-hosted workbooks, but syncing can be interrupted and version timing matters. Check the AutoSave switch and cloud status, and use version history or a separate backup when you need another recovery option.

Will Excel recover changes I made since the last save?
Possibly, if AutoRecover or cloud saving captured them before the interruption. Excel may recover only a recent snapshot, not every change. Review the recovered workbook carefully before treating it as complete.

What should I do if the recovered workbook is missing sheets or edits?
Keep the recovered file and the original, then check other entries in Document Recovery, Recover Unsaved Workbooks, and cloud version history if applicable. Do not overwrite the only copy while investigating. Some changes may not be recoverable if no copy or recovery snapshot was created.

Is it safe to keep clicking while Excel says Not Responding?
It is better to stop clicking and wait. Excel may process queued clicks after it resumes, potentially opening dialogs or changing the selection unexpectedly. Try one save shortcut, then allow time for the application to respond.

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.