If Excel continually says “Not Responding,” first give it a few minutes if it may be calculating, saving, refreshing data, or opening a large workbook; then try to identify whether the delay affects one file or Excel itself. If it stays stuck, troubleshoot in this order: protect unsaved work, test Excel in Safe Mode, check add-ins and workbook workload, and then update or repair Microsoft 365.
What “Not Responding” means
In Windows, “Not Responding” generally means the application is not currently responding to Windows messages. It does not prove that Excel has crashed. A demanding calculation, a slow network connection, or a large data refresh can temporarily occupy Excel, so the interface may not update while work continues. Repeatedly clicking the window or opening more copies of the file is unlikely to help and can make it harder to tell whether Excel is progressing.
Look for signs of activity before ending the process. A changing status message, disk activity, or a calculation that eventually completes suggests Excel may still be working. If the window remains unresponsive for a long time with no apparent progress, or the same freeze returns whenever you use a particular workbook or feature, investigate the cause rather than assuming every freeze has the same fix.
A useful first distinction is whether the problem follows a particular workbook. If other workbooks open and behave normally, focus on that file, its formulas, connections, or location. If even a blank workbook freezes, focus on Excel’s add-ins, installation, updates, or the computer itself.
First steps that protect your work
If Excel responds even briefly, save before trying repairs. Use Ctrl+S on Windows. If you need to preserve the current state without overwriting the original, use File > Save As and create a separate copy. On a Mac, use Command+S. When a workbook is stored on a shared drive or cloud service, confirm that saving has finished before closing it.
If Excel is still busy, wait rather than repeatedly clicking. Then try these low-risk checks:
- Disconnect unnecessary devices or close other demanding applications, but do not disconnect a drive that contains the open workbook.
- Check whether Excel is waiting on a prompt hidden behind another window. Use Alt+Tab on Windows to inspect open windows.
- If Excel becomes responsive, note what was happening immediately before the freeze: opening a file, editing a formula, refreshing a query, printing, or using a particular add-in.
- Use Task Manager only after allowing reasonable time for the operation. Open it with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task only if you accept that unsaved changes may be lost.
After an unexpected close, reopen Excel and look for the Document Recovery pane. Open the most recent recovered version and save it under a new name. Recovery can help, but it is not a substitute for a saved copy and may not include the last changes.
Test Excel in Safe Mode
Safe Mode starts Excel with many customizations and add-ins bypassed, which helps determine whether something loaded at startup is responsible. On Windows, close Excel if possible, press Windows key+R, type excel /safe, and press Enter. If Excel is stable in Safe Mode but freezes during a normal start, an add-in or startup customization is a plausible cause. Safe Mode is a diagnostic test, not a permanent repair.
To check COM add-ins in a normal Excel session, go to File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage box and select Go. Clear the check boxes to disable the add-ins, then restart Excel normally. If the problem stops, turn them back on one at a time, restarting and checking after each change, to find the one associated with the freeze. You can check other add-in types from the same Manage box.
On Mac, Windows Safe Mode and the Windows Run command do not apply. Start Excel without opening the problem workbook, then review Excel’s add-ins and startup items using the options available in that Mac version. Menu names and available add-in controls can differ. If the freeze occurs only after opening a workbook, test a copy of that workbook separately rather than changing every Excel setting at once.
Check whether the workbook is the cause
A workbook can be slow or unresponsive because of its size, structure, or the work it triggers when opened. Try opening a different, smaller workbook. If that works, make a copy of the affected file and test the copy. A file stored on a network share, removable drive, or cloud-synced folder may also be delayed by access or synchronization problems. If permitted, compare with a local copy, while avoiding simultaneous edits to separate copies that could later conflict.
Common workbook-level causes include:
- Large ranges used in formulas, formatting, charts, or data validation when only a small portion of the sheet is needed.
- Many volatile or complex formulas that recalculate frequently, especially across multiple sheets or workbooks.
- External links, queries, connections, or pivot tables waiting for data or a server response.
- Excessive conditional formatting, styles, embedded objects, or imported data that make a workbook larger and harder to process.
- Macros that perform lengthy operations or repeatedly update cells and the screen.
To narrow it down, work on a copy and temporarily avoid refreshing data or running macros when you open it. If the file opens, use the workbook’s features selectively to identify which operation triggers the delay. Do not delete formulas, connections, or macros from the original as a diagnostic shortcut; those elements may be essential to the workbook.
Understand calculation and data refresh delays
Excel may appear frozen while it recalculates formulas after a change. This is more likely in a workbook with many dependent formulas, broad whole-column references, or calculations that depend on other workbooks. If the status bar indicates calculation, wait for it to finish before making more edits. Pressing keys repeatedly during a long calculation can queue extra work or make the situation harder to assess.
For a workbook that recalculates too often, review formulas and references on a copy. Prefer ranges that match the data actually in use over unnecessarily broad ranges, and remove duplicate calculations only when you understand their purpose. You can also review calculation settings at Formulas > Calculation Options. Switching a workbook to Manual calculation can reduce automatic recalculation, but it also means results may remain out of date until recalculated. Use this only when you understand the consequences and remember to calculate before relying on the displayed values.
Data refreshes have a different cause: Excel may be waiting for a database, web source, network, or other connection. If a freeze begins after selecting Refresh All, check whether the source is reachable and whether other users report a service problem. Avoid repeatedly starting refreshes. A delayed connection is not necessarily evidence that the workbook is damaged.
Update Microsoft 365 and repair Office
Install available Office updates if Excel freezes across multiple files or began misbehaving after a change to the computer. In Excel for Windows, use File > Account > Update Options > Update Now, when those options are available. An organization may manage updates centrally, so contact its IT administrator if controls are missing or updates are restricted. On Mac, check for updates through Microsoft AutoUpdate, commonly available from Help > Check for Updates in an Office app.
If updates do not help, Windows can repair the Microsoft 365 installation. Save and close Office apps, open Windows Settings > Apps > Installed apps, select Microsoft 365, choose Modify, and follow the repair choices shown. Quick Repair is the less extensive option; Online Repair is more thorough and may take longer and require an internet connection. The exact labels can vary by Windows version or installation type. On Mac, there is no identical Windows repair workflow; updating Office and, if necessary, reinstalling it are common next steps.
Before repair or reinstallation, confirm that important files are saved and that you can sign in to the account associated with Office. A repair is intended to address Office installation problems, not to fix every slow workbook or a failing network connection.
Recover a damaged or inaccessible workbook
If one workbook will not open normally, make a copy of it first. In Excel for Windows, choose File > Open > Browse, select the file, open the arrow beside the Open button, and choose Open and Repair. If Excel offers repair or data extraction choices, read the prompts carefully and save any recovered result as a new file. This option may help with a damaged workbook, but it cannot guarantee that every formula, format, or feature will be restored.
Also check the file’s source and permissions. A workbook may fail to open because it is incomplete, still synchronizing, blocked by access restrictions, or stored on an unavailable location. If the file came from another person, ask for a fresh copy. If it is in OneDrive or SharePoint, verify that the service has finished syncing and that you are signed in to the correct account. Do not overwrite the only copy while investigating.
Reduce the chance of future freezes
Prevention is mostly about making the workbook easier to process and preserving recoverable copies. Save important work regularly, keep a versioned backup before major edits, and avoid editing the same file through conflicting copies. Close unused workbooks and applications when working with large datasets. If a spreadsheet is growing beyond what is practical to maintain, consider whether its data and reporting needs are better handled by a database or a dedicated reporting tool.
For recurring delays, record what triggers them and whether they affect all files. That simple record helps distinguish a calculation issue from a connection or add-in issue. Keep Office and Windows updated according to your organization’s policies, and remove or update add-ins only when you know they are not required for work. If a workbook contains important business data, involve its owner or IT support before changing links, macros, or refresh settings.
Frequently Asked Questions
Should I wait or force-close Excel?
Wait if Excel appears to be calculating, saving, or refreshing and there is a reasonable chance it will finish. Force-close only when it remains unresponsive without progress and you accept losing unsaved work. After reopening, check Document Recovery for a recoverable version.
Why does Excel say Not Responding when opening only one file?
The workbook may contain demanding formulas, connections, macros, or other complex content, or it may be stored somewhere slow or unavailable. Test a copy and a different workbook to separate a file-specific cause from an Excel-wide problem.
Will Safe Mode delete my files or settings?
Starting Excel in Safe Mode is intended as a diagnostic launch and does not itself delete workbook files. It bypasses some startup components. If Excel works there, investigate add-ins or customizations before removing anything.
Can I recover work after Excel freezes?
Sometimes. Reopen Excel and check the Document Recovery pane for an autosaved or recovered version. The amount recovered depends on what Excel had saved before the freeze, so recent unsaved changes may be missing.
Why does Excel freeze while refreshing data?
A refresh may be waiting for a source, network, sign-in, or server response, or it may be processing a large result. Check the connection and source availability, and avoid launching repeated refreshes while the first one is still running.
Related
- Excel Data Validation: How It Works and When to Use It
- Excel Data Validation for Text: Rules and Examples
- Excel Data Validation: Create a Yes-or-No Dropdown
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 Auto Archive Emails in Outlook 365 by Age or RuleTo auto archive emails in Outlook 365, choose a method that matches what you mean by archive: create…
- Google Sheets: Format a Cell as a DateTo format a cell as a date in Google Sheets, select the cell or range, then choose Format…
- Conditional Formatting to Compare Two Sheets in ExcelYes. In Excel for Microsoft 365, you can highlight differences between two sheets with a conditional-formatting formula that…
- Excel Text Getting Cut Off? Causes, Fixes, and TipsIf Excel text is getting cut off, widen the column or turn on Home > Alignment > Wrap…
- Box Plot Worksheet: How to Read and Make OneA box plot worksheet helps you organize numerical data, calculate its five-number summary, and display its distribution as…
- LibreOffice: How to Merge Cells in Calc and Format ThemTo merge cells in LibreOffice Calc, select the adjacent cells, then choose Format > Merge and Unmerge Cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.