Excel Running Slow? 7 Hidden Settings That Actually Fix the Lag

You open a workbook and Excel just sits there. Thirty seconds. A minute. The status bar shows "Calculating: (4 threads)" or the green progress bar inches forward at a glacial pace. You click a cell — Excel freezes again. The whole experience feels like wading through wet cement. The cause is almost never the file size; it's one of seven specific settings that nobody thinks to check until it's too late.

I've watched workbooks go from 30-second openings to instant after two minutes of cleanup. The trick is knowing where to look. Here are the seven fixes, roughly in the order they solve the most cases.

Fix 1: Switch calculation to Manual (at least temporarily)

Excel recalculates every formula on every change by default. In a workbook with chained formulas across thousands of cells, typing the letter "A" into one cell triggers a cascade of recalculations that has to finish before Excel lets you type "B." Hence the laggy feeling. Hence the rage.

1. Click Formulas → Calculation Options.
2. Change from Automatic to Manual.
3. Now press F9 when you actually want to recalculate.

If your workbook becomes instantly fast, you've found the cause. You don't have to leave manual mode on forever — use it while editing large datasets or working with volatile functions (NOW, TODAY, RAND, INDIRECT, OFFSET). When you're done editing, switch back to Automatic, run one final recalculation, save.

Fix 2: Turn off hardware graphics acceleration

Excel uses your GPU to draw the screen. That's normally fine — until your graphics driver is buggy. On corporate laptops with old drivers (or fresh laptops with new drivers that haven't been polished yet), buggy is depressingly common. Every scroll, every selection, every redraw ends up going through a slow path you didn't ask for.

1. Click File → Options → Advanced.
2. Scroll to the Display section.
3. Tick Disable hardware graphics acceleration.
4. Click OK. Restart Excel.

This single toggle fixes the "Excel feels laggy when I scroll" complaint on maybe a third of corporate machines I've seen. Costs nothing to try. Instantly reversible. Try it before anything more invasive.

Fix 3: Audit and disable add-ins

Add-ins are the second most common cause. A single COM add-in left over from a plugin you forgot you installed can add seconds to every action — every recalc, every save, every open. The catch: most people don't know they have add-ins loaded, because the add-ins came preinstalled on their corporate machine and have been quietly slowing everything down for years.

1. Click File → Options → Add-ins.
2. At the bottom, set Manage to COM Add-ins and click Go.
3. Note what's checked. Then uncheck everything you don't actively use.
4. Repeat for Excel Add-ins in the dropdown.
5. Restart Excel.

The repeat offenders in US corporate environments: old SAP plugins, Bloomberg connectors, PDF toolbars from Acrobat or Foxit, McAfee or Symantec file scanners, and ancient ERP integrations from systems nobody remembers buying. If you're unsure, disable everything, restart, and re-enable add-ins one at a time. The one that brings the slowness back is your culprit.

Fix 4: Break external workbook links

External links are notorious. Every time Excel opens a workbook with links to other workbooks, it tries to resolve each one. If the linked file is on a network share, OneDrive, or — worst case — a path that no longer exists, resolution can take seconds per link. Multiply by however many links you've got and you've found minutes of pure waiting.

1. Click Data → Edit Links.
2. Look at the list. For every link you don't actually need, click Break Link.
3. Break Link replaces formula references with their last-known values. Your data stays, the slow lookup goes away.

For links you genuinely need, at least keep the source files in the same local folder. Anything on SharePoint or OneDrive that isn't set to Always keep on this device is a recipe for multi-second resolution delays during open and recalc.

Fix 5: Clean up conditional formatting bloat

Conditional formatting is fine when you have a few rules on a few ranges. It becomes a disaster when copy-paste over the years has duplicated those rules a hundred times across slightly-overlapping ranges — and nobody noticed.

1. Click Home → Conditional Formatting → Manage Rules.
2. Change Show formatting rules for to This Worksheet.
3. Look at the list. If you see the same rule appearing three or four times with slightly different ranges, that's your problem.
4. Delete the duplicates. If you can consolidate into one rule with one large range, even better.

Repeat for every worksheet. In bad cases this single cleanup turns a workbook from "completely unusable" to "instant." Worth investing the half hour.

Fix 6: Use Inquire to find the slow parts

Office Professional Plus and Microsoft 365 both ship with a hidden add-in called Inquire. Most people never enable it. Inquire shows you exactly where complexity is hiding in your workbook.

1. Click File → Options → Add-ins.
2. Set Manage to COM Add-ins, click Go.
3. Tick Inquire if it appears in the list. Click OK.
4. A new Inquire tab appears at the top.
5. Click Workbook Analysis.

Inquire spits out a list of volatile formulas, the cells with the most precedents, and the sheets doing the most work. Nine times out of ten you'll find a single runaway INDIRECT formula, or a SUMPRODUCT over an entire column, or a VLOOKUP doing more work than it needs to. Fix that one cell and the whole workbook becomes responsive.

Fix 7: Purge phantom cell styles

This one's invisible and surprisingly common. Excel accumulates cell styles — sometimes thousands of them — across years of copy-pasting between workbooks. Every style has to be tracked on every recalculation. You can see how bad it is by clicking the Cell Styles dropdown on the Home tab. If there are hundreds of strange entries you don't recognize, you've found a problem.

To purge them, press Alt + F8 to open the macro dialog. Name a macro something like "PurgeStyles," click Create, and paste:

Sub PurgeStyles()
    Dim s As Style, n As Long
    For Each s In ActiveWorkbook.Styles
        If Not s.BuiltIn Then
            s.Delete
            n = n + 1
        End If
    Next s
    MsgBox n & " custom styles removed."
End Sub

Run it. Save the workbook. Reopen it. The file is smaller. Excel feels lighter.

Bonus diagnostic: peek inside the file

One quick trick. Make a copy of your workbook, rename the extension to .zip, and open it. Yes — every modern Excel file is just a renamed ZIP archive. Inside you'll find folders, and the biggest ones tell you where the bloat is:

• xl/worksheets/ — actual cell data.
• xl/styles.xml — style definitions (should be small).
• xl/media/ — images embedded in the workbook.
• xl/pivotCache/ — cached PivotTable data.

If media is 50 MB but your actual data is 200 KB, your "slowness" is a dozen high-resolution images dragging everything down. If pivotCache is huge, your PivotTables are caching old source data — refresh and save, or set them not to cache.

The rule, for next time

Excel slows down when it has more work to do than it can finish in the time you give it. The fixes above all reduce that work: fewer recalcs, fewer dependencies, fewer styles, fewer add-ins, less graphics overhead. Pick the lowest-hanging fruit first — calculation mode, hardware acceleration — and only escalate from there. You won't usually need all seven. Two or three, applied to whatever's currently fighting you.

Next time someone in your office says "Excel just feels slow lately," you'll have the entire checklist memorized.