Excel Not Responding, Freezing or Crashing
Excel can show Not Responding while it finishes a long calculation or opens a large workbook, so give it time first. If Excel keeps crashing or freezing, start it in safe mode by holding Ctrl as you open it. If safe mode works, an add-in is the likely cause: turn add-ins off in File > Options > Add-ins.
Try these quick fixes first
- If the status bar shows Excel is busy, let it finish before you click anything.
- Close other workbooks and apps you aren’t using.
- Start Excel in safe mode: press Windows key+R, type
excel /safe, and select OK. - Turn off add-ins in File > Options > Add-ins.
- Update Office with File > Account > Update Options > Update Now.
- If only one workbook freezes, copy it to your PC and open the copy.
Give Excel time to finish before you end it
Excel may not respond while it’s busy, so letting the current task finish is the safest first step.
- Look at the status bar at the bottom of the window. Excel shows there when another process is using it.
- Stop clicking and typing until it finishes. Many formulas, data tables and links to other workbooks make calculation slower.
- A large workbook last saved in an older version of Excel opens slowly the first time, while Excel recalculates it. Save it, and it opens faster.
- If Excel stays frozen, you can end it, but changes you haven’t saved may be lost. Press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and select End task.
- Start Excel again. If the Document Recovery pane appears, save each recovered workbook under a new name. If it doesn’t, see how to recover an unsaved Excel file.
On a Mac, press Option+Command+Esc, select Microsoft Excel, and select Force Quit.
Start Excel in safe mode
Safe mode starts Excel without its startup files, custom toolbars and most add-ins, so if the problem disappears there, one of those is the cause.
- Close Excel completely.
- Press Windows key+R, type
excel /safe, and select OK. Or hold Ctrl while you double-click an Excel shortcut, then select Yes. - Open the workbook that was freezing and work as usual.
- If Excel runs normally, turn off add-ins (next section).
- If Excel won’t start even in safe mode, update and repair Office (below).
Safe mode is only for testing: recovered files don’t open automatically and preferences aren’t saved, so restart Excel normally when you’re done.
Turn off add-ins and COM add-ins
Add-ins load with Excel and can conflict with it, and turning them off, then back on one at a time, shows which one is to blame.
- Select File > Options > Add-ins.
- In the Manage box, select COM Add-ins, then Go.
- Clear every check box and select OK. Don’t select Remove, which deletes an add-in from your computer.
- Restart Excel normally. If the problem is gone, turn the add-ins back on one at a time, restarting Excel each time, until it returns.
- Repeat with Excel Add-ins in the Manage box.
- Also choose Disabled Items in the Manage box, then Go, to see what Excel has already switched off after a problem.
At work, turn company add-ins off only to test, and tell IT which one caused the trouble. On a Mac, select Tools > Excel Add-ins and clear the check boxes.
Slim down a large or heavily formatted workbook
Microsoft notes that Excel frequently hangs or crashes because of formatting problems, such as unused formatted cells, conditional formatting and hidden shapes.
- Save a backup copy of the workbook first.
- In Excel for Microsoft 365, select Review > Check Performance, then Optimize sheet or Optimize all. This strips formatting from cells that hold no data, so press Ctrl+Z if it removes colors you wanted.
- To test conditional formatting, save a test copy, open it, and select Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet on each sheet. If the copy runs normally, delete the rules you don’t need from your working file in Home > Conditional Formatting > Manage Rules.
- Select Home > Find & Select > Selection Pane to list a sheet’s shapes and pictures, including hidden ones, and delete those you don’t need.
- Change formulas that use entire columns, such as
A:A, to just the rows you use. - To check whether calculation is the problem, select Formulas > Calculation Options > Manual. If Excel speeds up, the formulas need work. Set it back to Automatic afterward, or results stop updating (see Excel formulas not calculating).
Test files from a network drive, SharePoint or OneDrive on your PC
Files opened over a network or from a web server can cause problems, so a local copy shows whether the file or its location is at fault.
- Close the workbook.
- Copy it to a folder on this PC. If your Desktop or Documents folder is stored on a server, ask IT which folder to use.
- Open the copy. If it runs normally, the problem is the connection or the location, not the workbook.
- Delete the test copy and keep working in the original, so your changes don’t end up in two places.
- If the workbook lives in OneDrive, check that it’s syncing. See our guide to OneDrive not syncing.
The same applies to redirected folders, offline files, and remote desktop or Citrix sessions.
Install Office updates
Updates replace out-of-date files, and recent Excel versions include fixes for slow PivotTable refreshes and workbooks with many shapes.
- In Excel, select File > Account.
- Under Product Information, select Update Options > Update Now. If you see Enable Updates first, select it.
- If there’s no Update Options button, only About, your company manages updates. Ask your IT team.
On a Mac, select Help > Check for Updates in Excel, then select Update.
Repair Office
A repair replaces damaged Office program files, one of Microsoft’s fixes for Excel hanging or freezing.
- This needs administrator rights. At work, ask your IT team.
- Save your work and close every Office app. The repair covers all of Office, not just Excel.
- Right-click Start and select Installed apps.
- Find Microsoft 365 or your Office version, select the three dots (…) next to it, and select Modify.
- Select Quick Repair > Repair.
- If Excel still freezes, repeat these steps and choose Online Repair, which Microsoft recommends to make sure everything gets fixed.
Is the workbook damaged? Use Open and Repair
If Excel keeps crashing with one workbook but not others, the file may be damaged, and Open and Repair recovers as much of it as it can.
- Start Excel, select File > Open, and Browse to the folder that holds the workbook.
- Select the workbook once, select the arrow next to Open, and select Open and Repair.
- Select Repair. If Excel can’t repair it, select Extract Data to recover its values and formulas.
- Save the result as a new file, so the original stays untouched.
- If the workbook only freezes while it opens, open a blank workbook, select Formulas > Calculation Options > Manual, then open the file. Excel won’t recalculate it, so it may open. Set calculation back to Automatic when you’re done.
If repair doesn’t work, you may be able to restore a previous version of the Excel file.
Why does this happen?
- A long calculation, or a large workbook opening for the first time in a newer version of Excel.
- An add-in that conflicts with Excel.
- Excess formatting, conditional formatting rules, hidden shapes or whole-column formulas.
- A file opened over a network, from SharePoint or in a remote desktop session.
- Out-of-date or damaged Office program files.
- A damaged workbook, or too little free memory.
When should you call IT?
- Excel crashes even in safe mode, won’t start, or still crashes with add-ins off. IT can check its startup folders and run a clean boot to find a conflicting program.
- Office needs a repair and you don’t have administrator rights, or your company manages updates.
- The add-in at fault belongs to your company or to your security software. Don’t turn security software off yourself.
- Several people have the same problem with files on the same server or SharePoint site.
- Large workbooks keep running out of memory. Microsoft suggests the 64-bit version of Excel or more memory.
- A workbook that billing, payroll or reporting depends on won’t open or repair.
If shared workbooks freeze for your whole team, see our Microsoft 365 support page.
OAC Technology’s IT support team fixes problems like this for businesses across the Twin Cities. Clients can call 952-548-5558, Monday to Friday, 8 a.m. to 6 p.m. Central. Not a client yet? Call the same number or send us a message.
Common questions
Why is my Excel not responding?
It may be busy with a long calculation or a large file, an add-in may conflict with it, or a file may be opening slowly over a network. If every workbook freezes, test safe mode and add-ins. If only one does, fix that file.
How do I save Excel when it’s not responding?
You can’t save until Excel responds, so wait for it, then press Ctrl+S right away. If you have to end Excel, start it again and check the Document Recovery pane. AutoRecover saves a copy every 10 minutes by default.
How long should you wait when Excel is not responding?
There’s no set time. Large workbooks and files on a network can take a while, so wait as long as the status bar shows Excel is busy. If nothing changes and other apps work normally, end Excel in Task Manager.
How do I fix Excel not responding without closing it?
Stop clicking and let the current task finish, because Excel may not respond while it’s busy. Closing apps you don’t need frees up memory. If it stays frozen, end it in Task Manager.









