If Excel is not responding, wait briefly to see whether it is finishing a calculation or loading a file, then try pressing Esc and saving if the workbook becomes usable. If it remains frozen, open Excel in Safe Mode to check for add-ins, troubleshoot the affected workbook, and only force-quit as a last resort because unsaved changes may be lost.
What “Not Responding” Means
On Windows, “Not Responding” usually means Excel is not currently processing input from the window. It does not, by itself, prove that the program has crashed. Excel may be busy recalculating formulas, refreshing data, opening a large workbook, communicating with a network location, or waiting for an add-in or external connection. During that work, clicks and keystrokes may appear to have no effect.
The distinction matters because closing Excel too quickly can interrupt a task or discard changes. A short pause is sensible when the workbook is large or the task is intensive; a long freeze with no visible progress may point to a problem that needs troubleshooting. A spinning cursor, a dimmed window, or a Windows message that the app is not responding are clues, not a diagnosis. The same symptom can come from the workbook, Excel itself, an add-in, Windows, or a connected service.
What to Do First
Start with low-risk actions. Avoid repeatedly clicking the window: Windows may queue those clicks, making it harder to tell whether Excel has recovered. If Excel comes back, save a new copy before trying more disruptive repairs.
- Wait a minute or two if Excel was opening a large file, refreshing data, or running a calculation. Look for signs of activity, such as changing status text or progress indicators.
- Press Esc once to try to cancel the current operation. This may not work during every task, and it does not guarantee that a process has stopped.
- If the sheet responds, press Ctrl+S to save. On a Mac, use Command+S. Consider Save As and a new filename if the workbook is important or behaving unpredictably.
- If only one workbook is involved, note its location and whether it is stored on a network drive, removable disk, or cloud service. That can help distinguish an Excel issue from a file-access delay.
- If Excel stays frozen, use the troubleshooting steps below before ending the task, if possible.
On a Mac, the Windows “Not Responding” label and Safe Mode procedure do not apply in exactly the same way. If Excel is frozen, try Esc and give it time; if it cannot recover, use Apple menu > Force Quit or Activity Monitor to quit it. Force quitting can lose unsaved changes on either platform.
Check Whether Excel Is Busy
Some workbooks can keep Excel occupied without being broken. Volatile formulas, complex formulas across many rows, data tables, pivot refreshes, and links to external files can all add work. Large imports or queries can also take time, especially when the source is online or on a slow network. If the freeze happens consistently during one operation, that timing is useful evidence.
When Excel becomes usable, check the status bar and the Data tab for refresh activity. To inspect connections, select Data > Queries & Connections. If a query or connection is responsible, review its source and refresh settings rather than repeatedly opening and closing Excel. For a workbook with heavy formulas, you can temporarily choose Formulas > Calculation Options > Manual, then make a copy and investigate the formulas. Manual calculation can leave displayed results out of date; press F9 to recalculate, and restore Automatic when appropriate.
Be cautious with external links and macros. A workbook may wait for a linked file, prompt hidden behind another window, or run code when it opens. If a prompt seems missing, use Alt+Tab on Windows to check for another Excel or security dialog. Do not enable macros or trust a file just to make it open unless you know the source and expect that content.
Open Excel in Safe Mode
Safe Mode starts the Windows desktop version of Excel with many startup customizations and add-ins bypassed. It is a useful diagnostic test: if Excel behaves normally in Safe Mode, an add-in, startup file, or customization becomes more likely, though Safe Mode alone does not identify the exact cause.
- Close Excel if it is open. If it is stuck, first allow time for it to recover; force it closed only if necessary.
- Press Windows key+R to open Run, type
excel /safe, and press Enter. If Windows cannot find the command, open Excel from the Start menu while holding Ctrl and accept the Safe Mode prompt. - Try the action that caused the freeze, or open a copy of the affected workbook. Do not overwrite the original while diagnosing.
- If Safe Mode works, disable add-ins one at a time and restart Excel normally to identify whether one is responsible.
To review add-ins in normal Excel, use File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go; uncheck an add-in to disable it. Also check Excel Add-ins from the same Manage list. Restart Excel and test after each change. If the problem persists in Safe Mode, the workbook, Office installation, Windows, or another factor may be involved. Excel for Mac has different startup and add-in controls, so the Windows Safe Mode instructions should not be used there.
Find Out Whether the Workbook Is the Cause
Test Excel with a blank workbook. If a new blank workbook works but one particular file freezes, focus on that file or something it loads. If every workbook freezes, look instead at add-ins, Office updates, system resources, or the Excel installation. This simple comparison prevents unnecessary repairs to a workbook when the problem is broader.
For a suspect file, make a copy first. Try opening the copy from a local folder rather than a network or synced location, if you can do so safely. If it opens, compare behavior with the original location; a connection or sync delay may be part of the issue. You can also use Excel’s built-in repair option: select File > Open > Browse, select the workbook, choose the arrow beside the Open button, and select Open and Repair. Choose Repair first. If that does not work, Extract Data may recover values and formulas, but it may not preserve all workbook features or formatting.
Also check whether the workbook is unusually large or contains extensive formatting, many embedded objects, or formulas that refer to whole columns. These can affect responsiveness, but there is no single size limit that explains every freeze: available memory, workbook design, and the computer all matter. Avoid deleting content from the only copy as a test.
Update or Repair Microsoft 365
If Excel freezes with multiple workbooks, install available Office updates. In Excel for Microsoft 365 on Windows, go to File > Account > Update Options > Update Now. If Excel cannot stay open, use another Office app to reach its Account page, or restart Windows and try again. Update labels or availability can differ depending on how Microsoft 365 is managed by an organization.
If updating does not help, repair Office from Windows. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. In Windows 10, the corresponding list is generally under Settings > Apps > Apps & features. Quick Repair is the faster first option; Online Repair is more thorough and may take longer and require an internet connection. Save work and close Office apps before starting either repair. These steps repair the Office installation, not a damaged workbook.
Before repair, consider whether the computer is low on available memory or disk space, or whether a security tool or organization policy has recently changed. Do not disable security software as a routine fix. If this is a work-managed computer, ask the administrator before changing settings or repairing a managed Office installation.
Recover Unsaved Changes
After an unexpected close, reopen Excel and look for a Document Recovery pane. Open the most recent suitable version and save it under a new name. You can also check File > Info > Manage Workbook for a recovery option such as Recover Unsaved Workbooks. The exact options depend on whether Excel had an opportunity to create a recovery copy.
AutoRecover periodically saves recovery information, but it is not a substitute for saving. To check its settings, select File > Options > Save and review the AutoRecover interval and file location. AutoSave is different: it works with supported cloud-stored files, such as files in OneDrive or SharePoint, when the feature is available and turned on. Neither feature guarantees recovery of every last edit, especially if the file was never saved or the application closed before recovery information was written.
When you find a recovered version, compare it with the last saved file before replacing anything. For important workbooks, save regularly and keep a separate backup or version history where available. On a Mac, recovery options and their locations differ, so check the recovery prompt and Excel’s settings for that version rather than following Windows menu paths.
Reduce the Chance of Another Freeze
Prevention starts with narrowing down the trigger. If the problem recurs, note which workbook was open, what action was underway, where the file is stored, and whether Safe Mode changes the result. That record can help identify a particular add-in or data source instead of encouraging guesswork.
- Keep Microsoft 365 and Windows updated, subject to your organization’s update policies.
- Install add-ins only from sources you trust, and remove or disable ones you no longer use.
- Save important workbooks locally or to a reliable supported cloud location, and keep a separate backup for critical files.
- Reduce unnecessary formula complexity and refresh external data only when needed; test structural changes on a copy.
- Close unused programs if system resources are limited, and avoid running several large refreshes or calculations at once.
Excel for the web has different failure modes. If a browser tab appears stuck, check whether the network is working and whether other sites load. Refreshing the tab may discard unsaved browser state, so first allow time for syncing and check the file in OneDrive or SharePoint from another tab or device if appropriate. A browser refresh is not equivalent to repairing the Windows desktop app.
Frequently Asked Questions
Should I wait or force close Excel?
Wait if Excel may be calculating, loading, or refreshing and there is no urgent reason to stop it. If it remains unresponsive and does not recover, force closing may be necessary, but unsaved edits can be lost. Try recovery options when you reopen Excel.
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode is a troubleshooting option for desktop Excel on Windows; it is not the same procedure on Mac or Excel for the web.
Why does Excel freeze only with one file?
The file may contain complex calculations, external connections, damaged content, or features that take time to load. Test a copy, compare it with a blank workbook, and try Open and Repair before changing or replacing the original.
Will force quitting Excel recover my work?
Not necessarily. Excel may offer Document Recovery or an unsaved-workbook copy on restart, but recovery depends on what was saved and whether recovery data exists. Save often and treat recovered files as versions to compare, not guaranteed complete replacements.
Does AutoSave prevent data loss?
No. AutoSave can continuously save supported cloud files when enabled, but it does not guarantee that every change is stored in every situation. AutoRecover is a separate recovery feature, and regular saves and backups remain useful.
Related
- Excel Timesheet Format: Build a Reliable Weekly Sheet
- Excel Timesheet for Multiple Employees: Setup and Tips
- Excel Invoice Bill Format: Build a Useful Template
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Wrap Text in Google Sheets on Mac: A Step-by-Step GuideTo wrap text in Google Sheets on a Mac, select the cell or cells, then choose Format >…
- AVERAGEIFS in Google Sheets: Criteria and ExamplesIn Google Sheets, use AVERAGEIFS to average values that meet multiple conditions. With sales in C2:C100, regions in…
- How to Add a Header to One Page Only in Microsoft WordTo put a header on just one page in Word, isolate that page in its own section with…
- How to Screen Record a PowerPoint Presentation with AudioTo record a PowerPoint presentation with narration, open the deck and choose Record > From Beginning in PowerPoint…
- Transfers in Google Sheets: Move, Copy, and Import DataGoogle Sheets can transfer spreadsheet data by moving or copying cells, copying a whole sheet, or importing a…
- Google Sheets Budget Spreadsheet: Setup and FormulasA Google Sheets budget spreadsheet is a reusable table for recording income, planned spending, and actual spending, with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.