Excel Not Responding? Fix Freezes, Crashes and Excel Won’t Open

When the title bar says (Not Responding), Excel is busy or stuck: recalculating a heavy workbook, waiting on a server or cloud folder, or held up by an add-in. When it crashes or won’t open at all, the usual causes are an add-in, a file Excel loads at startup, or a damaged Office install.

A blank workbook splits the problem in seconds. Close Excel, start it from the Start menu and choose Blank workbook. If a blank workbook behaves, the trouble is one file or where it’s stored. If Excel freezes or crashes with nothing open, the problem is Excel itself or something that loads with it.

Before forcing anything closed, check the status bar at the bottom of the window: Microsoft warns that doing other things while Excel is calculating, saving or refreshing data can make it stop responding.

Is it one workbook or Excel itself?

For the empty grey window, go to View > Unhide and pick the workbook. If File > Open inside Excel works but double-clicking doesn’t, right-click the file, choose Properties and use Change next to Opens with to pick Excel.

If the whole computer locks up, not just Excel, look at the PC first; see why a computer keeps freezing.

Start Excel in safe mode to rule out add-ins

Safe mode starts Excel without Excel add-ins, most COM add-ins, toolbar customizations and the files it normally opens at startup. If Excel is stable in safe mode, one of those is your problem.

Close Excel first. Then either hold Ctrl while you double-click the Excel shortcut and click Yes when asked about safe mode, or press Windows key + R, type excel /safe and click OK. To leave safe mode, restart Excel normally.

Turn off COM add-ins and Excel add-ins

1. Go to File > Options > Add-ins.
2. In the Manage box at the bottom, choose COM Add-ins and click Go.
3. Note which boxes are ticked, untick them all and click OK.
4. Restart Excel normally. If it behaves, tick the add-ins back one at a time, restarting after each, until the freeze returns.

If an add-in won’t stay unticked or needs an administrator, it’s likely installed for everyone on the PC; ask whoever runs your IT.

Run the same test with Excel Add-ins chosen in the Manage box. Frequent offenders are add-ins bundled with PDF software, accounting and reporting exports, and security products. Update the guilty add-in or ask its vendor for a fixed version.

Empty the startup folders

Every workbook in Excel’s XLStart folder, or in an alternate startup folder, opens each time Excel starts. XLStart’s path is under File > Options > Trust Center > Trust Center Settings > Trusted Locations. The alternate folder is under File > Options > Advanced > General, in the At startup, open all files in box. Move the files elsewhere, restart Excel, then return them one by one.

Check Disabled Items

After a crash, Excel sometimes offers to switch off the part that failed. To see what it disabled, go to File > Options > Add-ins, pick Disabled Items in the Manage box and click Go. Re-enable an item only after updating the program it belongs to, or it may crash again.

When one workbook freezes Excel

Make a copy of the file before trying anything below.

Open it with calculation set to Manual

A workbook that recalculates for minutes looks exactly like a frozen one. Microsoft’s workaround is to switch calculation off before the file loads: open a blank workbook, go to File > Options > Formulas, choose Manual under Calculation options, click OK, and only then open the problem file. Press F9 whenever you want the totals updated.

Set it back afterwards under Formulas > Calculation Options > Automatic, or formulas stop updating on their own and people read stale totals.

Find what makes it heavy

The usual causes, most on Microsoft’s own list:

• Whole-column references such as A:A inside array formulas and SUMPRODUCT, which make Excel calculate over a million rows, empty ones included. SUM and SUMIF stop at the last used row, so they matter less.
• Volatile functions. NOW, TODAY, RANDBETWEEN, OFFSET and INDIRECT recalculate, along with everything that depends on them, every time Excel calculates anything.
• Formatting and styles. Conditional formatting stretched over entire columns, and thousands of cell styles carried in by copying between workbooks. Review rules under Home > Conditional Formatting > Manage Rules. To find formatting that runs past your data, press Ctrl + End; if Excel jumps far beyond your last real entry, select the empty rows and columns in between, choose Home > Clear > Clear All, then save, close and reopen. Enterprise editions of Microsoft 365 Apps also have Clean Excess Cell Formatting on the Inquire tab, which can’t be undone.
• Hidden clutter. Thousands of hidden or zero-size shapes, and long lists of broken defined names.
• Queries set to refresh on open. If a query or PivotTable pulls from a database, SharePoint list or another file that’s slow or unreachable, Excel waits each time the workbook opens. Go to Data > Queries & Connections, right-click the connection on the Connections tab, choose Properties and on the Usage tab untick Refresh data when opening the file.
• Links to other workbooks. A link to a file on a server you can’t reach, or on a former employee’s PC, can stall opening. In current versions open Data > Queries & Connections > Workbook Links; older versions call it Edit Links. Breaking a link replaces those formulas with their current values and can’t be undone.

