If Excel says “Not Responding,” first stop clicking and give it a few minutes to finish the task; then try Esc and save if the window responds. If it remains frozen, close Excel from Task Manager only as a last resort, reopen it, and check for recovered work. The steps below help you distinguish a temporary slowdown from a persistent problem, recover unsaved changes, and prevent the freeze from returning.
What You’ll Need
- A Windows PC with Excel for Microsoft 365, and access to the same Windows account used to open the workbook.
- A few minutes to wait before ending Excel, especially if the workbook is large or stored online.
- If possible, the workbook’s location, such as its folder, OneDrive, SharePoint, or a network drive. This helps you reopen the right copy and check whether it synced.
You do not need to install a recovery tool. Avoid downloading third-party software that promises to repair or retrieve a workbook before you have checked Excel’s built-in recovery options.
Step-by-Step
-
Wait and check whether Excel is still working. Stop clicking the worksheet, ribbon, and taskbar icon; repeated clicks can queue up and make the window appear even less responsive. Give it two or three minutes. Wait longer if you just opened a large workbook, refreshed data, recalculated formulas, saved to a network location, or ran a macro. If the window says “Not Responding” briefly and then clears, Excel was likely busy rather than permanently frozen.
Look for signs of activity: the mouse pointer may show a busy indicator, the computer’s disk or CPU activity may continue, or a progress message may appear. These clues are not proof that Excel will recover, but they are a reason not to force it closed immediately.
-
Try to cancel the current action. Press Esc once and wait several seconds. This can interrupt some calculations, selections, or operations, but it cannot cancel every task. If Excel responds, press Ctrl+S on Windows to save. If the workbook uses AutoSave, confirm that it is on and that the file is saved to OneDrive or SharePoint; AutoSave is not a substitute for checking that the latest changes have synced.
If you are using a Mac, the equivalent save shortcut is Command+S. Keyboard shortcuts may not work while Excel is fully blocked, so do not keep pressing keys repeatedly.
-
Check whether a dialog box is hidden. Excel can seem frozen when a message, sign-in prompt, link warning, or file-access dialog is waiting behind another window. Press Alt+Tab to cycle through open windows and see whether an Excel prompt is present. On Windows, also check the taskbar for a flashing Excel window. If you find a prompt, read it and choose the appropriate response instead of ending the process.
On a Mac, use Command+Tab to switch apps, then check Excel’s menus and open windows. If Excel is waiting for a dialog, bring it to the front and respond before trying other recovery steps.
-
Close other demanding apps and wait again. If Excel begins responding, save the workbook before doing anything else. If it is still stuck, check whether the computer is low on memory or busy with another program. Close unrelated apps only if they are responding normally and you do not need unsaved work in them. Avoid restarting the computer at this stage: restarting can end Excel just as abruptly as using Task Manager.
If the workbook is stored on a network drive or cloud service, a slow connection can delay loading or saving. Do not disconnect the network or unplug an external drive while Excel may still be writing to it. Wait for activity to settle, and check the service’s sync status if available.
-
End Excel only if it remains unresponsive. On Windows, press Ctrl+Shift+Esc to open Task Manager. Select Microsoft Excel in the Processes list, choose End task, and confirm if prompted. This terminates Excel and can discard changes that were not saved, so use it only after waiting and trying the safer options above. Do not end unrelated processes just because their names are unfamiliar.
On a Mac, press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. Force quitting also risks losing unsaved changes. When the app is completely stuck, there may be no way to save the latest edits before closing it.
-
Reopen Excel and check for recovered work. Start Excel normally. If a Document Recovery pane appears, open the most recent recovered version, compare its time with your last changes, and save it with a new name before replacing or deleting any other copy. If the pane does not appear, check File > Info > Manage Workbook for a recovered or unsaved version. The exact recovery choices can vary by Microsoft 365 update and file type.
For a workbook saved in OneDrive or SharePoint, check the file’s version history as well. Open the file’s menu in OneDrive or SharePoint and look for Version history, or use the version history option available from Excel when it is shown. Compare timestamps before restoring an older version; restoration can replace the current file. Keep the recovered copy until you have confirmed its contents.
-
Open Excel in Safe Mode if the freeze happens again. Close Excel first. On Windows, press Windows key+R, type
excel /safe, and press Enter. If the Run box cannot find Excel, use the Start menu to locate Excel while holding Ctrl as you launch it, then confirm the Safe Mode prompt if shown. Safe Mode starts Excel with certain customizations and add-ins disabled, which helps identify whether an add-in or startup setting is involved.Open a copy of the affected workbook in Safe Mode rather than experimenting with your only copy. If it works there, the issue may be an add-in, customization, or startup file. Safe Mode is a Windows troubleshooting option; Mac Excel does not use the same
/safecommand. -
Test add-ins and update Microsoft 365. If Excel works in Safe Mode, close it and start normally. Go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, choose Go, and clear an add-in’s checkbox to disable it; repeat for Excel Add-ins if relevant. Restart Excel and test the workbook. Disable one add-in at a time when possible so you can identify the cause, then re-enable add-ins you need.
To check for updates, go to File > Account > Update Options > Update Now. The menu can differ if your organization manages Office updates. Save your work and close Office apps before an update if prompted.
-
Repair Office if Excel freezes across workbooks. If the problem persists with more than one workbook, close Office apps and use Windows Settings. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, then Modify. In Windows 10, use Settings > Apps > Apps & features, select Microsoft 365, and choose Modify. Run Quick Repair first. If that does not help, consider Online Repair; it takes longer and may require an internet connection and sign-in.
Repairing Office is different from repairing a single workbook. Keep a separate copy of important files before troubleshooting, particularly if you plan to make changes to the original workbook.
Common Mistakes
- Clicking repeatedly while the status says “Not Responding.” This can stack up actions and make it harder to tell whether Excel is processing. Wait, then try one action at a time.
- Ending the task immediately. Task Manager can close Excel, but it cannot save work that Excel has not written to disk. Allow time for a save or calculation to finish first.
- Opening and saving over the only copy. Work from a duplicate when testing a problematic workbook. A recovered file may be older or incomplete, so compare versions before replacing anything.
- Disabling every add-in without recording what changed. Turn off add-ins methodically and test after each change. Otherwise, you may not find the cause or may leave a needed tool disabled.
- Assuming AutoSave means every edit is recoverable. AutoSave applies to supported files saved in OneDrive or SharePoint, and a sync or connection problem can delay updates. Check the saved time and version history.
Tips
- Make a copy before troubleshooting a workbook-specific freeze. Use File > Save As to create a test copy once Excel is responsive. If Excel is already frozen, do not assume a copy was created; find the existing file in its folder and duplicate it after the app closes.
- Note what you were doing when the freeze began. A pause during a data refresh, large paste, formula recalculation, or macro points to different causes. Record the workbook, action, and approximate time so you can repeat the test safely.
- Watch for a repeatable pattern. If one workbook freezes but other files open normally, focus on that workbook, its data connections, and its size. If every workbook freezes, investigate add-ins, updates, Office repair, and available system resources.
- Keep large files manageable. If the workbook opens, remove only data or formatting you understand and no longer need. Do not delete formulas, connections, or sheets simply to make the file smaller without first making a backup.
- Save in stages during long tasks. When Excel is responsive, save before refreshing data, running a macro, or making a broad change. For cloud files, allow the save or sync indicator to finish before closing the workbook.
Troubleshooting
Excel does not recover after waiting. If there is no visible progress and the window remains stuck, use Task Manager as described above. Reopen Excel and check Document Recovery, Manage Workbook, and cloud version history. Recovery is not guaranteed, particularly for changes made since the last successful save.
The workbook freezes every time it opens. Start Excel in Safe Mode and open a duplicate of the file. If the copy opens, save a new copy under a different name, then test the original’s features in a controlled way. If the workbook contains external data connections, try opening it without refreshing them; do not choose a refresh option until you know the connection is available. If possible, ask the file’s owner for an earlier working version.
Every workbook freezes, even a blank one. Test Excel in Safe Mode. If it responds there, disable add-ins one by one. If it still freezes, install available Microsoft 365 updates, restart Windows when convenient, and use Quick Repair. Check that the computer has free storage and is not overloaded by other applications. If repair does not help, contact your organization’s IT administrator or Microsoft Support with the Excel version, Windows version, and the steps that reproduce the problem.
The recovered file is missing recent edits. Check the Document Recovery list, Manage Workbook, the original folder, and OneDrive or SharePoint version history. Compare the names and timestamps before opening or restoring versions. Save any promising recovery under a new filename. Excel cannot recreate changes that were never saved or captured by AutoRecover, so preserve all plausible copies until you confirm which one is complete.
You use Excel for the web or Mac. Excel for the web runs in a browser, so reload only after checking whether the workbook has finished saving; unsynced edits may be lost. Mac users should use Force Quit rather than Windows Task Manager and check Excel’s recovery prompt when reopening. Menu labels and recovery options can differ between platforms and update channels.
Frequently Asked Questions
Should I wait or close Excel when it says “Not Responding”?
Wait first, especially during calculations, refreshes, or saves. If there is no progress after a reasonable wait and Esc does not help, end the task as a last resort, knowing unsaved changes may be lost.
Will I lose my work if I force quit Excel?
You may lose changes since the last successful save. After reopening, look for Document Recovery and unsaved workbooks, and check cloud version history if the file was stored online. Recovery features may not contain every recent edit.
How do I recover an unsaved Excel workbook?
Reopen Excel and check the Document Recovery pane. You can also look under File > Info > Manage Workbook for an unsaved or recovered version. Open candidates carefully and save a recovered copy with a new name.
Why does only one Excel file keep freezing?
The workbook may be unusually large, contain complex formulas or connections, or have damaged content. Test a copy in Safe Mode and avoid refreshing external data until you have a backup. If other workbooks work normally, the issue is more likely file-specific than an Excel-wide fault.
Does Safe Mode delete or change my workbook?
No. Safe Mode changes how Excel starts by temporarily disabling certain add-ins and customizations; it does not itself delete workbook content. Still, use a copy when investigating a file that may be damaged, and avoid saving experimental changes over the original.
Can I prevent Excel from freezing again?
You cannot prevent every slowdown, but saving before demanding tasks, keeping Office updated, checking add-ins, and allowing cloud saves to finish can reduce risk. Keep a backup of important workbooks and note which action triggers any repeatable freeze.
Related
- Excel Won’t Insert a Row? Causes, Fixes, and Workarounds
- Excel Print Area Greyed Out: Why It Happens and Fixes
- Excel Protect Sheet Greyed Out? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Find and Replace in OneNote? What You Can DoNo—OneNote does not provide a built-in Find and Replace command for automatically changing every occurrence of text across…
- How to Hide Columns in Excel: A Step-by-Step GuideTo hide columns in Excel for Microsoft 365 on Windows, select one or more column headers, right-click the…
- Split Cell Color in Excel: What Works and What Doesn’tExcel cannot natively give one cell two separate solid fill colors, such as red on the left and…
- How to Get Rid of Mail Merge in Word Without Losing TextTo get rid of mail merge in Word, first save a copy, then choose what should happen to…
- Hide Columns in Excel Temporarily: Steps to Show Them AgainTo temporarily hide columns in Excel for Microsoft 365 on Windows, select the column headers, then choose Home…
- How to Export a CSV File in Excel Without Losing DataTo export a CSV from Excel for Microsoft 365 on Windows, open the workbook, select the worksheet you…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.