If Excel says “Not Responding,” wait briefly first, especially if you opened a large workbook or started a calculation. If it does not recover, protect any available work, then try Excel in Safe Mode, isolate add-ins or the affected workbook, and update or repair Microsoft 365 if the problem affects multiple files.
Start with the safest troubleshooting steps
Excel can temporarily stop repainting its window while it calculates, loads data, or waits for another resource. A short pause is safer than immediately ending the task: closing Excel forcefully can discard changes that have not been saved. Look for activity such as a changing status message, a progress indicator, or disk activity, and give a demanding operation time to finish.
If Excel remains unresponsive, work through these steps in order:
- Wait a few minutes if the workbook is large or an import, refresh, or calculation is underway. Avoid repeatedly clicking the window, which can queue up extra commands.
- Press Esc once to try to cancel the current operation. For a calculation on Windows, Ctrl+Break may interrupt it; on some keyboards you may need Fn as well. Mac keyboards and Excel versions differ, so try Esc first.
- If the window recovers, save a new copy using File > Save As before doing more diagnosis. If Excel is still frozen, do not assume recent unsaved edits can be recovered.
- When you must close a frozen Excel process on Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. On Mac, use Option+Command+Esc, select Microsoft Excel, and choose Force Quit.
Ending a task is a last resort, not a repair. On the next launch, Excel may offer Document Recovery for work it retained, but recovery is not guaranteed. Open recovered versions carefully and save the best candidate under a new name rather than overwriting the original immediately.
Work out whether the problem is Excel or one workbook
The scope of the freeze is a useful clue. If Excel hangs with just one file, that workbook, its contents, or a connection it uses may be responsible. If several unrelated workbooks freeze, consider an add-in, the Office installation, an update, or a device-wide resource issue.
Try opening a blank workbook from Excel’s start screen. If the blank file works, test another existing workbook and note whether the problem follows a particular file or action. For example, a workbook that freezes only when you refresh a query points toward data loading, while one that hangs when a sheet opens could contain expensive formulas, links, or workbook code. Avoid repeatedly opening a problematic file if each attempt triggers the same long operation.
Also note when the issue began. A freeze that appears after installing an add-in, changing a workbook, connecting to a network location, or updating Office gives you a more focused lead than “Excel is slow.” On a shared or managed computer, ask your IT administrator before changing organization-controlled settings.
Use Safe Mode to check add-ins and startup behavior
Excel Safe Mode starts the Windows desktop application with certain startup features bypassed. It is a useful test for problems caused by an add-in or a customized startup environment; it does not repair a damaged workbook. Close Excel if possible, press Windows key+R, type excel /safe, and press Enter. If Excel opens in Safe Mode and behaves normally, an add-in or startup customization becomes a reasonable suspect.
To test add-ins in normal Excel, go to File > Options > Add-ins. At the bottom, next to Manage, choose COM Add-ins and click Go. Clear the checkbox for an add-in to disable it temporarily, then restart Excel normally and test. If the problem continues, return to the same dialog and re-enable it before testing another item. This one-at-a-time approach helps identify the cause without leaving useful add-ins disabled.
Excel also has other add-in types, so a clean COM Add-ins list does not rule out every extension. In File > Options > Add-ins, check the Manage list for other available types, such as Excel Add-ins, and use Go to inspect them. Only disable items you recognize or can verify with their publisher or IT team. Safe Mode works for the Windows desktop version; Excel for the web does not have this Windows startup mode, and Mac troubleshooting controls are different.
Check a workbook that freezes on its own
If one workbook is the trigger, first preserve the original. If you can open it, use File > Save As to make a diagnostic copy, then test changes on that copy. A workbook may be slow because it contains many formulas, large ranges, conditional formatting rules, external links, embedded objects, or data connections. A file stored on a network or cloud service can also appear stuck while Excel waits for access or synchronization.
If Excel cannot open a file normally, use the built-in recovery option in the Windows desktop app: choose File > Open > Browse, select the workbook, click the arrow next to Open, and choose Open and Repair. Excel may offer to repair the file or extract data. Results vary, so keep the original untouched and save any recovered content separately. This option is not a guarantee that every workbook can be restored.
For a workbook with external data, check whether its source is available and whether a refresh was running when Excel stopped responding. Do not repeatedly refresh while diagnosing. For files opened from email or a shared location, save a local copy if permitted and test it there; this can help distinguish a file-access delay from a workbook problem. Do not remove links, macros, or data connections unless you know what they do or have a copy to restore.
Consider formulas, calculation, and large data operations
A workbook can seem frozen while Excel recalculates formulas. Volatile formulas, formulas referencing entire columns, complex array calculations, and chains of dependent formulas can make recalculation demanding, especially in a large workbook. A refresh of a Power Query connection, PivotTable, or external data source can also take time or wait for a connection.
When Excel responds again, check the status bar for calculation or refresh activity and identify what action preceded the pause. If a calculation is the trigger, you can temporarily choose Formulas > Calculation Options > Manual in the Windows desktop ribbon, then save a copy and investigate the workbook. Manual calculation means formula results may not update automatically when inputs change. Press F9 to calculate open workbooks; use this setting only if you understand the implications, and return to Automatic when appropriate. Do not treat an old displayed result as current while calculation is manual.
For a recurring slow workbook, consider narrowing formulas to the data actually used, reducing unnecessary formatting across entire sheets, and reviewing repeated calculations. Make one change at a time and compare behavior. If you rely on macros or complex models, check with the workbook’s owner before altering its structure; a change that improves speed can also change the workbook’s intended behavior.
Check memory, other programs, and file access
Excel needs working memory for the workbook and its calculations. Very large files, many open workbooks, browser tabs, or other demanding applications can leave a computer short of available resources. Close applications you do not need, then reopen Excel and test the same task. On Windows, Task Manager can show whether memory or processor use is high; on Mac, Activity Monitor provides similar information. High use is a clue, not proof that Excel itself is defective.
Check that the device has enough free storage for temporary work and that a network connection is stable if the workbook depends on shared files or external data. If only a workbook on a shared drive hangs, test a permitted local copy and compare. For OneDrive or SharePoint files, allow synchronization to settle and look for sync or access errors. Avoid editing the same file in multiple places during recovery, since competing copies can create confusion about which changes are current.
Update or repair Microsoft 365
If Excel freezes with several workbooks, check for Office updates. In Excel for Windows, go to File > Account > Update Options > Update Now. The exact controls can vary if an organization manages updates. Save and close Office apps before applying updates when prompted, then restart the computer if the installer requests it.
If updating does not help, Windows offers repair options for Microsoft 365. Open Windows Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, then Modify. Depending on the installation, select Quick Repair first. If the issue remains, Online Repair is a more thorough option and requires an internet connection; follow the on-screen prompts. Menu wording may differ slightly across Windows builds. Repair can change or refresh Office components, so save work and close Office programs first.
Excel for Mac does not use the Windows Modify and Repair controls. Update Office for Mac through an available Microsoft AutoUpdate prompt or the update route used for that installation, and consult your organization’s support if updates are centrally managed. Excel for the web is updated as part of Microsoft’s online service; there is no desktop installation to repair. If only the browser version has trouble, try reloading after confirming changes have saved, or test a supported browser without extensions that interfere with the page.
Recover unsaved work and reduce the risk of another freeze
After an unexpected close, reopen Excel and look for the Document Recovery pane. Review the listed timestamps and open a recovered copy before saving it under a new filename. If the pane is absent, check File > Info for workbook management or recovery options available for that file and installation. Excel’s AutoRecover can help with some unsaved work, but it is not a substitute for saving and may not contain the latest edits.
To make future recovery easier, save important work regularly, use descriptive versioned filenames before major changes, and keep a backup in an approved location. AutoSave is available for eligible files stored in OneDrive or SharePoint when the feature is enabled; it is not the same as a universal guarantee that every local file is continuously saved. Confirm that the save or sync indicator shows the latest changes are stored before closing a workbook.
When reporting a recurring freeze, record the Excel version, Windows or Mac version, workbook location, approximate file size, the action that triggers the hang, and whether Safe Mode changes the result. These details help an IT administrator or Microsoft support distinguish an add-in issue from a file, connection, or installation problem. Avoid sending sensitive workbook contents unless you are authorized to share them.
Frequently Asked Questions
Should I wait or close Excel when it says Not Responding? Wait briefly if a calculation, refresh, or large-file operation may be in progress. If the window stays frozen and no work can be saved, force-quitting may be necessary, but unsaved changes can be lost. Check Document Recovery after reopening.
How do I open Excel in Safe Mode? In Windows, press Windows key+R, type excel /safe, and press Enter. If Excel works there but not in normal mode, test add-ins and startup settings. This command is for the Windows desktop app, not Excel for the web.
Why does Excel freeze only with one file? That workbook may contain heavy formulas, a problematic connection, links to unavailable files, or damaged content. Test a copy, avoid repeated refreshes, and try Open and Repair if it will not open. Keep the original unchanged.
Can I recover an Excel file I did not save? Sometimes. After reopening Excel, check the Document Recovery pane and relevant recovery options under File > Info. Recovery depends on what Excel retained, so it may not include the latest changes or be available at all.
Does Excel for Mac use the same troubleshooting steps? Some principles are shared, such as testing another workbook and checking for updates, but Windows Safe Mode and Windows app-repair paths do not apply. On Mac, Force Quit is Option+Command+Esc; Excel for the web has neither desktop repair controls nor Windows Safe Mode.
Related
- How to Add Timed Transitions in PowerPoint
- Monthly Budget Template Sheets: How to Build and Use One
- Debt Reduction Snowball Spreadsheet: Build One in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert an Excel Sheet Into Word: 3 Easy WaysTo insert an Excel sheet into Word, copy the cells you need from Excel and paste them into…
- Merge Cells in Excel Using Keyboard: Shortcuts & StepsIn Excel for Microsoft 365 on Windows, select the cells you want to combine, then press Alt, H,…
- Will Google Sheets Get Power Query? What to Use InsteadNo—Google Sheets does not currently have a built-in version of Microsoft Power Query, and Google has not announced…
- SUMIF Negative in Google Sheets: Sum Values Below ZeroTo sum negative numbers in Google Sheets, use =SUMIF(B2:B100,"<0") when the values are in B2:B100. The criterion "<0"…
- How to Edit a PivotTable in ExcelTo edit a PivotTable in Excel for Microsoft 365 on Windows, click any cell inside it, then use…
- Google Sheets: How to Generate Unique IDsYes. Google Sheets can generate unique IDs with a row-based formula for simple lists, or with Google Apps…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.