If Excel says Not Responding, wait briefly before closing it, especially if the workbook is large or performing a calculation. If it stays frozen, reopen Excel in Safe Mode, check add-ins, and repair or update Office if needed. Save a copy of the workbook as soon as Excel responds again. These steps are for Microsoft Excel for Microsoft 365 on Windows; Mac and Excel for the web differences are noted where they matter.
What You’ll Need
- Your computer and a few minutes to let Excel finish any work already in progress.
- Access to the workbook, plus a backup or cloud copy if one is available.
- On Windows, permission to restart Excel and, if necessary, repair Microsoft 365. A work or school computer may require your IT administrator.
Step-by-Step
- Wait and check whether Excel is actually busy. Give the program a minute or two before clicking repeatedly or trying to close it. A large calculation, data refresh, chart update, or opening a workbook from a network location can make Excel temporarily unresponsive. Look for a progress message at the bottom of the window, a changing progress bar, or signs that the computer is still working. If Excel becomes responsive, save immediately with Ctrl+S. On Mac, use Command+S. If the same workbook freezes repeatedly, make a separate copy before trying changes.
- Close other applications and check available resources. If Excel is still frozen, wait until the computer finishes any obvious heavy work, then close other programs you do not need. On Windows, press Ctrl+Shift+Esc to open Task Manager and check whether memory or CPU use is unusually high. Do not end Excel just because it briefly uses a lot of resources; a calculation can cause a temporary spike. If the computer itself has stopped responding, give it more time before restarting it. On Mac, Activity Monitor can show whether Excel or another process is using substantial resources.
- End Excel only if waiting has not helped. If the application remains stuck and there is no sign of progress, close it from Task Manager: select Microsoft Excel, then choose End task. This can discard unsaved changes, so use it only when necessary. On Mac, choose Apple menu > Force Quit, select Microsoft Excel, and choose Force Quit. When Excel asks whether to recover work after you reopen it, review the recovered versions carefully and save the best one under a new name. Do not assume recovery contains every recent edit.
- Reopen Excel without opening the problem workbook. Start Excel from the Start menu, rather than double-clicking the workbook that froze. If Excel opens normally, create a blank workbook and test whether the application responds. If Excel freezes before you can use it, try Safe Mode on Windows: press Windows key+R, type
excel /safe, and press Enter. Safe Mode starts Excel with many customizations and add-ins disabled. If the command is not recognized, Excel may not be available at the expected location or may need repair. Excel for Mac does not use the Windows/safelaunch command; restart the Mac and test Excel without reopening the affected workbook. - Test the workbook separately from the Excel application. If Excel works with a blank file but freezes when you open one particular workbook, the file, its contents, or its storage location may be involved. Make a copy before testing. In Excel, choose File > Open > Browse, select the copy, and use the arrow beside the Open button to choose Open and Repair if that option is available. Choose Repair first; Extract Data may recover values and formulas but not restore the workbook’s original layout. For a file stored on a network drive or removable device, copy it to a local folder and test that copy. If the file is in OneDrive or SharePoint, check whether it is still syncing before making competing copies.
- Disable add-ins if Safe Mode works. In normal Excel on Windows, go to File > Options > Add-ins. At the bottom, beside Manage, choose COM Add-ins and select Go. Clear the check boxes to disable the listed add-ins, then restart Excel normally. If the freeze stops, turn add-ins back on one at a time, restarting and testing after each change, to identify the one causing the problem. Return to Manage and check Excel Add-ins as well if needed. On a Mac, open Tools > Excel Add-ins to review available Excel add-ins; menu choices can vary by version. For company-managed add-ins, ask your administrator before removing or changing them.
- Update Microsoft 365 and restart the computer. In Excel for Windows, choose File > Account > Update Options > Update Now. If Excel is too unstable to open, restart Windows first and try again; an administrator may control updates on a managed computer. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is available, or update Office through the method used to install it. Install operating-system updates when practical, then restart and test Excel with a blank workbook before opening the affected file.
- Repair Office if Excel freezes in ordinary use. Close Office apps. In Windows, open Settings > Apps > Installed apps, select Microsoft 365, choose the three-dot menu, then Modify. Run Quick Repair first and follow the prompts. If that does not help, repeat the process and choose Online Repair, which needs an internet connection and can take longer. The exact labels can vary with Windows version or an organization-managed installation. On Mac, there is no matching Windows Modify repair flow; update Office, restart, and contact Microsoft support or your IT administrator if the issue continues.
- Save the repaired or recovered workbook safely. When Excel works again, use File > Save As to save a new copy in a local folder or a trusted cloud location. Give it a clear name so you do not overwrite the only original. Reopen the saved copy and check important sheets, formulas, charts, and external links. If the workbook is shared, tell collaborators which copy is current before replacing or removing other versions.
Common Mistakes
- Clicking repeatedly while Excel is busy. Repeated clicks can queue actions and make it harder to tell whether the program is recovering. Wait, observe, and then choose one next step.
- Ending the process too soon. Task Manager’s End task and Mac Force Quit can discard unsaved edits. Give Excel time first, particularly during a refresh or calculation, and look for recovered files after restarting.
- Testing the only copy of a damaged workbook. Repair attempts and repeated saves can complicate recovery. Make a duplicate first, and keep the original unchanged until the new file has been checked.
- Disabling every add-in permanently. Add-ins may provide required business tools. Use Safe Mode to diagnose, then re-enable them individually and involve IT if an add-in is managed.
- Reinstalling Office before simpler checks. A restart, add-in test, update, or repair may address the issue with less disruption. Reinstallation can also require sign-in or administrator access.
Tips
- Turn on AutoSave for eligible cloud files. AutoSave is available for supported files stored in OneDrive or SharePoint when you are signed in and the feature is on. It is not a substitute for a separate backup, and it may not be available for every file or account. Check the AutoSave switch near the top of Excel and confirm that the file is syncing.
- Use version history for cloud workbooks. For a workbook stored in OneDrive or SharePoint, use File > Info > Version History when available, or open version history from the storage service. Review timestamps and restore a prior version only after checking which edits it contains. Restoring an older version can replace newer work, so save a separate copy if uncertain.
- Reduce the load in very large workbooks. Close unused workbooks and avoid repeatedly refreshing external data while diagnosing a freeze. Once a copy opens, consider whether it contains unnecessarily large formatting ranges, volatile calculations, or data connections that are not needed. Make one change at a time and compare the result rather than removing workbook features at random.
- Record what triggers the problem. Note the workbook, action, approximate time, and whether Excel works in Safe Mode. A freeze only when refreshing one connection points to a different likely cause than a freeze in every blank workbook. These details help an administrator or support technician narrow down the issue.
Troubleshooting
Excel still freezes in Safe Mode: The cause may be the Office installation, a Windows issue, limited system resources, or a workbook that opens automatically. Restart Windows, make sure no other Excel process is stuck, and try opening Excel without opening a recent file. Run the Office repair steps above. If Excel freezes even with a blank workbook after repair, contact Microsoft support or your IT team and share the exact error message and what you have already tried.
Only one workbook causes the problem: Work from a copy. Use Open and Repair if offered, and check whether a local copy behaves differently from a network or cloud copy. If the file came from email or a shared location, ask the sender or owner for a fresh copy. For cloud files, check version history and sync status rather than repeatedly saving over the same file.
Excel opens, but saving causes a freeze: Check that the destination is available and that you have permission to write there. Try Save As to a local folder with a new filename. If that works, investigate the original network, removable drive, or cloud sync location before moving the new file back. Avoid disconnecting a drive while Excel is saving.
Excel for the web is unresponsive: First wait for the browser to finish saving or syncing. Check your internet connection and whether the workbook is still open in another tab or being edited by collaborators. If the page remains stuck, open the workbook again from OneDrive or SharePoint in a new tab before refreshing or closing the old one. A refresh can lose edits that have not synced. If the problem is limited to one browser, try a current supported browser or a private window, subject to your organization’s sign-in policies.
The computer freezes along with Excel: This may be a system-wide resource or hardware problem rather than an Excel-only fault. Give the computer time, disconnect unnecessary peripherals only when safe, and restart after confirming there is no active save or update. If it happens frequently in multiple applications, contact your device support team.
Frequently Asked Questions
How long should I wait before closing Excel?
There is no fixed time for every workbook. Wait a few minutes if Excel may be calculating, refreshing data, or opening a large file, and watch for activity. If nothing changes and the computer remains responsive, try the steps above before ending the process.
Will I lose my work if I end Excel in Task Manager?
Possibly. Changes since the last save may be lost, though Excel may offer recovered files when it starts again. Check recovered versions and cloud version history, then save recovered work as a separate file.
Does Excel Safe Mode delete my add-ins or settings?
No. Safe Mode is a diagnostic launch that temporarily starts Excel with many customizations and add-ins disabled. If Excel works there, investigate add-ins one at a time; Safe Mode itself does not remove them.
Why does Excel say Not Responding when calculating?
A large or complex calculation can temporarily occupy Excel, particularly in a workbook with many formulas or data connections. Wait for it to finish before closing the program. If the delay happens every time, test a copy of the workbook and reduce unnecessary calculation or refresh load carefully.
Are these steps the same for Mac?
The general approach is similar, but Windows Task Manager, the excel /safe command, and the Windows Office repair path do not apply to Mac. Use Apple menu > Force Quit only when necessary, check add-ins through Excel’s menus, update Office, and contact support if the problem persists.
What if I use Excel for the web?
Check the connection and sync status, then reopen the workbook from OneDrive or SharePoint in a new browser tab. Avoid refreshing a page while unsaved edits may remain. Windows Safe Mode and Office desktop repair steps are for the installed app, not Excel for the web.
Related
- Hide and Password-Protect Columns in Excel
- Hide Column C in Excel: Steps to Hide and Unhide It
- Excel ZIP Code Heat Maps: How to Build and Read Them
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Spill Error: Why It Keeps Happening and How to Fix ItYou keep getting a spill error in Excel when a formula is trying to return multiple results but…
- Outlook Excel Previewer Not Working? Fixes That HelpYes—an Outlook Excel preview that will not load is usually caused by a disabled preview setting, a missing…
- Bing Chat Excel Formula Not Working? Fixes That HelpIf a formula from Bing Chat is not working in Excel, check that it begins with an equals…
- Excel Named Range Not Working? Fix the Common CausesIf an Excel named range is not working, check that the name exists, has the right workbook or…
- Hanging Indent in Word: How to Fix ItTo fix a hanging indent in Microsoft Word, select the affected paragraph, open the Paragraph settings, and set…
- Excel Solver Not Working? Fix Setup and Model ErrorsIf Excel Solver is not working, first make sure the Solver Add-in is enabled in desktop Excel, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.