Excel Slow and Hanging Fix Complete Step by Step Guide
Excel freezes, types with a lag or shows Not Responding — while your CPU, RAM and disk all look perfectly normal. In most cases the problem is not your PC. It is one heavy file, one bad add-in, or one wrong setting. This guide fixes them in the right order.
✍️ Technical Anshu🪟 Windows 10 / 11⏱️ 10 minute read
🎥 Full troubleshooting in the video — how to tell a system problem from a file problem, live
Here is the first thing a technician checks, and most people skip it: does the whole PC freeze, or only Excel — and if only Excel, only one file or every file? That single answer decides the whole repair path. If other programs freeze too, you have a Windows or hardware problem. If a blank new workbook opens fast but your regular file crawls, the file itself is heavy — usually from too many formulas, full-sheet colour formatting, or tables formatted down to the last row. Work through the fixes below in order; each one is cheap, and the honest truth is that most slow-Excel cases end at Fix 2 or Fix 3.
Microsoft Excel — Task Manager check
Processes CPU Memory Disk
Microsoft Excel 24% 812 MB 0 MB/s
Antimalware 2% 210 MB 0 MB/s
CPU, RAM and disk all normal — yet Excel is frozen.Microsoft Excel (Not Responding)
When the PC is healthy but Excel alone hangs, the cause sits inside Excel or inside the file — not in your hardware.
1
Step Zero — Decide Whether It Is the System, Excel or One File
Never start changing settings blindly. Spend two minutes on this diagnosis first, exactly like the video shows.
Open a blank workbook. If a blank file is also slow, the problem is Excel itself or an add-in — jump to Fix 2
If the blank file is fast but your regular file is slow, the problem lives inside that file — Fix 3, Fix 4 and Fix 5 are yours
Press Ctrl + Shift + Esc and watch CPU, Memory and Disk. If they sit near 100% even when you do nothing, another program or a failing disk is the real culprit
2
Start Excel in Safe Mode and Kill the Bad Add-In
Add-ins are the single most common reason Excel hangs on startup or freezes while typing. Safe Mode starts Excel with every add-in switched off — a perfect split-test.
Press Windows + R, type excel /safe and press Enter
If Excel runs smoothly now, an add-in is guilty. Close Excel and start it normally
Go to File → Options → Add-ins, choose COM Add-ins at the bottom and click Go
Untick everything, restart Excel, then enable add-ins one at a time until the freeze returns — the last one enabled is your problem
3
Turn Calculation to Manual While You Edit Heavy Files
With automatic calculation on, every single edit forces Excel to recalculate the whole dependency chain. In a file with thousands of formulas, one keystroke can mean a ten-second wait.
Go to Formulas → Calculation Options → Manual
Now type and edit freely — nothing recalculates while you work
Press F9 whenever you want fresh results, or Shift + F9 for the current sheet only
Set it back to Automatic before sharing the file, so nobody reads stale numbers
Be honest with yourself though: Manual mode hides the pain, it does not remove it. If a file needs this permanently, the formulas themselves need fixing — see Fix 4.
4
Hunt Down Volatile Functions and Whole-Column References
Two formula habits silently destroy performance. Volatile functions — NOW(), TODAY(), INDIRECT(), OFFSET(), RAND() — recalculate on every change anywhere, even changes that have nothing to do with them. And a reference like =SUM(A:A) makes Excel scan over a million rows for every formula that uses it.
Press Ctrl + F and search for INDIRECT, OFFSET and NOW to find the worst offenders
Replace whole-column ranges with the real data range, for example =SUM(A2:A5000)
Better still, convert the data to an Excel Table (Ctrl + T) so ranges grow automatically without covering empty rows
5
Cut the Formatting Bloat — the Silent File Killer
This is the cause the video demonstrates with a 30 MB file: users select entire columns or sheets and apply colours, borders and table styles. Excel then stores formatting for hundreds of thousands of empty cells, and the file becomes heavy forever.
Press Ctrl + End in each sheet. If it jumps far beyond your real data, Excel believes the sheet is huge
Select the rows below your data down to that point, right-click and choose Delete — not just Clear Contents
Do the same for unused columns on the right, then open Home → Conditional Formatting → Manage Rules and delete rules that apply to giant or duplicated ranges
Save the file and compare the size — bloated files often shrink from tens of MB to under 1 MB
6
Update Office, Repair It, and Check the Printer Driver
Three finishing checks catch most of what is left. An outdated Office build can carry bugs that Microsoft has already fixed, and a corrupt Office install can be repaired without losing a single file.
In Excel go to File → Account → Update Options → Update Now
For a repair: Settings → Apps → Installed apps → Microsoft Office → Modify, run Quick Repair first, then Online Repair if needed
Test with a different default printer — temporarily set Microsoft Print to PDF as default. If the freezing stops, your printer driver was the cause; Excel talks to it for page layout far more than people realise
Finally, go to File → Options → Advanced and tick Disable hardware graphics acceleration if the screen flickers or lags while scrolling on an old PC
🔴 Honest limit: no setting can make a genuinely huge model fast. If your workbook holds lakhs of rows of live formulas, the real fixes are better formulas, splitting the data, or Power Query and PivotTables instead of cell-by-cell calculations. The fixes above remove the avoidable slowness — which, in practice, is most of it.
🎥 Watch the Complete Fix in the Video
The video walks through this same diagnosis live — system check first, then the heavy-file fixes, exactly in this order.
Because Excel slowness is usually a single-thread calculation or file problem, not a hardware problem. One volatile formula chain, a bloated formatted range or a bad add-in can freeze Excel while the rest of the PC idles. That is why the diagnosis starts with a blank workbook test, not with buying RAM.
Will switching calculation to Manual damage my file?
No. Manual calculation only stops automatic recalculation while you edit. Your formulas stay intact — press F9 to recalculate everything. The only risk is human: forgetting to recalculate before reading or sharing the numbers, so switch back to Automatic when you finish heavy editing.
My Excel file is 30 MB but has very little data. Why?
Almost always formatting bloat. Colour, borders or table styles applied to entire rows and columns get stored for every cell, and conditional formatting rules pile up over years of copy-paste. Reset the used range with the Ctrl+End test in Fix 5 and the same file often drops below 1 MB.
This guide is based on the Technical Anshu Excel troubleshooting video • Stuck on a step? Ask in the video comments — you will get an answer there 🙏