You click a cell, type a formula, and Excel just stops. The window dims, the title bar reads "Not Responding," and the spinning cursor refuses to go away. Sometimes it recovers after a few seconds; sometimes you lose work.
The good news: most freezes trace back to a short list of known causes, and you can rule them out quickly. The single most common culprit Microsoft directs you to test first is an interfering add-in, which is why Safe Mode is the fastest diagnostic.
Work through these fixes in order. The quickest and most likely solutions come first, so you can often stop before reaching the end. Before you force anything closed, though, do one thing.
Check the Status Bar Before You Force-Close Anything
What looks like a frozen Excel is often a long-running calculation or save still in progress. Watch the status bar at the bottom of the Excel window for an in-progress operation indicator.
Let any running task finish before clicking elsewhere. Clicking repeatedly during a heavy recalculation can be what tips a busy workbook into a true "Not Responding" state.
Open Excel in Safe Mode to Isolate Add-ins
Safe Mode launches Excel with COM add-ins, Excel add-ins, the alternate startup location, changed toolbars, and the XLStart folder all bypassed. If Excel behaves in Safe Mode, you have your answer: the problem is an add-in, startup file, or customization.
- 1.Press Windows key + R to open the Run box (or go to Start > All apps > Windows System > Run).
- 2.Type Excel /safe and press Enter.
- 3.Test the action that was freezing.
If Excel works correctly here, continue to the add-in and startup steps below. If it still freezes, the problem is broader (file, install, or system), so skip ahead to repair and storage fixes. Microsoft also offers an automated Support and Recovery Assistant (SaRA) crash troubleshooter that disables add-ins, moves startup-folder files, and renames custom toolbar files for you; it requires Windows 10 or higher.
One caution: hardware graphics acceleration is always disabled in Safe Mode. So if a problem vanishes in Safe Mode, it could be a GPU or display-driver issue rather than an add-in. Keep that in mind as you test.
Disable COM Add-ins
If Safe Mode fixed things, COM add-ins are the first suspects.
- 1.Go to File > Options > Add-ins.
- 2.In the Manage dropdown at the bottom, select COM Add-ins, then click Go.
- 3.Clear all the checkboxes, then click OK.
- 4.Close and restart Excel in normal mode.
If the freezing stops, re-enable add-ins one at a time, restarting Excel between each, until the offending one reappears. Then leave that one disabled or seek an updated version from its maker.
Disable Excel Add-ins in the Registry
Some Excel and XLL add-ins load through the registry rather than the COM list. Back up the registry before editing.
- 1.Press Windows key + R, type regedit.exe, and click OK.
- 2.Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\<1x.0>\Excel\Options, where <1x.0> is your Office version number.
- 3.Look for REG_SZ values named OPEN (and OPEN1, OPEN2, and so on).
- 4.Right-click OPEN and rename it to RenamedOPEN; repeat for any numbered keys.
- 5.Start Excel in normal mode and test.
To re-enable an add-in later, remove the "Renamed" prefix you added to its key.
Check the XLStart and Alternate Startup Folders
Files in these folders load automatically every time Excel opens, and a single bad workbook there can hang the whole program.
For XLStart, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations and note the XLStart folder path. For the alternate location, go to File > Options > Advanced, and under General find the field labeled "At startup, open all files in" and note its path.
Move the files out of these folders to another location, then start Excel in normal mode. If it works, move the files back one by one to identify the problematic workbook.
Install the Latest Office and Windows Updates
A recent build sometimes introduces a regression, and Microsoft ships per-build fixes for issues like PivotTable refresh, freeze panes, shape loading, and worksheet switching. Updating often corrects freezes by replacing out-of-date files.
- 1.Update Office: in any Office app, go to File > Account > Update Options > Update Now.
- 2.Update Windows: press Windows key + I, then go to Update & Security > Windows Update > Check for updates (Windows 10) or Settings > Windows Update (Windows 11).
Disable Hardware Graphics Acceleration
Office 2013 and later use hardware acceleration to draw the interface, and an incompatible video card or driver can cause crashes, blurriness, flicker, or reduced performance. This is a strong suspect if the problem disappeared in Safe Mode but was not an add-in.
- 1.Go to File > Options > Advanced.
- 2.Scroll to the Display group.
- 3.Turn on the option to disable hardware graphics acceleration, then click OK and restart Excel.
On the same path, also update your video driver through Windows Update or the GPU vendor's site, since an out-of-date display driver is a common root cause. Note that Office silently auto-disables acceleration for certain known-bad card and driver combinations, so behavior can differ between two PCs without any warning.
Set Calculation to Manual for Heavy Workbooks
In a workbook with many or complex formulas, automatic recalculation on every change can cause hangs.
- 1.Go to the Formulas tab.
- 2.Click Calculation Options.
- 3.Select Manual.
Press F9 to recalculate when you are ready. (The same setting is also reachable via File > Options > Formulas.) While you are here, hunt down the structural performance killers Microsoft flags: formulas that reference entire columns, array formulas referencing an uneven number of elements, hundreds or thousands of hidden objects, excessive cell styles built up from repeated copy and paste, large numbers of invalid defined names, and large numbers of geometric shapes or complex objects. Remove or simplify these, or rebuild the affected sheet.
Repair the Office Installation
If freezing persists across workbooks, the installation itself may be corrupted. Repair affects the entire Office suite, so close all Office apps first.
- 1.Windows 11: right-click Start, select Installed apps, find your Microsoft 365 or Office product, click the ellipsis (...), and select Modify.
- 2.Windows 10: right-click Start, select Apps and Features, select the product, and click Modify.
- 3.For a Click-to-Run install, choose Online Repair then Repair; for an MSI-based install, choose Repair then Continue.
Try Quick Repair first, since it is faster and only detects and replaces corrupted files. If the problem persists, run Online Repair, which is more comprehensive but requires an internet connection.
Rule Out the File, Its Location, and a Corrupt Workbook
Hangs can come from where a file lives, not the file itself. Copy the workbook to a local drive such as the Desktop and open it there. Freezes commonly occur when files are opened or saved over a network share, web server, WebFolder, SharePoint, or in Remote Desktop, Citrix, or virtualized environments. If the local copy is fine, the storage location is the culprit.
If a specific workbook is corrupt, use Open and Repair:
- 1.Click File > Open and browse to the folder containing the workbook (do not open it directly).
- 2.Select the corrupted workbook in the Open dialog.
- 3.Click the arrow next to the Open button, then click Open and Repair.
- 4.Click Repair to recover as much data as possible. If Repair fails, reopen and choose Extract Data.
Excel is also printer-intensive, and saving in Page Break Preview view specifically makes it run slower. An incompatible default printer driver can cause hangs too, so testing a different printer or video driver helps pinpoint that cause.
Check Antivirus and Conflicting Background Software
Out-of-date antivirus, or its Office integration, can interfere with Excel. Make sure your antivirus is current, disable any Excel or Office integration features in it, and disable any antivirus add-ins installed inside Excel. Microsoft warns that changing antivirus settings can leave your PC vulnerable to malicious attacks, so re-enable protection after testing.
To find other conflicting programs, use System Configuration to perform a Selective Startup (clean boot) on Windows, which disables third-party startup programs and services. Restart, test Excel, and if it works, re-enable items in groups to identify the conflict. Specific known offenders include the 3DxWare 10 PlugIn for 3Dconnexion devices (version 10.8.7 or earlier), the new IME on Windows 11, and clipboard automation across multiple Excel instances; update or disable the relevant component. On Mac, keep Excel updated, since recent builds resolve a documented "Save as Picture" crash.
Frequently Asked Questions
Why does Excel freeze only when I open one specific file?
That points to either a corrupt workbook or its storage location. Copy the file to a local drive and try opening it there; if it opens fine locally, the network, SharePoint, or virtualized location is the issue. If it still hangs locally, use File > Open > the arrow next to Open > Open and Repair, and choose Extract Data if Repair cannot fix it.
Excel works in Safe Mode but not normally. What does that mean?
Usually an add-in, startup file, or customization is to blame, since Safe Mode bypasses all of them. Disable your COM add-ins, then re-enable them one at a time to find the culprit. Remember, though, that Safe Mode also disables hardware graphics acceleration, so a GPU or display-driver problem can also "disappear" in Safe Mode.
What is the difference between Quick Repair and Online Repair?
Quick Repair is faster and only detects and replaces corrupted files, with no internet needed. Online Repair is more comprehensive and ensures everything gets fixed, but it requires an internet connection. Try Quick Repair first and move to Online Repair only if the problem persists. Both repair the entire Office suite, so close all Office apps first.
Will setting calculation to Manual cause errors in my results?
No, your formulas stay intact; Excel just stops recalculating automatically on every change. This prevents hangs in workbooks with many or complex formulas. Press F9 whenever you want to update the results.
Is it safe to disable my antivirus to test Excel?
Microsoft notes that changing antivirus settings can leave your PC vulnerable to viral, fraudulent, or malicious attacks. If you disable antivirus integration or add-ins to test, re-enable that protection as soon as you finish. A safer first move is simply updating the antivirus to its latest version.
How do I re-enable an add-in I disabled in the registry?
Go back to HKEY_CURRENT_USER\Software\Microsoft\Office\<1x.0>\Excel\Options and remove the "Renamed" prefix you added, so RenamedOPEN becomes OPEN again. Back up the registry before making changes, and restart Excel to confirm the add-in loads without freezing.
