If Excel is frozen, wait briefly, try Esc or Alt+F4, and save if the app responds; if it stays unresponsive, use Task Manager to end it. Reopen Excel afterward and check for recovered files. Force-quitting may lose unsaved changes, so use it only after simpler attempts fail.
What You’ll Need
- A Windows computer running Excel for Microsoft 365, and access to its keyboard or Task Manager.
- A moment to let Excel finish a calculation, refresh, or large file operation before deciding it has stopped responding.
- If you use a Mac or Excel for the web, use the alternative instructions below where noted; the Windows Task Manager steps do not apply to those versions.
Step-by-Step
- Pause and check whether Excel is still working. Stop clicking and typing for 30 seconds to a few minutes, especially if the workbook is large or Excel was calculating formulas, opening a file, refreshing data, or saving. Watch for a progress indicator or a message such as Calculating. A busy workbook may look frozen while completing a demanding task. Repeated clicks can queue up actions, trigger extra windows, or make it harder to tell when Excel responds. If Excel begins responding again, save your work before doing anything else.
- Try to cancel the current action. Click once inside the Excel window, then press Esc. This can stop some operations, such as a calculation or a menu action, but it cannot cancel every task. If a dialog box is open but hidden behind another window, use Alt+Tab to look for it and respond to it. Avoid pressing keys repeatedly: Excel may process them all at once when it catches up.
- Try saving only if Excel responds. Press Ctrl+S once and give it time. If the save finishes, close Excel using the X in the corner or Alt+F4. If a prompt asks whether to save, choose Save only if you want to keep the changes and the workbook is behaving normally. If the window remains marked Not Responding, do not keep sending save commands; a forced quit may be necessary, and unsaved work may not be recoverable.
- Close the window normally if possible. Click the Excel window to make it active, then press Alt+F4, or select the X in the upper-right corner. If Excel asks you to save, choose Save to keep recent edits or Don’t Save to discard them. If you are unsure, avoid choosing Don’t Save. A confirmation dialog can look like another freeze, so wait a few seconds and check whether the prompt is waiting for a choice.
- Open Task Manager if Excel will not close. Press Ctrl+Shift+Esc. In Windows 11, if Task Manager opens in its compact view, select More details. Find Microsoft Excel in the Processes list, select it, then choose End task. The app and any open workbook windows will close. This does not save unsaved edits, so use it only when Excel will not respond to the normal close attempts.
- End Excel using the Details tab if it is not listed clearly. In Task Manager, select the Details tab and look for EXCEL.EXE. Select the matching process and choose End task. Be careful not to end unrelated applications or processes. If several Excel entries appear, ending the one associated with the frozen session may be enough; if the frozen window remains, check whether another Excel process is still running before ending it too.
- Reopen Excel and look for recovery options. Start Excel from the Start menu. If a Document Recovery pane appears, review the recovered versions and open the most recent one that contains your changes. Save it with Ctrl+S, preferably under a recognizable name. If no recovery pane appears, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Available files depend on whether AutoRecover or other recovery features had saved a copy; recovery is not guaranteed.
- Check the recovered workbook before replacing anything. Confirm that important sheets, formulas, and recent entries are present. If the recovered version is incomplete, keep it as a separate file while you compare it with the original. Do not overwrite the original until you have checked which copy contains the work you need. For a workbook stored on OneDrive or SharePoint, also check its version history if you have access; it may provide an earlier saved copy, but it cannot restore every unsaved change.
Mac: Wait, try Esc, and save with Command+S if Excel responds. To close normally, use Command+Q. If Excel is unresponsive, press Option+Command+Esc, select Microsoft Excel in Force Quit Applications, and choose Force Quit. Reopen Excel and look for recovery prompts. These steps are different from the Windows Task Manager instructions.
Excel for the web: If only the workbook tab is stuck, wait, then try reloading the browser tab once you are confident changes have synced. Unsynced edits may be lost. If the whole browser is unresponsive, use Windows Task Manager to close the browser, not a Microsoft Excel desktop process. Reopen the browser and check the workbook’s saved state in OneDrive or SharePoint.
Common Mistakes
- Ending the task immediately. A workbook can take time to calculate, load, or save. Give it a reasonable pause and try a normal close first. If the app is still unresponsive after several minutes and there is no sign of progress, end the task rather than waiting indefinitely.
- Assuming force-quit saves changes. End task closes the process without the usual save confirmation. Unsaved work can disappear. After reopening, check recovery options instead of assuming the last version is complete.
- Clicking repeatedly or launching Excel several times. Multiple clicks and repeated launches can create confusing prompts or extra windows. Click once, wait, and check Task Manager before starting another instance.
- Choosing Don’t Save without checking. That choice discards unsaved edits if Excel is responding normally. If a prompt appears, read it carefully and choose Save when you want to retain the changes.
- Ending the wrong process. Task Manager lists many programs. Select Microsoft Excel or EXCEL.EXE, not a process that merely looks unfamiliar. If you are unsure, close Task Manager without ending anything and ask for help.
Tips
- Save early and often. Use Ctrl+S during normal work. For files stored in OneDrive or SharePoint, AutoSave may be available; check its status near the top of the Excel window rather than assuming every edit has synced.
- Allow extra time for large operations. Refreshing external data, opening a large workbook, running complex formulas, or working with many charts can take longer than expected. Keep the computer powered and avoid shutting it down while Excel may be saving.
- Make a separate copy of important workbooks. Use File > Save As to create a backup before major edits or changes to a complex file. A backup can be more dependable than trying to recover edits after a crash.
- Note what was happening before the freeze. Record the workbook, action, and any error message. If the same action repeatedly causes Excel to stop responding, that detail can help identify a damaged file, add-in, or data source.
- Keep recovery settings in mind. In Excel for Microsoft 365 on Windows, review File > Options > Save for the AutoRecover settings. AutoRecover can help after a crash, but its interval and availability mean it may not contain your newest edits.
Troubleshooting
Task Manager opens, but Excel is missing. The process may already have closed, or the list may need a moment to update. Check the Processes tab and then Details for EXCEL.EXE. If neither shows Excel, reopen the app from the Start menu and look for a recovery pane. If the desktop itself is unresponsive, try Ctrl+Alt+Delete and select Task Manager from the screen that appears.
End task does not close Excel. Wait several seconds, refresh your view of Task Manager, and check Details for EXCEL.EXE again. If it remains, you can select that process and choose End task. If Windows itself is not responding, use Ctrl+Alt+Delete first. Restarting the computer is a last resort because it can interrupt other programs and does not protect unsaved Excel work.
Excel opens but freezes again. Restart Windows and try opening Excel without immediately opening the same workbook. If Excel itself works, the workbook may be unusually large, damaged, or dependent on a data connection or add-in. Try opening a recent backup. You can also test Excel in Safe Mode on Windows: press Windows+R, enter excel /safe, and press Enter. If the problem does not occur in Safe Mode, an add-in or startup setting may be involved. Disable add-ins one at a time through File > Options > Add-ins, using the relevant Manage list and Go button, then restart Excel to test.
There is no recovered version. Check File > Info > Manage Workbook > Recover Unsaved Workbooks. For a cloud-stored workbook, look for Version History from the file in OneDrive or SharePoint. Also check whether another saved copy exists in the folder where you normally store the workbook. These options can recover saved or AutoRecovered versions, but they cannot promise to restore edits that were never saved or captured.
The browser version is stuck instead. Confirm whether other browser tabs respond. If they do, close or reload only the Excel tab after considering unsynced edits. If the whole browser is frozen, end the browser task and reopen it. Check the cloud workbook’s last saved state before continuing. Do not follow desktop Excel’s EXCEL.EXE instructions for a workbook that is only open in a browser.
Frequently Asked Questions
Will I lose my work if I end Excel in Task Manager?
Possibly. Ending the task bypasses Excel’s normal save prompt, so edits since the last save may be lost. After reopening, check Document Recovery and Recover Unsaved Workbooks, but do not assume either contains every change.
How long should I wait before force-quitting?
There is no universal wait time. Give Excel at least a short pause, and wait longer for a large file, calculation, refresh, or save. If there is no sign of progress after several minutes and the window remains unresponsive, try closing it through Task Manager.
Can I close a frozen workbook without closing all of Excel?
If Excel responds, close just the workbook window with its X or use Ctrl+W, then save if prompted. If the entire Excel process is unresponsive, Task Manager may close all workbooks in that process, not only the one that appears frozen.
What should I do if Excel freezes every time I open one file?
Try opening Excel first and then opening a backup copy, if available. Note whether the file uses external data, macros, or add-ins. Test Excel in Safe Mode to see whether an add-in or startup item may be contributing, and avoid overwriting the only copy while troubleshooting.
Is force quitting Excel on a Mac the same as using Task Manager?
No. On a Mac, press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. Task Manager and the EXCEL.EXE process are Windows instructions.
Does AutoRecover always bring back my latest changes?
No. It can provide a recovery copy, but it may be older than your last edit or unavailable. Check the recovered file carefully and save a good copy under a new name before continuing.
Related
- How to Change a Link Name in Excel
- How to Change Every Other Row Color in Excel Automatically
- Indian Number Format in Excel: Apply Lakhs and Crores
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Document Not Saved in Excel: Causes and FixesIf Excel says “Document not saved,” first protect your changes: use File > Save As > Browse to…
- How to Delete Leading Zeros in Excel Without Losing DataTo delete leading zeros in Excel, first check whether they are part of a text value or only…
- Where Is the Flash Fill Button in Excel? Find It FastIn Excel for Microsoft 365 on Windows, Flash Fill is on the Data tab, in the Data Tools…
- Google Sheets: Count Cells That Contain Text with COUNTIFTo count cells that contain text in Google Sheets, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. The asterisk…
- Add a Print Area in Excel: Setup, Options, and FixesTo add a print area in Excel for Microsoft 365 on Windows, select the cells you want to…
- Google Sheets Freeze Rows Greyed Out? Causes and FixesIf Freeze rows is greyed out in Google Sheets, first make sure you can edit the spreadsheet and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.