If Excel says Not Responding, give it time before closing it: a large calculation, refresh, or file operation may still finish. If the window responds again, immediately use Ctrl+S on Windows and then save a separate copy; if it remains frozen, avoid ending the task until you have allowed time for recovery options, because unsaved changes may be lost.
What to do first when Excel freezes
Pause for a minute or two and avoid clicking repeatedly, switching windows rapidly, or pressing several save commands. Windows may label Excel Not Responding when it is not processing window messages; that does not prove the workbook has crashed. A large workbook can temporarily occupy Excel while it recalculates formulas, opens a link, refreshes a query, or saves a large set of changes.
Look for signs that the operation is still underway. The mouse pointer may show a busy indicator, the status bar may mention calculation or a refresh, or the computer may remain active. If Excel is responding enough to accept input, press Esc once to try to cancel the current operation. Do not keep pressing it: some calculations and refreshes cannot be interrupted safely or immediately. If the workbook becomes usable, save before investigating the cause.
- Wait rather than clicking the close button repeatedly.
- If the screen is responsive, try Ctrl+S once and wait for the save to finish.
- After saving, use File > Save As to create a second copy, preferably with a different name.
- If the workbook contains macros, preserve it as an Excel Macro-Enabled Workbook (.xlsm); saving as .xlsx removes VBA macros.
On a Mac, the usual save shortcut is Command+S rather than Ctrl+S. The same basic principle applies: allow Excel time to finish, then save a separate copy when the workbook responds.
When Excel starts responding again
Do not assume a brief recovery means the workbook is safely saved. First press Ctrl+S on Windows or Command+S on Mac, and wait for any saving indicator to finish. For a workbook stored in OneDrive or SharePoint, check that Excel reports the file is saved or that syncing has completed. A cloud connection problem can prevent the latest edits from reaching the shared file even when the worksheet looks normal.
Next, make a separate copy using File > Save As. Choose a new filename and a location you can access, such as a local folder, rather than overwriting the only copy. For example, if the original is Quarterly Budget.xlsx, use a name such as Quarterly Budget-recovered.xlsx. If the workbook has macros, retain the .xlsm file type. Do not choose CSV just to make the save easier: CSV stores values from one worksheet and does not preserve workbook features such as formulas, formatting, multiple sheets, or macros.
If the Save As dialog itself hangs, do not launch another copy of Excel and make conflicting edits. Wait for the dialog or Excel to respond. Once it does, save locally first if a network location or cloud service seems to be the source of the delay; you can move or upload the copy afterward.
If the window remains completely frozen
Try to distinguish a slow operation from a deadlock before forcing Excel to close. If the workbook is very large, has many volatile formulas, or is refreshing external data, waiting several minutes may be reasonable. A short pause is not a guarantee of recovery, but ending the process immediately removes the chance that the current operation will finish. If the computer is unresponsive as a whole, that is a broader system problem, not necessarily an Excel-only failure.
If Excel still does not respond after a reasonable wait and no save command can be processed, 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 actions discard changes that exist only in the frozen session. Before proceeding, make sure you can reopen the file and know where it was stored.
When Excel opens again, look for a Document Recovery pane. Open the recovered version with the latest time, compare it with the original, and save it under a new name. Recovery is not a substitute for a normal save: the recovered copy may be older than the last edits, or no recovery copy may be available. If Excel opens with a message about recovered files, do not dismiss the pane until you have inspected the available versions.
How AutoRecover and AutoSave differ
AutoRecover and AutoSave are easy to confuse. AutoRecover periodically stores recovery information that may help restore unsaved work after Excel closes unexpectedly. It does not continuously write every keystroke to the original workbook, and it cannot promise to recover all changes. Its usefulness depends on its settings, the time since the last recovery save, and whether Excel can read the recovery data.
In Excel for Microsoft 365 on Windows, check AutoRecover settings at File > Options > Save. The options include saving AutoRecover information at an interval and keeping the last AutoRecovered version if Excel closes without saving. The exact labels can vary by build. Setting a shorter interval may reduce the amount of work at risk, but it does not replace Ctrl+S or a backup copy.
AutoSave is different: it can save changes continuously for supported files stored in OneDrive or SharePoint, when the feature is available and turned on. Check the AutoSave switch near the top-left of the Excel window and confirm the file’s save status. AutoSave may be unavailable for files in some locations, formats, or configurations. A frozen application, offline connection, or sync conflict can also interrupt updates. Do not infer that a cloud-stored workbook has the latest edits simply because AutoSave is normally enabled.
Where to look for an unsaved workbook
If Excel closed before you could save, reopen Excel and check the Document Recovery pane first. If it is not displayed, Windows Excel may offer unsaved files through File > Info > Manage Workbook > Recover Unsaved Workbooks. Depending on the build, the recovery command may also be accessible from the Open or Recent screen. Open any candidate file and immediately save it with a new name; do not overwrite the original until you have checked which copy contains the latest work.
For a workbook saved in OneDrive or SharePoint, check the file’s version history as well. In Excel, use the workbook name or File information area to locate version history if the option is available, or use the file’s menu in the relevant Microsoft 365 storage service. Version history can help restore an earlier saved version, but it cannot recreate edits that never reached the service. If restoring a version, save or download a separate copy first so the current version is not accidentally replaced.
On Mac, Excel may show recovered workbooks when it reopens after an unexpected quit. The recovery screens and paths differ from Windows and can change between releases, so inspect Excel’s recovery prompts and save any useful file promptly. Excel for the web generally saves supported workbooks to OneDrive or SharePoint, but check the connection and the displayed save status. If the browser itself closes, reopen the workbook from its storage location and check its version history.
Why Excel may stop responding
A frozen window often has a specific trigger. Recalculation is common: changing one input can cause thousands of dependent formulas to update, especially in workbooks with many formulas, large ranges, or functions that recalculate frequently. A workbook may also pause while refreshing Power Query data, updating pivot tables, connecting to external links, loading add-ins, or communicating with a printer or network drive.
File size and available system resources matter too. Images, formatting applied to entire columns, embedded objects, and large data models can increase the memory and processing required. An add-in or an outdated graphics driver may contribute to a recurring freeze. A workbook stored on a slow or temporarily disconnected network share may appear stuck during saving or loading. These possibilities are reasons to diagnose the trigger after safeguarding the file, not reasons to assume that a frozen workbook is safe to terminate.
Once the work is saved, note what happened immediately before the freeze: opening a particular file, refreshing a connection, editing a formula, or printing. If the issue occurs only with one workbook, test a copy rather than experimenting on the original. If Excel freezes with many unrelated files, the cause may be an add-in, Office installation, or system resource issue rather than damaged content in that one workbook.
Reduce the risk of losing work next time
For important work, combine regular manual saves with a recovery plan. Press Ctrl+S frequently on Windows or Command+S on Mac, especially before refreshing data, running a long calculation, or making structural changes. Keep a dated copy before major edits, and store important files in a location with a dependable backup or version history. Cloud syncing is useful, but it is not the same as having a verified independent backup.
- Review AutoRecover settings under File > Options > Save on Windows, and confirm the interval is enabled.
- Use OneDrive or SharePoint AutoSave only when the workbook and location support it; watch for save or sync warnings.
- Keep a separate copy before deleting sheets, changing formulas across a workbook, or running an unfamiliar add-in.
- When a file repeatedly freezes, work on a copy and investigate calculations, links, refreshes, add-ins, and file location one at a time.
For a workbook that is slow to recalculate, switching calculation to manual may help in some cases, but it changes when formulas update and can leave displayed results out of date. Do not make that change simply to force a save unless you understand the consequences. If you use manual calculation, recalculate deliberately before relying on results, and restore the setting as appropriate. Saving a copy is safer than making several troubleshooting changes to the only version.
Frequently Asked Questions
Will Ctrl+S save a workbook if Excel says Not Responding?
It can only save if Excel is able to process the command. Press it once if the window still accepts input, then wait. If Excel’s interface is genuinely blocked, the shortcut may do nothing; repeated presses do not make the save more likely to complete.
How long should I wait before closing Excel?
There is no fixed safe waiting time. Consider the workbook size and whether Excel was calculating, refreshing data, or saving to a network or cloud location. Give a substantial operation time to finish, and force-close only when it remains unresponsive and you accept that unsaved changes may be lost.
Can I recover changes if I never saved the workbook?
Possibly. After reopening Excel, check Document Recovery and, on Windows, File > Info > Manage Workbook > Recover Unsaved Workbooks if that option appears. Recovery depends on AutoRecover data being available, so it may be incomplete or absent.
Does AutoSave mean I cannot lose edits?
No. AutoSave applies only in supported situations, typically with a workbook stored in OneDrive or SharePoint, and a frozen app or connection problem can interrupt syncing. Check the save status and use version history or a separate backup where available.
Should I end Excel in Task Manager?
Only if waiting has not helped and Excel cannot accept a save command. End task closes the process and can discard unsaved changes. Afterward, reopen Excel and inspect recovery files before continuing with the original workbook.
Related
- How to Use Slide Master in PowerPoint for Consistent Slides
- Inventory Control Spreadsheet Template and Setup
- How to Create a PowerPoint Background Template That Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Text Equals: How to Compare Text Values in CellsIn Excel, use the equals sign in a formula to check whether two text values match: with the…
- Freeze Panes in Excel: Keep Rows and Columns VisibleTo freeze panes in Excel for Microsoft 365 on Windows, select the cell just below the rows and…
- Data Validation Checklist for Excel: What to CheckA practical data validation checklist starts by defining what each field may contain, then applying the right Excel…
- Excel Import CSV: Open Comma-Separated Files CorrectlyYes. To import a comma-separated CSV file in Excel for Microsoft 365 on Windows, select Data > Get…
- One Page Landscape in Word: Steps for Windows and MacTo make just one page landscape in Word, isolate it in its own section: insert a Next Page…
- How to Lock a Drop-Down List in ExcelTo protect a drop-down list in Excel, unlock the cells where people should make a selection, then use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.