If Excel suddenly stops responding, first give it a short time to finish the current task, especially if a workbook is large or calculating. If it remains frozen, protect any recoverable work, then restart Excel and troubleshoot whether the cause is a particular workbook, an add-in, or the application itself.
What “Not Responding” Usually Means
In Windows, “Not Responding” in Excel’s title bar or Task Manager generally means the program is not processing Windows messages promptly. It does not prove that Excel has crashed or that the workbook is lost. Excel may be busy recalculating formulas, opening a file, refreshing data, communicating with a printer or network location, or running an add-in. A temporarily unresponsive window can become usable again when that work finishes.
The cause matters because the right response differs. If every workbook stalls, suspect Excel, an add-in, or a system resource. If one file triggers the freeze while other files work normally, investigate that workbook’s size, formulas, connections, or file condition. If the delay happens only while opening or saving a file stored online or on a shared drive, the connection or storage location may be involved.
Repeatedly clicking the window, pressing keys, or launching more copies of Excel will not necessarily help. It can queue extra actions, obscure the original problem, or create confusion about which workbook contains the latest changes. Start with one careful pause and observe what Excel is doing.
What to Do Before Closing Excel
Wait briefly if the workbook is performing a demanding task. Watch for activity such as a progress indicator, a status-bar message, a spinning cursor, or changing CPU use in Task Manager. A large calculation or data refresh may take longer than expected; there is no universal wait time because workbook size and computer speed vary.
If the window recovers, save a separate copy before trying further fixes. Use File > Save As and choose a new name or location if the existing file may be damaged. If Excel is still frozen, avoid repeatedly pressing Ctrl+S: a command sent to an unresponsive application may not complete, and the result may not be obvious.
- Check whether another dialog box is waiting for a response, including a sign-in, link-update, or file-access prompt hidden behind the workbook.
- If the workbook is on a network share or cloud-synced folder, check whether the connection is available before attempting another save.
- Do not immediately end the process if the file contains unsaved changes. Force-closing can discard work that has not been written to disk.
When Excel does not recover and no further progress is visible, closing it may be necessary. On Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. On a Mac, use Command+Option+Esc, select Microsoft Excel, and choose Force Quit. These actions can lose unsaved changes; they are a last resort, not a repair for the underlying cause.
Find Out Whether the Problem Is Excel or One Workbook
After restarting, open Excel without immediately reopening the troublesome file. Create a blank workbook or open a small, known-good workbook. If that works, the original file is a stronger suspect. If Excel freezes before a workbook opens, or with several unrelated files, focus first on add-ins, updates, and the Office installation.
Then test the problem file in a controlled way. Make a copy if possible, and open the copy from a local folder rather than a network or synced location. If the local copy works, the original storage connection or sync process may be contributing to the delay. If only the original workbook stalls, consider recent changes such as added formulas, imported data, new links, or a large pasted range.
Excel for Microsoft 365 on Windows can be started in Safe Mode to help identify startup-related causes. Close Excel, press Windows key+R, type excel /safe, and press Enter. If Excel is stable in Safe Mode but not during a normal start, an add-in or a startup customization is a useful next place to investigate. Safe Mode is a diagnostic comparison, not proof that any one add-in is at fault.
Check Add-Ins and Startup Customizations
Add-ins can extend Excel, but an outdated or incompatible one may slow startup or interfere with workbooks. If Excel opens reliably in Safe Mode, disable add-ins and test a normal launch. In Excel, go to File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage box and choose Go. Clear the check box for an add-in to disable it, then restart Excel and test. You can re-enable items one at a time to identify whether a particular one is associated with the freeze.
Excel also lists other add-in types in the Manage box, including Excel Add-ins. Check only the relevant category, and note the original selections so you can restore them. If the problem persists with add-ins disabled, re-enable the ones you need rather than leaving all functionality switched off indefinitely. In a managed workplace, check with IT before changing organizationally required add-ins.
Safe Mode can also bypass some startup files and settings. If Excel works there, but disabling add-ins does not solve the issue, consider whether a custom workbook or template is loading at startup. Avoid deleting files from Excel’s startup folders as a first step. Identify what is being loaded and make a backup before changing startup content.
Look for Workbook-Specific Causes
A workbook can demand more work than its visible sheet suggests. Formulas filled down thousands of rows, volatile calculations, array formulas, extensive conditional formatting, PivotTable refreshes, external data connections, and links to unavailable files can all contribute to delays. A workbook with many worksheets, images, or objects may also take longer to open or save.
Pay attention to when the stall begins. If it happens after editing a particular cell, that edit may trigger recalculation across dependent formulas. If it occurs when opening the file, Excel may be updating links or refreshing data. If it appears during saving, the workbook may be large, stored remotely, or waiting on a sync or network operation. These clues narrow the investigation without requiring you to assume the file is corrupt.
- Try opening a copy of the workbook with external connections unavailable, if you understand what data may then be missing or out of date.
- Review formulas and formatting applied far beyond the data actually used. Unnecessary whole-column calculations or formatting can increase workload.
- If a recent change is clearly associated with the delay, test a copy and undo or remove that change there, not in the only original file.
Calculation mode is another possible factor. In Excel for Windows, check Formulas > Calculation Options. Manual calculation can make edits appear faster in some large workbooks, but formula results may remain outdated until recalculation. Do not switch to Manual and assume displayed results are current; restore Automatic when appropriate and recalculate before relying on the workbook.
Check Memory, Storage, and Connected Resources
Excel shares computer resources with other applications. A computer low on available memory, a nearly full drive, or many demanding programs running together can make opening and calculating workbooks slower. Close applications you do not need, then restart Excel. A restart can clear temporary resource pressure, but it does not explain why the issue recurs.
Files on shared drives, removable storage, or cloud-synced folders depend on more than Excel. A weak network connection, a disconnected drive, a sync conflict, or access permissions can delay opening and saving. If policy allows, test a copy in a local folder. Do not treat an unsynced local copy as a confirmed backup until it has been saved and, where needed, copied to a secure location.
External data sources and linked workbooks can also wait on another service or file. If Excel appears frozen while refreshing, give the operation time and check whether the source is reachable. Canceling a refresh or changing connection settings can affect the workbook’s contents, so do so only when you understand how the data is used.
Recover Unsaved Work and Repair Office
After an unexpected shutdown, reopen Excel and look for the Document Recovery pane. Excel may also offer recovered files through File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on what had been saved and on AutoRecover settings; it cannot guarantee that the very latest edits are available. Open a recovered version, inspect it, and save it under a new name before replacing an original file.
To review AutoRecover settings in Excel for Windows, go to File > Options > Save. The options include saving AutoRecover information at an interval and keeping the last autosaved version if Excel closes without saving. The exact recovery outcome depends on the settings and the circumstances of the shutdown. AutoRecover is useful protection, but it is not a substitute for saving important work regularly.
If Excel continues to freeze across workbooks, install available Microsoft 365 updates through File > Account > Update Options > Update Now. If updating does not help, Windows offers Office repair through Settings > Apps > Installed apps: select Microsoft 365, choose Modify, then try Quick Repair. If needed, Online Repair is a more extensive option and may require an internet connection and sign-in. Save work and close Office apps before repair; organizational devices may require an administrator.
Excel for the Web and Mac Differences
For Excel for the web, first determine whether the browser tab or the workbook itself is stuck. Check whether other websites respond, then wait briefly before refreshing. A refresh can discard unsaved browser-session changes, so use it cautiously. If possible, confirm that the file has saved and reopen it from its cloud location. Browser extensions, sign-in issues, and connectivity can affect the web experience in ways that do not apply to the Windows desktop application.
On a Mac, use Command+Option+Esc to force quit an app only when it is genuinely unresponsive and waiting has not helped. After reopening Excel, check for recovered documents and save a copy of important work. The Windows Safe Mode command excel /safe and Windows repair paths above do not apply on Mac. Menu names and update controls can differ by macOS and Office version, so use Excel’s Help or the Microsoft 365 update mechanism available on that Mac rather than following Windows-only paths.
Reduce the Chance of Another Freeze
Prevention is mostly about reducing risk and keeping a reliable recovery path. Save important work at sensible intervals, keep a separate copy of critical workbooks, and avoid making major structural changes to the only copy. For files stored in a shared or synced location, allow saving and synchronization to finish before shutting down or disconnecting.
- Keep Microsoft 365 and trusted add-ins current, and remove or disable add-ins you no longer use.
- Limit unnecessary formatting, duplicated data, and formulas that calculate over much larger ranges than the workbook needs.
- Refresh external data deliberately, particularly when the source is remote or the workbook is large.
- If the problem repeats, record the workbook involved, the action that triggered the freeze, and whether other workbooks behave normally. That information helps support staff distinguish a file issue from an application or system issue.
A common misconception is that every “Not Responding” message means Excel has permanently crashed. Sometimes it is busy and will recover; sometimes it has stalled and needs to be closed. The message alone cannot tell you which. The safest approach is to wait for evidence of progress, protect copies where possible, and use small diagnostic tests instead of making several changes at once.
Frequently Asked Questions
Should I wait or force close Excel?
Wait if Excel may be calculating, refreshing data, or saving, and look for signs of activity. Force close only when it remains unresponsive and there is no practical way to continue waiting. Unsaved changes may be lost, so check for recovered work after reopening.
Why does Excel freeze only when I open one file?
That points toward something specific to the workbook or its location, such as heavy formulas, external links, data refreshes, file size, or a network or sync issue. Test a copy and compare it with other workbooks before changing the original.
Can I recover an Excel file after ending the task?
Possibly. Reopen Excel and check the Document Recovery pane or File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on AutoRecover and what had already been saved, so some recent changes may be missing.
Does Safe Mode delete my add-ins or workbook data?
No. Starting Excel with excel /safe is a diagnostic start on Windows; it does not itself delete workbook data or permanently remove add-ins. If Excel works in Safe Mode, investigate add-ins or startup customizations separately.
Why does Excel keep saying Not Responding during calculation?
A calculation may be demanding because of workbook size, formula dependencies, or the computer’s available resources. If the workbook becomes responsive afterward, review its formulas and calculation workload. If it never recovers, test a copy and check whether the problem affects other files too.
Related
- Excel Slicer Not Updating? Fixes for PivotTables and Tables
- Excel Slicer Horizontal: How to Arrange Buttons in Rows
- Excel Slicer Multiple Columns: What Works and What Doesn’t
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Move Between Tabs: Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab, or…
- Schedule Maker Google Sheets: Build a Practical PlannerYes. Google Sheets can work as a flexible schedule maker: create a table or calendar-style grid, add dates…
- Excel vs Google Sheets: Features and DifferencesExcel and Google Sheets both handle everyday spreadsheet work, including formulas, charts, sorting, and pivot tables. Excel generally…
- How to Remove Filters and Sorting in Excel QuicklyTo remove filter arrows in Excel, select a cell in the filtered range and choose Data > Sort…
- Days Between Two Dates in Excel: A Simple GuideTo find the number of days between two dates in Excel, subtract the earlier date from the later…
- MS Word Insert Checkbox Symbol or Clickable BoxTo insert a static checkbox symbol in Microsoft Word, choose Insert > Symbol > More Symbols, select a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.