If Excel says Not Responding, first give it a little time, then try Ctrl+S once and wait; if Excel is still frozen, avoid ending the task until you have checked whether it recovers or whether a cloud copy is already saving. If you must close it, reopen Excel promptly and look for Document Recovery or an AutoRecover copy—these may restore recent work, but they are not guaranteed to contain every last change.
What to do first when Excel freezes
A Not Responding label does not always mean Excel has stopped working permanently. Excel may be busy recalculating formulas, loading a large file, refreshing data, saving to a slow location, or handling an add-in. Windows can show that label while the application is temporarily unable to respond to clicks. Closing it immediately may discard changes that are still in memory.
- Wait briefly. Look for signs of activity, such as a changing progress indicator, disk activity, or a message about calculation. For a large workbook or a slow network connection, waiting several minutes may be reasonable.
- Try saving once. Press Ctrl+S and wait. Repeated clicks or repeated shortcuts can queue more actions rather than make the save happen faster.
- Try Esc if Excel appears to be processing an operation. It can cancel some actions, but it cannot recover a workbook if Excel is fully hung. If a formula calculation is the cause, Ctrl+Break may interrupt it on Windows; some keyboards require Fn with Break, and the shortcut may not work when Excel cannot accept input.
- Check whether AutoSave is on. If the workbook is stored in OneDrive or SharePoint and AutoSave is enabled, recent changes may already be syncing. Do not assume that a local file or a workbook with AutoSave switched off is protected this way.
- Only then consider closing Excel. If Windows offers to wait or close the program, choose wait first if there is a reasonable chance Excel is still working.
If Excel becomes responsive, save the workbook under a new name or to a different location as well as saving the current file. That gives you a fallback copy before you investigate why it froze.
Check whether the workbook has already saved
Before forcing Excel to close, work out where the file is stored. A workbook saved to OneDrive or SharePoint may use AutoSave, which saves changes as you work when the feature is available and switched on. The AutoSave control appears near the top of the Excel window. A cloud icon or a recent modified time in OneDrive can also help indicate sync activity, though a delay or sync error means the latest edits may not have reached the cloud.
AutoSave is different from AutoRecover. AutoSave is intended to update a supported cloud-stored file continuously; AutoRecover keeps recovery information at intervals so Excel may restore work after an unexpected shutdown. Neither feature is a promise that every keystroke is recoverable. A workbook on a USB drive, a network share, or your computer’s local disk may not be using cloud AutoSave at all.
If the workbook is in OneDrive or SharePoint and you can access the file through a browser or another device, check its recent version or open it read-only before changing anything. Version history may provide an earlier saved copy if the current file is damaged or missing changes. Avoid editing the same workbook simultaneously from another session while trying to recover the original; that can create conflicting versions.
Close Excel only when waiting has failed
If Excel remains unresponsive and you have waited, tried a save, and checked for signs of progress, Windows Task Manager can close it. Press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This is a last resort: it terminates the application and can lose changes that were never written to the workbook or a recovery file. If several Excel windows or processes are listed, take care not to end another workbook you still need.
On a Mac, the comparable force-quit route is Apple menu > Force Quit, or press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. The save shortcut is Command+S rather than Ctrl+S. The same limitation applies: force quitting cannot guarantee that unsaved edits will be preserved.
After closing, reopen Excel and look for a Document Recovery pane. If one appears, open the most recent recovered version, compare it with the workbook you last saved, and use Save As to create a separate copy. Do not immediately overwrite the original until you have checked that the recovered file contains the needed work. Recovery entries may differ in content and time, so inspect more than one when available.
Find AutoRecover and unsaved workbook copies
Excel for Microsoft 365 on Windows usually displays recovered workbooks after an unexpected shutdown. If the Document Recovery pane does not appear, open Excel and check File > Info for workbook management or recovery options. In versions that provide it, choose Manage Workbook > Recover Unsaved Workbooks. The wording or availability can vary by Excel build, and this option is not a substitute for a regular saved copy.
AutoRecover settings are at File > Options > Save in Excel for Windows. There you can see whether recovery information is being saved and the interval used. The folder location shown there can help you find recovery files, but do not move, rename, or delete files in that folder while Excel is open. On Mac, Excel preferences and recovery behavior are arranged differently; check Excel’s settings and the recovery prompt after reopening rather than relying on Windows menu paths.
When you find a likely recovery file, open it and immediately use File > Save As to save a normal workbook copy in a known folder. Give it a distinct name, such as Budget-recovered, so it is easy to compare with the original. A file recovered from an autosave interval may be missing the last few minutes of work, and a recovery file may not be usable if the workbook or storage device was damaged.
Recover carefully and protect the original
Recovery is a comparison task, not just a matter of clicking the newest-looking file. Check the worksheet names, the last rows or columns you edited, formulas, charts, and any changes to formatting or data. If the workbook was shared, confirm whether another person saved a newer version. Save the recovered copy separately first, then copy missing work into the correct version only after you understand which file is authoritative.
- Keep the original workbook untouched until you have verified the recovered copy.
- Use a local folder or a trusted cloud location with enough free space, rather than saving over a file that may still be syncing.
- If Excel opens a recovered workbook in Protected View or displays a repair notice, read the prompt and save a separate copy before making further changes.
- If the file is business-critical, preserve the original and ask your organization’s IT support before attempting repair tools or deleting temporary files.
One common misconception is that AutoRecover is an automatic backup of every edit. It is not. It is designed to help after a crash, and its recovery point depends on settings and timing. A clean exit, a crash during a write, a disabled feature, or a damaged disk can all affect what is available.
Why Excel may stop responding
A freeze can come from the workbook, Excel, another program, or the place where the file is stored. A workbook with many formulas, volatile calculations, large pivot tables, external connections, or extensive formatting may take time to recalculate. Refreshing a query or waiting for a network-hosted file can also make the window appear stuck. An add-in or graphics issue is another possibility, particularly if the problem happens with otherwise small workbooks.
Once your work is safe, see whether the issue repeats with just this workbook or with every workbook. If only one file triggers it, make a copy and try opening the copy; avoid experimenting on the only original. If multiple files freeze, restart the computer and install Office updates through File > Account > Update Options > Update Now, where that option is available. If Excel still misbehaves, start it in safe mode on Windows by holding Ctrl while launching Excel and confirming the prompt. Safe mode can help identify an add-in or startup customization problem, but it is a diagnostic step, not a recovery method.
For a file that will not open normally, Excel’s Open and Repair option may help: go to File > Open > Browse, select the workbook, open the arrow beside the Open button, and choose Open and Repair. Use this on a copy where possible. Repair can remove damaged elements, so compare the result carefully and retain the unmodified file.
Reduce the chance of losing work next time
Prevention matters because recovery features are not equivalent to a backup. Save early, then save regularly with Ctrl+S on Windows or Command+S on Mac. For important work, keep a separate versioned copy in a trusted location. If you use OneDrive or SharePoint, confirm AutoSave is on and allow sync to finish before shutting down or disconnecting.
- Review File > Options > Save and make sure AutoRecover information is enabled at an interval that suits your work.
- Use clear file names or dated versions before major changes, especially before replacing formulas, importing data, or running a large refresh.
- Keep Office and Windows current, and remove or update add-ins that cause repeated hangs.
- For very large workbooks, avoid running several resource-intensive refreshes or calculations at once, and allow a save to finish before closing the lid or disconnecting a drive.
Excel for the web saves changes automatically to its cloud file, but a browser tab that stops responding can still interrupt editing or syncing. Wait for the browser and connection to recover, check the file’s status, and reopen the workbook from OneDrive or SharePoint if necessary. The browser version does not use the same Windows Task Manager workflow for closing a desktop Excel process.
Frequently Asked Questions
Can I save an Excel file if it says Not Responding?
Possibly. Wait for Excel to recover, then press Ctrl+S once and give the save time to complete. If Excel cannot accept input, you cannot force it to save through a shortcut; AutoSave or AutoRecover may still provide a copy later.
Will I lose my work if I end Excel in Task Manager?
You may lose changes made since the last successful save. After reopening, check Document Recovery and any available cloud version history, but do not assume either one contains the latest edits.
Where does Excel save AutoRecover files?
On Windows, check File > Options > Save for the AutoRecover settings and location. The location and recovery interface can differ by version and platform; reopen Excel after a crash to see whether it presents a recovery pane.
Does AutoSave mean I do not need to press Ctrl+S?
AutoSave can continuously save supported workbooks stored in OneDrive or SharePoint when enabled. It does not apply to every file or storage location, and syncing can fail or be delayed. Check that AutoSave is on and that the latest changes have synced.
How long should I wait before closing a frozen workbook?
There is no universal wait time. Consider file size, whether a calculation or refresh is underway, and whether the computer shows activity. For important unsaved work, waiting longer is safer than immediately ending Excel, but a permanently hung application may eventually require force closing and recovery.
Related
- Excel: Hide Column Headers Without Hiding Data
- Excel: Hide a Column When a Cell Contains Text
- Excel Heat Mapping: How to Create Useful Color Scales
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Proper Excel Data Entry: Rules, Tips, and Common ErrorsProper Excel data entry means arranging information consistently, keeping one value in each cell, choosing the right data…
- Wrap Text in a Google Sheets Column: A Step-by-Step GuideTo wrap text in a Google Sheets column, select the column by clicking its letter, then choose Format…
- How to Edit a Scheduled Email in OutlookTo edit an Outlook email that is scheduled to send, cancel or reopen its scheduled delivery, change the…
- Excel Row Limit: How Many Rows Can a Worksheet Hold?In Microsoft Excel for Microsoft 365, a worksheet can hold a maximum of 1,048,576 rows. That is the…
- How to Insert an Image Into a Cell in Excel ProperlyIn Excel for Microsoft 365 on Windows, select a cell, then choose Insert > Pictures > Place in…
- Google Sheets Percentage Calculator: Formulas and ExamplesTo use Google Sheets as a percentage calculator, enter the part and the total in cells, then divide…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.