If Excel says Not Responding, give it a little time before closing it: the program may be busy calculating or loading data, and a forced shutdown can discard unsaved changes. If it becomes responsive, press Ctrl+S on Windows (Command+S on Mac) and save; if it does not, check for a cloud-saved copy or use Excel’s recovery options after restarting.
What to do first when Excel freezes
First, pause and look for signs of activity. A workbook with complex formulas, a large data import, or many sheets can take time to finish a task. On Windows, the title bar may show Not Responding while Excel is occupied; that label alone does not prove the workbook is permanently stuck. Avoid clicking repeatedly or opening more copies of the file, since queued commands can run later and make it harder to tell what Excel is doing.
- Wait several minutes, especially if the workbook is large or Excel was recently refreshing data, calculating formulas, or saving.
- Check whether a progress indicator is moving or whether Excel returns to normal. If it does, press Ctrl+S and wait for the save to finish.
- If Excel is still accepting keyboard input, press Esc once to try to cancel the current operation, then wait. Esc will not cancel every kind of task, and it cannot recover changes already lost.
- If the workbook is stored in OneDrive or SharePoint, check its status in the title bar and allow time for syncing. Do not assume that a visible file is fully uploaded.
If Ctrl+S does nothing, do not keep repeating it. A frozen application may not process the shortcut, and pressing keys cannot force a successful save while Excel is not responding. Give it a reasonable chance to recover before considering a forced close.
Decide whether to wait or close Excel
There is no universal waiting time that guarantees Excel will recover. The right choice depends on what it was doing and how valuable the unsaved work is. A brief pause during a calculation is different from an application that has shown no change for a long time after a routine edit. If the workbook is important, waiting longer is often safer than immediately ending the process.
On Windows, you can open Task Manager with Ctrl+Shift+Esc and check whether Excel is listed as not responding. This can help confirm that the application is stalled, but it does not save the workbook or reveal whether recovery data exists. Avoid choosing End task until you have decided that waiting is unlikely to help. Ending the task closes Excel without a normal save prompt, so edits since the last successful save may be lost.
On a Mac, use Option+Command+Esc to open the Force Quit window if Excel cannot be used. Force Quit is similarly a last resort. If Excel becomes responsive before you close it, use Save As to create a separate copy in a location you can find, rather than immediately overwriting the original. That protects the recovered state while leaving the earlier file intact.
Recover a workbook after Excel closes
When Excel restarts after an unexpected close, it may display the Document Recovery pane. Open the most recent recovered version and compare its timestamp and contents with the file you last saved. Recovery entries can represent different points in time, so do not assume the top item contains every recent edit. Save the version you need under a new name before doing further work.
If the pane does not appear, Excel for Microsoft 365 on Windows provides another place to look: choose File > Info > Manage Workbook > Recover Unsaved Workbooks. Open a likely candidate and immediately use Save As to store it as a regular workbook. The exact files available depend on whether AutoRecover had time to create a recovery copy and on the application’s settings. This option is not a promise that every unsaved workbook can be restored.
AutoRecover is designed to preserve recovery information periodically, not to save every keystroke. If Excel freezes between recovery intervals, the newest available version may be older than your last changes. It also cannot restore a file that was never successfully opened or recover edits that were never captured in a recovery copy. After opening a recovered file, check key sheets, recent entries, formulas, and any data refreshed shortly before the freeze.
How AutoSave and AutoRecover differ
AutoSave and AutoRecover sound similar but serve different purposes. AutoSave, when available and switched on for a workbook stored in OneDrive or SharePoint, saves changes to the cloud as you work. It is useful for reducing the gap between edits and saves, though a freeze, network interruption, or sync delay can still affect what has reached the cloud. Check the AutoSave control and the file’s sync status rather than assuming it was active.
AutoRecover periodically records information intended to help restore work after a crash or other unexpected closure. It is a fallback, not a substitute for saving. In Excel for Microsoft 365 on Windows, review its settings at File > Options > Save. The options include saving AutoRecover information at intervals and keeping the last autosaved version if you close without saving. The wording and availability can vary by platform or installation.
For a workbook in OneDrive or SharePoint, version history may offer another recovery route. In Excel, look under File > Info for Version History, or open the file in its cloud location and check the available version-history command there. Review the date and contents before restoring an older version: restoring can replace the current state. When possible, open or download a prior version as a separate copy first.
Save or salvage the recovered file safely
Once a workbook opens, preserve what you have before troubleshooting. Use File > Save As and choose a new filename, such as Sales-recovered-2026-11-03.xlsx, and a local folder you can access. If the original is cloud-based, you can save a separate copy locally first and then confirm that a cloud copy syncs successfully. Keep the original until you have checked that the recovered workbook contains the needed data.
If Excel opens the workbook but normal saving fails, try saving a copy to a different folder or drive, provided the destination has enough free space and you have permission to write there. A network drive, removable device, or cloud sync folder can be unavailable even when Excel itself is working. If the workbook is damaged, use File > Open > Browse, select the file, choose the arrow beside Open, and select Open and Repair. This may repair some file problems, but it is not a guaranteed way to recover unsaved edits.
For a workbook with important formulas, links, or macros, check that the recovered file kept its original format. Saving a macro-enabled workbook as .xlsx removes its VBA macros; retain the .xlsm format if those macros matter. If Excel offers a format warning, read it rather than clicking through automatically. Check formulas and linked data after recovery, because a successful open does not prove every part of the workbook is intact.
Why Excel may stop responding
A freeze can come from the workbook, Excel itself, or something outside the program. Common causes include a large calculation, volatile formulas recalculating across many cells, a data connection that is slow or unreachable, a workbook with many objects or formatting rules, limited available memory, or an add-in that is not behaving correctly. A large file does not always mean a damaged file; it may simply take longer to process.
Consider what happened immediately before the freeze. If it followed Refresh All, a connection or external source may be waiting. If it followed a formula change, calculation may be the bottleneck. If a particular workbook freezes while other files open normally, the problem may be specific to that workbook. If Excel freezes with several unrelated files, an add-in, Office installation, or system resource issue becomes more plausible. These clues help narrow the cause, but none alone proves it.
Troubleshoot without risking the only copy
After making a separate copy of any recovered workbook, try troubleshooting in a controlled order. Close unnecessary applications to free system resources, then reopen Excel and test whether the issue repeats with a small, unrelated workbook. If only one file causes trouble, avoid repeatedly opening and saving the sole original while investigating.
- Start Excel in Safe Mode on Windows by pressing Windows+R, entering
excel /safe, and pressing Enter. If the problem disappears in Safe Mode, an add-in or customization may be involved. - Review add-ins at File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go. Disable one suspected add-in at a time, restart Excel normally, and test again. Do not remove add-ins you depend on without checking with your organization or the add-in provider.
- Check for Office and Windows updates through the update tools available on your device. On a managed work computer, follow your organization’s update process.
- If the issue continues across files, use Microsoft 365’s available Office repair options in Windows settings or contact your IT support team. Repair names and paths can differ by Windows version.
Safe Mode and add-in changes are Windows-specific instructions. Mac users should use Excel’s available settings and add-in controls for their version; the Windows Run command does not apply. For Excel for the web, the browser may be the unresponsive part. Avoid refreshing or closing the tab until you have checked whether the workbook is saved or synced, because a reload can discard browser-side changes that have not reached the cloud.
Prevent losing work next time
Use more than one protection method for important spreadsheets. Save with Ctrl+S regularly on Windows or Command+S on Mac, and keep a copy in a location with a reliable backup or version history. If the workbook is eligible, enable AutoSave and verify that it is syncing. Review the AutoRecover interval in Excel’s Save options, but remember that a shorter interval can increase how often recovery data is written and still does not replace a normal save.
For a complex workbook, reduce avoidable work: close unused files, refresh external data deliberately, and avoid making broad changes while Excel is still calculating. Before a major edit or refresh, save a dated copy. For shared workbooks, coordinate changes and check version history if an unexpected change appears. These habits reduce the amount at risk; they cannot prevent every crash or guarantee recovery.
Frequently Asked Questions
Can I save an Excel file if it says Not Responding?
If Excel is genuinely unresponsive, it may not process Save or Ctrl+S. Wait to see whether it recovers; once it does, save immediately. If it must be closed, check Document Recovery, Recover Unsaved Workbooks, and cloud version history afterward.
Will force closing Excel delete my workbook?
Force closing does not normally delete the last successfully saved file, but it can discard changes made after that save. A recovery copy may exist if AutoRecover captured one, but recovery is not guaranteed. Avoid force closing until you have given Excel time to respond.
Where are unsaved Excel files recovered?
After restarting, check the Document Recovery pane. In Excel for Microsoft 365 on Windows, also check File > Info > Manage Workbook > Recover Unsaved Workbooks. Available copies depend on AutoRecover and the timing of the failure.
Does AutoSave work on every Excel file?
No. AutoSave is generally associated with supported workbooks stored in OneDrive or SharePoint, and it must be available and enabled. A workbook saved only on a local drive may rely on manual saving and AutoRecover instead. Check the AutoSave switch and sync status.
Can I recover changes after clicking Don’t Save?
Possibly, but not always. Check Recover Unsaved Workbooks and any cloud version history. If no recovery or earlier cloud version contains the edits, Excel may not have a copy from which to restore them.
Related
- How to Add Custom Transitions to PowerPoint
- How to Add Bullet Transitions to PowerPoint Slides
- Inventory Management Spreadsheet Template: Setup and Use
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Replace Words in Excel: Find and Replace GuideTo replace a word in Excel, press Ctrl+H on Windows, enter the existing word in Find what and…
- Jotform to Google Sheets: Setup, Syncing, and FixesTo send Jotform responses to Google Sheets, open the form in Jotform, go to Settings > Integrations, search…
- Excel Shortcut to Go to the Bottom of a Data ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the bottom edge of the…
- Access vs Excel: Pros, Cons, and Best Uses ComparedMicrosoft Access is usually the better choice for managing related records, enforcing consistent data entry, and supporting a…
- PowerPoint Audio Controls: Add and Customize PlaybackTo add audio controls to a PowerPoint slide, insert an audio file with Insert > Audio, select the…
- Google Sheets IFERROR: Show a Blank Instead of ErrorsYes. In Google Sheets, wrap a formula in IFERROR and use an empty string as its fallback: =IFERROR(your_formula,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.