Repair a damaged file

Go to File > Open, browse to the workbook and select it, click the arrow beside the Open button and choose Open and Repair, then Repair. If that fails, repeat it and choose Extract Data to rescue values and formulas.

Files on network drives, SharePoint and OneDrive

For a workbook on a server, a mapped drive, SharePoint or a NAS, or opened in a Remote Desktop or Citrix session, the test is simple: copy it to your desktop and open the copy.

• The copy is fast. The file is fine and the connection is slow: a mapped drive that keeps dropping, a struggling VPN or Wi-Fi link, or a busy NAS. Our guide to a network drive not showing up or disconnecting covers the drive side.
• The copy is just as slow. The problem travels with the file; go back to the previous section.
• A OneDrive or SharePoint file hangs at open. An online-only file has to download before Excel can show it, and a paused or failing sync app can leave Excel waiting. Check the OneDrive cloud icon, and see OneDrive not syncing if it shows an error.

Don’t keep working in the desktop copy, or the team ends up with two versions.

Printer and display drivers can stall Excel

Microsoft calls Excel printer-intensive: a broken driver, or a default printer that’s offline or no longer exists, can slow every file you open. To test, make Microsoft Print to PDF the default printer. In Windows 11, go to Settings > Bluetooth & devices > Printers & scanners, turn off Let Windows manage my default printer, then select the printer and click Set as default. If files now open quickly, update or reinstall the real printer’s driver from the manufacturer.

Excel also runs slower when workbooks are saved in Page Break Preview, so switch to View > Normal and save. If the screen flickers or redraws slowly too, install the latest graphics driver from the PC or graphics-card maker.

Update or repair Office

Install the latest updates

In Excel, go to File > Account > Update Options > Update Now, clicking Enable Updates first if it’s offered. If you see only an About button, your organization manages Office updates centrally, so ask whoever runs your IT. Do this early: Microsoft says versions 2503 and later include fixes for PivotTable refresh performance and shape loading.

Repair the installation

Close every Office app, right-click the Start button, open Installed apps and find Microsoft 365 or your Office version. Its … menu has a Modify option, which on most installs offers two repairs (older volume-licensed MSI installs show a single Repair option instead). Quick Repair works offline and only finds and replaces damaged files. Online Repair is more thorough but downloads files and takes longer. Try Quick first. On Windows 10, look under Apps and Features instead.

Rule out background software

If Excel misbehaves on only one PC, a background program may be interfering; Microsoft suggests a clean boot (a selective startup from System Configuration) to find it. A clean boot needs an administrator account and can switch off third-party antivirus, VPN and backup tools, so on a work PC ask whoever runs your IT first. Tick Hide all Microsoft services before Disable all, and when you finish choose Normal startup on the General tab, re-enable the startup apps you turned off in Task Manager and restart.

If your antivirus plugs into Excel, update it and ask the vendor for a fixed version or a supported way to turn off its Excel integration. Don’t exclude Excel from scanning or switch protection off: Microsoft warns that changing antivirus settings can leave a PC open to attack.

Get your work back after a crash

Excel’s AutoRecover saves a recovery copy in the background, every 10 minutes by default. When you reopen Excel after a crash, look for the Document Recovery pane and open the newest version listed. Save it under a new name until you’ve compared it with the original.

• A file you’d saved before: open it, go to File > Info > Manage Workbook, open the newest version listed and use Save As to keep it under a new name. The Restore button in the bar at the top overwrites your saved file, so click it only once you’re sure.
• A file you never saved: go to File > Info > Manage Workbook > Recover Unsaved Workbooks, open it and save it straight away.
• A file in OneDrive or SharePoint Online: AutoSave keeps saving as you type (it doesn’t work in older .xls files), and File > Info > Version History lists earlier versions you can open or restore.

