If an Excel document is not responding, wait briefly before closing it: Excel may be calculating, loading data, or saving a large workbook. If it stays frozen, try to recover the work safely, then troubleshoot whether the cause is the workbook, an add-in, or Excel itself.
What “Not Responding” means
In Excel for Microsoft 365 on Windows, the Not Responding message usually means Windows is not receiving a timely response from Excel’s main window. It does not prove that the program has crashed or that the workbook is damaged. Excel can show the same status while it is busy with a demanding calculation, opening a file, refreshing a connection, or responding to an add-in.
Look for signs of activity before taking action. The mouse pointer may show a busy indicator, the computer may be using substantial processor or disk resources, or Excel may eventually return to normal. A large workbook with many formulas can take a while to recalculate, especially after changes or when opened on a slower computer. Repeatedly clicking the window or issuing more commands can make it harder to tell whether Excel is working and may queue additional actions.
There is no single wait time that fits every file. Give Excel longer for a large import, a complex calculation, or a refresh than you would for a small workbook. If the status persists and the computer is no longer showing signs of progress, move on to recovery and diagnosis rather than assuming that waiting indefinitely will solve it.
What to do first without risking your work
- Wait and avoid repeated clicks. If Excel is calculating or saving, interrupting it may not help. Give a large or complex operation a reasonable chance to finish.
- Check whether another prompt is hidden. Use Alt+Tab to look for a dialog box, such as a file-format warning or a request to update links. A hidden prompt can make Excel appear stuck. On Mac, use Command+Tab to switch apps and check for Excel dialogs.
- Try Esc once. Pressing Esc may cancel an operation that Excel allows you to interrupt, but it cannot cancel every task. Avoid holding down keys or repeatedly pressing them.
- Check whether Excel has recovered. If it responds, save a new copy with File > Save As before continuing with extensive troubleshooting. This preserves a separate version in case the next step changes the workbook.
- Close Excel only as a last resort. If it remains frozen, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. This can discard changes since the last save. On Mac, use Option+Command+Esc, select Microsoft Excel, and choose Force Quit; unsaved changes may be lost there too.
Do not assume that waiting will always preserve an unsaved workbook. If Excel has stopped responding completely, it may not be able to write the latest changes. The safest approach is to avoid force-closing it while it may still be processing, but to recognize that an unresponsive program can eventually require a restart.
Recover unsaved changes after a restart
When Excel restarts after an unexpected close, look for the Document Recovery pane. If it lists one or more versions, open the most recent relevant copy and save it under a new name. Compare versions if the newest one is incomplete; a recovered file is not guaranteed to contain every change made before the freeze.
If the recovery pane does not appear, check File > Info > Manage Workbook > Recover Unsaved Workbooks. The exact availability depends on whether Excel created a recoverable version and on the workbook’s save and AutoRecover settings. You can review those settings in File > Options > Save. AutoRecover is intended to help with recovery, not to replace saving regularly, and the interval means some recent work may still be missing.
For a workbook saved in OneDrive or SharePoint, check its version history if versioning is available. In Excel, the file name or File > Info may provide access to version history, depending on the account and interface. Open an earlier version carefully and save a separate copy if you need to compare it with the current file. Cloud syncing can help protect saved versions, but it does not guarantee that unsaved edits will be preserved.
Is the workbook or Excel causing the freeze?
A useful first diagnostic is to open a different, small workbook or create a blank one. If only one file freezes, focus on that workbook. If even a blank workbook hangs, investigate Excel, an add-in, or the Office installation. This distinction avoids spending time repairing a file when the same problem affects the whole application.
A workbook-specific freeze can occur during opening, saving, recalculation, or refresh. Common sources include a large number of formulas, formulas that refer to entire columns, complex conditional formatting, many pivot tables, extensive images, external links, and data connections. For example, a workbook that refreshes several large data sources on opening may look frozen while those sources are being contacted. A file stored on a slow or temporarily unavailable network location can also take longer to access.
If Excel becomes responsive, save a copy before testing changes. For a calculation-related slowdown, inspect recently added formulas and whether they cause many dependent cells to recalculate. If a connection refresh is involved, check the workbook’s queries or connections and whether the source is reachable. Avoid deleting formulas, links, or data simply to make the file open faster unless you understand what the workbook uses them for.
Test Excel in Safe Mode and check add-ins
Excel Safe Mode starts the Windows application without some usual startup features and add-ins. To try it, close Excel if possible, press Windows key+R, type excel /safe, and press Enter. If Excel works normally in Safe Mode, an add-in or startup customization is a reasonable suspect. Safe Mode is a diagnostic step, not a repair for a damaged workbook.
To disable a COM add-in in normal Excel, open File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage list and choose Go. Clear one add-in at a time, choose OK, and restart Excel to see whether the problem changes. If you use Excel add-ins, repeat the check by selecting Excel Add-ins in the Manage list. Turning off add-ins individually helps identify the one involved; disabling all of them permanently may remove features you rely on.
If the issue occurs only with a particular workbook, test a copy of it in Safe Mode as well. If it still hangs, the file’s contents or a data source may be the cause. If Safe Mode cannot start or a blank workbook also freezes there, continue with Office updates and repair rather than repeatedly changing workbook content.
Repair a workbook that will not open
If one workbook repeatedly fails to open, Excel’s Open and Repair command may help. In Excel, choose File > Open > Browse, select the file, then select the arrow beside the Open button and choose Open and Repair. If Excel offers a repair option, follow the prompts and save any opened result as a new file. Repair may recover workbook contents, but it can also omit damaged elements, so keep the original untouched.
If the file is on a network drive, removable disk, or cloud-synced folder, make a local copy first if you can access it. This helps separate a file-access or sync problem from an issue with the workbook itself. Do not repeatedly overwrite the only copy while experimenting. If other programs also have trouble reading the file, or repair does not work, use a known-good backup or version history if available.
Update or repair Microsoft 365 on Windows
If multiple workbooks freeze, check for an Office update. In Excel, choose File > Account > Update Options > Update Now. The update options may be managed by an organization, in which case contact the organization’s IT administrator if the command is unavailable or updates are controlled centrally.
On Windows, you can also try repairing Microsoft 365 from Settings. Open Settings > Apps > Installed apps, find Microsoft 365, choose the menu beside it, and select Modify. The available labels can vary slightly by Windows release. Quick Repair is the less extensive option; Online Repair is more thorough and may take longer and require an internet connection. Follow the on-screen instructions, close Office apps when requested, and restart Windows if prompted.
These Windows repair steps do not apply in the same way to Excel for Mac or Excel for the web. On Mac, update Office through the available Microsoft AutoUpdate options and check whether the issue affects one workbook or all workbooks. Excel for the web runs in a browser, so test the same file in desktop Excel or another supported browser to help narrow down whether the problem is browser-specific or file-related.
Prevent Excel from becoming unresponsive
Regular saving and a few maintenance habits reduce the impact of freezes, even though they cannot prevent every failure. For important files, keep a separate backup or use a managed cloud location with version history where appropriate. Avoid storing the only copy on removable media, and allow a save or sync to finish before shutting down the computer.
- Keep Microsoft 365 and Windows up to date, subject to your organization’s update policy.
- Review large workbooks for unnecessary formulas, formatting, images, and data connections, while preserving the workbook’s intended logic.
- Refresh external data when you need it rather than triggering repeated refreshes during troubleshooting.
- Use add-ins only when needed and note which ones are enabled, so a later Safe Mode test is easier to interpret.
- Keep a clean copy before making substantial structural changes to a business-critical workbook.
More memory or a faster computer can help with some large-workbook workloads, but hardware is not the only explanation. A single problematic add-in, inaccessible data source, or damaged file can cause trouble on an otherwise capable computer. Diagnose the scope of the issue before buying hardware or rebuilding a workbook.
Frequently Asked Questions
Should I wait or force close Excel?
Wait first if Excel may be calculating, saving, opening a large file, or refreshing data. If it remains unresponsive and shows no sign of progress, force-closing may be necessary, but unsaved changes can be lost. Check for a hidden dialog before ending the task.
Will Excel recover my unsaved work?
Sometimes. Check the Document Recovery pane after restarting, then File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on available AutoRecover data and may not include the latest edits, so save recovered versions under a new name.
Why does Excel freeze only when I open one file?
The workbook may contain demanding calculations, data connections, external links, or damaged content. Test a different workbook to confirm the problem is limited to one file, then try opening a copy with Open and Repair. Keep the original unchanged while testing.
Can an Excel add-in cause Not Responding?
Yes. An add-in can affect startup or workbook operations. Start Excel with excel /safe on Windows; if the issue disappears, disable add-ins individually through File > Options > Add-ins to identify a possible cause.
What if every Excel file freezes?
If blank workbooks and several existing files all hang, the cause is more likely to involve Excel, an add-in, or Office than one particular file. Test Safe Mode, check for updates, and consider the Microsoft 365 repair options in Windows Settings.
Related
- Excel Add Slicer to Table: Steps, Limits, and Tips
- Excel 3D Scatter Plot: Options and Workarounds
- Entire Excel Sheet Not Responding? Fixes That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create a Local Distribution List in Outlook for EmailTo create a local distribution list in classic Outlook for Microsoft 365 on Windows, open People, select Home…
- How to Change Date Format in an Excel Column EasilyTo change the date format for an Excel column, select the column, press Ctrl+1 on Windows, choose Date…
- Excel Delimited Text to Columns: How to Split DataTo split delimited text in Excel for Microsoft 365 on Windows, select the cells, choose Data > Text…
- Excel Dropdown List: How to Select Multiple ItemsExcel’s standard Data Validation dropdown lets you select only one item at a time. To keep several selections…
- Google Sheets Apps Script Not Opening? Fixes to TryIf Apps Script is not opening from Google Sheets, open the spreadsheet in a desktop web browser and…
- How to Set Out of Office Dates in Outlook for Any DeviceTo set out-of-office dates in Outlook, open Automatic Replies, turn on replies for a specific time period, enter…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.