Fix Microsoft Excel Too Slow? 7 Real Fixes

If Excel is lagging, freezing, or taking forever to calculate, the fix is usually a combination of reducing the workbook’s size, disabling heavy add-ins, and switching to manual calculation mode. Here are the seven most effective fixes, starting with the one that solves most cases: turning off automatic calculation for large files.

Why Excel Gets Slow

Excel slows down when it has to do too much work per action. The most common culprits are:

• Volatile functions like OFFSET, INDIRECT, TODAY, NOW, RAND, and RANDBETWEEN recalculate every time anything changes in the workbook, even if their own inputs didn’t change.
• Entire column references like A:A or SUM(A:A) force Excel to scan over a million cells, most of which are empty.
• Conditional formatting rules applied to whole columns or sheets instead of just the used range.
• Add-ins (like third-party analysis tools or legacy COM add-ins) run code on every open, close, and recalculation.
• Array formulas (especially legacy CSE arrays) that calculate large ranges.
• External links that pull data from other workbooks, causing Excel to wait for the source file.
• Too many formatting differences — thousands of individually colored cells or borders slow down rendering.

First Fix: Switch to Manual Calculation

This is the single most effective fix for a slow workbook. By default, Excel recalculates every formula every time you type, edit, or open the file. For a large model, that can take seconds per keystroke.

1. Go to Formulas > Calculation Options.
2. Select Manual.
3. Optionally check Recalculate workbook before saving so saved files always have fresh values.

Now Excel will only calculate when you press F9 (calculate all open workbooks), Shift+F9 (calculate the active sheet), or Ctrl+Alt+F9 (force a full recalculation). This turns a laggy typing experience into an instant one. The trade-off is that formulas won’t update live, so you must remember to press F9 before reading results.

Reduce Volatile Functions and Array Formulas

Volatile functions are the biggest performance killer. If you have a column of 10,000 cells each using OFFSET or INDIRECT, every edit triggers 10,000 recalculations of those functions. Replace them with non-volatile alternatives:

• Replace OFFSET with INDEX (INDEX is non-volatile).
• Replace INDIRECT with a helper column that builds the reference as text, then use INDEX or XLOOKUP.
• Replace TODAY() and NOW() with a static date entered once, or a cell you update manually.
• Avoid RAND() unless you truly need a new random number on every recalc.

For array formulas, convert them to dynamic array formulas (Excel 365) or use SUMPRODUCT, which calculates without array entry. If you have legacy CSE arrays, press Ctrl+Shift+Enter to confirm them, or better, rewrite them with SUMPRODUCT.

Trim Unused Cells and Formatting

Excel files often become slow because they contain formatting or data far beyond the last used cell. This happens when you delete rows or columns but the formatting remains on the entire column/row.

1. Press Ctrl+End to see where Excel thinks the last used cell is.
2. If it’s way beyond your actual data, select the rows below your data (e.g., row 1001 to 1,048,576), then Home > Clear > Clear All.
3. Do the same for columns to the right.
4. Then save and close the file. Reopen it — the file size should drop and scrolling should be smoother.

Also, remove conditional formatting rules that cover entire columns. Select just the data range (e.g., A1:Z1000) and apply rules there, not to A:Z.

Disable Heavy Add-ins

Add-ins run code in the background. Some are notorious for slowing Excel:

• Go to File > Options > Add-ins.
• At the bottom, select COM Add-ins and click Go.
• Uncheck any you don’t need (e.g., legacy analysis tools, third-party connectors).
• Restart Excel.

If you need an add-in occasionally, keep it disabled and enable it only when needed. Also check File > Options > Trust Center > Trust Center Settings > Add-ins — disable any that are not from a trusted publisher.

Use Excel’s Built-in Performance Tools

Modern Excel (2016 and later) includes a workbook performance checker:

1. Go to File > Options > Add-ins.
2. At the bottom, select COM Add-ins and check Inquire.
3. Click OK. The Inquire tab appears on the ribbon.
4. Click Workbook Analysis to see a report of heavy formulas, hidden sheets, and formatting issues.

This tool won’t fix anything by itself, but it tells you exactly where the bloat is. Another quick win: convert data tables (Insert > Table) to regular ranges if you don’t need structured references, because tables recalculate more often.

Common Misconception: “It’s the File Size”

Many users think a 50 MB Excel file is slow because of its size. In reality, file size is rarely the cause of calculation lag. A 50 MB file with simple values and no formulas opens quickly. A 500 KB file with 100,000 volatile formulas is brutally slow. The problem is the calculation chain, not the bytes. So don’t just compress images or remove data — focus on formulas and formatting.

Frequently Asked Questions

Why is Excel slow only on one sheet?

That sheet likely has volatile functions, array formulas, or conditional formatting covering the entire sheet. Use the Inquire add-in or manually check the last used cell (Ctrl+End) to see if the sheet extends to a million rows. Clear unused rows/columns and reduce conditional formatting to the used range.

Will turning off automatic calculation break my formulas?

No. It just stops them from updating automatically. When you press F9, they all recalculate. The risk is forgetting to press F9 and seeing stale values. To avoid this, keep the “Recalculate workbook before saving” option checked, so the saved file is always up to date.

Does Excel 365 run faster than Excel 2016?

For most tasks, yes. Excel 365 uses a more modern calculation engine, supports dynamic arrays (which can replace slow array formulas), and has better multi-threading. But if your workbook uses legacy volatile functions, it will still be slow on 365.

Can a slow Excel be caused by my computer’s hardware?

Yes, but less often than you’d think. Excel is mostly single-threaded for a single formula calculation. A faster CPU clock speed helps more than more cores. RAM matters if you have huge datasets (over a million rows) or many open workbooks. An SSD makes opening/saving faster but doesn’t speed up calculation.

Is it better to split a large workbook into multiple files?

Often yes. If you have a workbook with 20 sheets each with heavy formulas, splitting into separate workbooks and linking them with external references can improve responsiveness, because Excel only recalculates the active workbook unless you force a full calc. However, external links add their own overhead, so test both approaches.

Why does Excel freeze completely, not just slow down?

A complete freeze usually means an infinite loop in a VBA macro, a circular reference that never converges, or a single formula that is computationally huge (like a nested IF over 100,000 rows). Try pressing Esc to break the calculation. If that fails, open Task Manager and end Excel, then reopen in Safe Mode (hold Ctrl while launching) to see if an add-in is the cause.

Related

• How to Watermark Photos on Your Phone
• Browser Golf Game Won’t Load or Save: Fix Guide
• Fix MacBook Battery Not Charging: Causes & Fixes