Excel is slow: 7 hidden settings that actually fix it

A client emailed me last month convinced her Excel install was dying. Her workbook — 380 rows, eight columns, no macros — took fourteen seconds to open. Every keystroke had this little quarter-second hiccup before showing up. She was about to buy a new laptop. The laptop was a year-old Dell with 32 GB of RAM.

Yeah. It wasn't the laptop.

Excel slowness is almost always settings, not files, not hardware. The catch is that the relevant settings are scattered across at least four different menus and most of them ship with defaults that aren't great for modern setups. Here's the seven that matter, in roughly the order I work through them.

1. Hardware graphics acceleration (turn it OFF)

This is the single biggest fix on modern laptops. Especially anything with integrated graphics and an external monitor. Doubly especially anything with hybrid Intel/NVIDIA graphics, like most ThinkPads and XPS machines from the last three years.

Excel uses GPU acceleration for animation, scrolling, and chart rendering. Sounds great in theory. In practice, on hybrid-graphics laptops, this means Excel and the OS spend most of their time arguing about which GPU should be drawing the screen. Net result: micro-stutters every few hundred milliseconds. You feel them as a sluggish UI.

How to kill it

File → Options → Advanced. Scroll down to the Display section.
Tick Disable hardware graphics acceleration.
OK. Restart Excel.

You should see scrolling smooth out immediately. Sheet-switching becomes instant. Chart updates stop freezing the whole app. If somehow it gets worse (rare, but it happens on a few weird old machines), untick it and restart again.

I'd say this fix alone solves about 40% of the "Excel is slow" calls I take. It's free. Do it first.

2. COM add-ins, the silent killer

Every "free" Excel add-in you ever installed registers itself as a COM add-in and loads at startup. PDF tools. Accounting integrations. Send-to-CRM buttons. Screen-clip utilities. That Adobe thing you don't remember installing. Each one adds 200ms to 2 seconds of startup, and most of them hook into events on every cell change.

I once audited a sales manager's Excel and found seventeen COM add-ins, only three of which she actually used. Removing the other fourteen took startup from twenty-two seconds to four.

Audit them

File → Options → Add-ins.
At the bottom, set Manage to COM Add-ins and click Go.
Untick anything you don't actively use. If you don't recognise it, untick it. You can always re-enable later from this same menu.
OK. Restart Excel.
Repeat for Excel Add-ins and Disabled Items in the same dropdown.

Notorious offenders I see over and over: anything from Adobe Acrobat, Citrix Workspace, OneNote linked notes, old versions of Power BI, and antivirus that "scans" every cell change. (Yes, that's a thing. Yes, it's as bad as it sounds.) These can each multiply Excel's CPU load by 3 to 5x on their own.

3. Conditional formatting rules quietly multiplying

Conditional formatting is fine in moderation. The problem is that copy-paste duplicates the rule rather than extending the existing one. So a sheet that started life with three rules can — after six months of normal editing — end up with four thousand redundant rules. Each one of which re-evaluates on every single cell change.

I've seen this turn a 200 KB workbook into a 12 MB monster that takes 30 seconds to open and freezes for two seconds on every edit.

Audit and prune

Select the entire used range (Ctrl+A twice).
Home → Conditional Formatting → Manage Rules.
Set Show formatting rules for to This Worksheet.
Look at the count. More than about 20 rules and you didn't intentionally make 20? You have rule bloat.
Delete the redundant rules. Re-apply a single clean rule across the full range you want.

Genuinely. This one fix has rescued more dying workbooks for me than anything else on the list.

4. The calculation engine cranking on every keystroke

Excel by default recalculates the whole workbook every time anything changes. Add a circular reference in there — a formula that refers back to itself, directly or via a chain of cells — and Excel will iterate trying to converge on a value, on every keystroke.

Find and fix

Formulas → Error Checking → Circular References. Excel lists every cell that has one. Even one is too many for performance.
Fix the formulas. Or, if you intentionally want circular references (rare — some financial models legitimately need them), go to File → Options → Formulas and tick Enable iterative calculation with a sane Maximum Iterations value. 100 is the default.

For workbooks where you're doing heavy data entry and you don't need formulas to recalc on every keystroke:

Formulas → Calculation Options → Manual.
Hit F9 when you actually want results.

This is night-and-day on data-entry-heavy sheets. I had a client who was entering 800 rows of expenses by hand, and Excel was taking half a second to reflect each one. Switching to manual cut her data entry time roughly in half.

5. Used range bloat (Ctrl+End landing in row 1,048,576)

