Why Is My Excel File So Slow? (And How to Actually Fix It)

You open your Excel file and it freezes for ten seconds. You type a number and watch the progress bar crawl. You try to scroll and the whole thing locks up. Sound familiar?

Slow Excel is one of the most frustrating everyday tech problems because it sneaks up on you gradually — the file was fine six months ago, and now it’s basically unusable. Here’s what’s actually causing it and what you can do about it.

The Most Common Culprits

1. Volatile Functions That Recalculate Constantly

Functions like NOW(), TODAY(), RAND(), OFFSET(), and INDIRECT() are called “volatile” because Excel recalculates them every single time anything changes in the workbook — even if you change a completely unrelated cell.

If you have these functions scattered through hundreds of cells, your file is doing an enormous amount of unnecessary work. Replace them where possible:

Use a static timestamp instead of NOW() if you don’t need it live
Replace OFFSET() with INDEX() which isn’t volatile
Replace INDIRECT() with direct references wherever possible

2. Formulas Referencing Entire Columns

This is one of the most common mistakes:

=SUMIF(A:A, "Yes", B:B)

That A:A and B:B means Excel is scanning over a million rows every time it recalculates. If your data only goes to row 500, change this to:

=SUMIF(A2:A500, "Yes", B2:B500)

The performance difference on large files is dramatic.

3. Too Much Conditional Formatting

Conditional formatting is useful, but it’s also surprisingly expensive. The worst case: people apply it to entire columns (A:A) when they only need it on their actual data range. Over time, as rows are deleted and re-added, Excel accumulates duplicate and overlapping rules that it still evaluates on every recalculation.

To clean it up: go to Home → Conditional Formatting → Manage Rules → Show rules for: “This Worksheet” and delete anything that’s applied to full columns or that looks like a duplicate.

4. Massive Unused Range

Excel tracks the “used range” of your spreadsheet — the area from cell A1 to the last cell that has any content or formatting. If someone accidentally formatted cells all the way down to row 1,000,000, Excel treats all of that as part of the file even if it’s empty.

Press Ctrl + End to see where Excel thinks your data ends. If it jumps to a row far beyond your actual data, you have a bloated range. Select the empty rows below your data, right-click → Delete, and save. This alone can shrink file size by 80% in some cases.

5. Too Many Named Ranges That No Longer Exist

When you delete data but not the named ranges or table names associated with it, Excel still holds onto them. Go to Formulas → Name Manager and remove anything that’s pointing to #REF! errors.

6. Array Formulas on Large Ranges

Old-style array formulas (the ones you entered with Ctrl+Shift+Enter) that apply to large ranges are notoriously slow. If you’re on Excel 365, replace them with dynamic array functions like FILTER(), SORT(), UNIQUE(), and XLOOKUP() — they’re both faster and easier to read.

Quick Wins You Can Do Right Now

Switch to Manual Calculation Mode while you’re working on the file: Go to Formulas → Calculation Options → Manual. Press F9 to recalculate when you want. Switch back to Automatic when you’re done.

Save as .xlsx instead of .xls. The old format is larger and slower. If you’re still on .xls, resave as .xlsx.

Disable add-ins you don’t use. Go to File → Options → Add-ins → Manage: COM Add-ins and uncheck anything you don’t actively need.

When Excel Isn’t the Right Tool Anymore

Sometimes the honest answer is that the spreadsheet has grown beyond what Excel was designed to handle. If you’re regularly dealing with large datasets, running complex cross-sheet formulas, and trying to share results with people who don’t need to see the underlying data — it might be time to think differently.

Sheetglow connects to your Excel or Google Sheets file and generates a clean, shareable dashboard automatically. Your underlying data stays in the spreadsheet; the people who need to see results get a fast, clear view without opening the file at all. It won’t fix the spreadsheet’s performance, but it can take a lot of the pressure off it.

Slow Excel is almost always fixable. Work through the list above and you’ll likely find the culprit within the first two or three checks. Start with volatile functions and column-wide references — those are responsible for the majority of performance problems in real-world files.