If the pane doesn’t appear, copy the AutoRecover file location from File > Options > Save and open that folder in File Explorer. On the same page, lower the Save AutoRecover information every minutes and tick Keep the last autorecovered version if I close without saving.

Admin checks, and when it is the PC

Several people with the same Excel problem on the same day point to something shared:

• A known bug. Microsoft keeps a page called Fixes or workarounds for recent issues in Excel for Windows listing crashes and freezes with their fix status. Also look at Health > Service health in the Microsoft 365 admin center.
• A shared add-in. Office add-ins deployed centrally are managed in the Microsoft 365 admin center under Settings > Integrated apps. COM add-ins installed by other software are updated or removed through whatever installed them, such as Intune.
• Mismatched builds. Compare File > Account > About Excel on a working PC and a broken one; it shows the version and whether Office is 32-bit or 64-bit.

If you’d rather someone else handled Microsoft 365 users, password resets and security setup, see Microsoft 365 management.

Signs it’s the computer, not Excel

• Every file is slow and Task Manager shows memory or disk near 100%, often a sign the PC needs more RAM.
• Other programs freeze too, or the PC restarts on its own.
• Files on one drive won’t open or copy, or the drive clicks. Copy what you can elsewhere and stop using it.

If you’d rather not work through this yourself, Excel crashing or freezing on one PC is a typical $59 remote fix: with your approval, a technician connects through our remote computer help and works through these checks while you watch, and you can end the session at any time.

Common questions

How long should I wait when Excel says Not Responding?

If the status bar shows a calculation, save or data refresh in progress, give it a few minutes, longer for a big workbook on a network drive or in OneDrive. Clicking around doesn’t speed it up. Low CPU alone doesn’t prove Excel is stuck, because waiting on a slow network or cloud file uses almost none. If Task Manager’s Processes tab shows Excel with no CPU, disk or network activity for several minutes, ending the task is reasonable.

Will I lose my changes if I end Excel in Task Manager?

You lose anything typed since your last save or AutoRecover snapshot, though OneDrive or SharePoint files with AutoSave on are usually saved to the last few seconds. Before ending it, try Esc: it stops a data refresh and usually interrupts a running macro, as does Ctrl + Break (choose End when Excel says code execution has been interrupted; changes the macro already made stay). Afterwards, reopen Excel and check Document Recovery before opening the original.

Is it safe to turn off all my Excel add-ins?

For a test, yes. Unticking an add-in in the COM Add-ins or Excel Add-ins list only stops it loading; nothing is uninstalled. Until you tick it again you lose its buttons, such as an accounting export or a PDF tab, and any functions it adds can show #NAME?, so don’t save workbooks that use them while it’s off. Use the checkboxes rather than Remove, note which were on, and turn security or document-management add-ins back on when you finish.

Why does Excel freeze when I copy and paste between workbooks?

Ordinary pasting brings formatting and cell styles along with the data, and repeated copying between workbooks can pile up thousands of styles, which Microsoft lists as a cause of hangs. When you only need the numbers, click the arrow under Home > Paste and, under Paste Values, choose Values. Pasting into a workbook full of conditional formatting or volatile formulas also triggers a long recalculation each time.

Will 64-bit Excel stop crashes with very large files?

It can when the real problem is memory, because 32-bit Office can use far less memory than 64-bit Office, so huge workbooks run out of room sooner. Check File > Account > About Excel to see which you have. Switching means reinstalling Office, and some older add-ins only come in 32-bit versions, so confirm with your add-in vendors before changing.

Why does a workbook open fine in Excel for the web but not on my PC?

Excel for the web doesn’t load your computer’s COM add-ins, startup folders or local Office install. If a OneDrive or SharePoint workbook opens normally in the browser but hangs in the desktop app, the fault is most likely on the computer: an add-in, the sync app or the Office install. The browser doesn’t run VBA macros, though, so a macro that runs when the workbook opens can still be the cause. Either way, the browser lets you keep working while you fix the desktop app.