Press Ctrl+End in any sheet. It should land somewhere near the bottom-right of your actual data. If instead it jumps to row 1,048,576 or column XFD, Excel believes your sheet is enormous. Even if you only see 100 rows of data.

This happens when:

Someone formatted entire columns ("apply this currency format to column F") instead of just the data range.
A row got deleted but its formatting wasn't cleared.
A pasted block left invisible formatting trails outside the visible data.
You typed something in cell ZZ50000 and then deleted it. The "used range" remembers.

How to fix

Click the row number for the first empty row below your real data.
Press Ctrl+Shift+End to extend selection to Excel's perceived used range.
Right-click → Delete → whole rows.
Same for columns: select the first empty column to the right of your data, Ctrl+Shift+End, delete entire columns.
Save the file. This step is critical. The used range only resets after a save.
Press Ctrl+End again. It should land at the real edge of your data now.

I had a workbook last spring that was 4.2 MB. After this procedure: 78 KB. Same data. The other 4.1 MB was empty rows full of formatting nobody could see.

6. Volatile functions recalculating constantly

Six built-in Excel functions are volatile. Meaning they recalculate every time anything anywhere in the workbook changes — not just when their own inputs change:

NOW()
TODAY()
RAND() and RANDBETWEEN()
INDIRECT()
OFFSET()
CELL() and INFO() (in some modes)

A workbook with 5,000 cells using INDIRECT or OFFSET will lag on every single edit because all 5,000 cells re-evaluate every time you press a key. Doesn't matter what key. Spacebar. Arrow key. Anything.

Replace them where you can

INDIRECT("Sheet1!A1") for cross-sheet references → just use the direct ref Sheet1!A1 if the sheet name doesn't change.
OFFSET(A1, 0, 0, COUNTA(A:A), 1) for dynamic ranges → use a structured table reference (Table1[Column]) or, in Microsoft 365, a spilled array reference like A1#.
NOW() updating constantly when you only wanted a timestamp at the moment of an event — use a small macro instead, or accept that this cell will keep recalcing.

If you genuinely have to keep volatile functions, switch the whole workbook to Manual calculation (see #4) so they only recalc on F9.

7. AutoSave hammering OneDrive on every keystroke

If your workbook lives on OneDrive, SharePoint, or Teams — and these days, most do — AutoSave is on by default. AutoSave pushes a delta to the cloud constantly. Not after each save. After each pause in typing.

On slow connections or large workbooks, this turns Excel into a UI that feels like it has hiccups. Type, pause, hiccup. Type, pause, hiccup. Drives me up a wall.

Two options

Toggle AutoSave off. Top-left of the Excel window, next to the file name. The file still auto-recovers locally if Excel crashes, you just save manually with Ctrl+S like the old days.
Move heavy workbooks off OneDrive for the duration of intensive editing. Save locally, do your work, copy back when done.

Related setting:

File → Options → Save → AutoRecover information every X minutes. Default is 10 minutes. If you've cranked this down to 1 minute, Excel will hitch on every recovery write. Leave it at 10. Or 5 if you've been getting crashes and want a tighter safety net.

Bonus round: repair the Office install

If you've done all seven and Excel still feels broken — the install itself might be corrupted. More common than you'd expect after major Windows updates.

Settings → Apps → Installed apps → Microsoft 365 (or Microsoft Office, depending on your version).
Three dots → Modify → Quick Repair first. About a minute. Fixes most issues.
If that doesn't help, repeat and choose Online Repair. Re-downloads the entire Office install. 15 to 30 minutes. Catches the corrupted files Quick Repair misses.

You won't lose any documents or settings. This only repairs program files. (I always feel obligated to mention that because people get nervous.)

Quick triage table

Symptom	Most likely fix
Slow scrolling, choppy charts	Disable hardware graphics acceleration
Slow startup	Disable COM add-ins
Slow on edit, fast otherwise	Conditional formatting rules or volatile functions
Ctrl+End jumps to row 1,048,576	Used range bloat
Cloud-saved file lags	Disable AutoSave or move local
Random freezes after a Windows update	Quick Repair Office

So basically

Excel performance is rarely about file size and almost always about settings that quietly piled up cruft. Disable hardware graphics acceleration. Prune your COM add-ins. Kill conditional formatting rule bloat. Fix your used range. Stop using INDIRECT like it's free. Do those five things and most "Excel is slow" complaints disappear in under ten minutes. If they don't — that's when you start looking at the file or the install. Not the laptop.

(That client with the 14-second open time? Disabling hardware graphics acceleration alone got her down to 3 seconds. The whole call lasted six minutes. She didn't buy the new laptop.)