Why Is Google Sheets So Slow (and How to Find the Cells That Are Killing It)

If you build models in Sheets, you know the feeling. Typing has a half second delay, the green loading bar never leaves, and scrolling stutters. It’s not your laptop. Sheets recalculates in your browser on every edit, and a few specific things make that slow:

• Volatile functions. NOW, TODAY, and RAND recalc on every edit, and so does everything that depends on them.
• Whole-column references. SUM(A:A) or a VLOOKUP over A:F scans every allocated row, including the empty ones.
• IMPORTRANGE chains. Sheets pulling from sheets pulling from other sheets. Every file open waits on the whole chain.
• Too many tabs. Old versions and scratch tabs count toward the 10 million cell limit even when they look empty.
• Conditional formatting pileup. Every copy-paste drags rules along until a tab has dozens re-checking as you scroll.

The fixes are mostly easy. The hard part is finding this stuff in a 20 tab model, especially one you inherited. That’s why I built Workbook Health into XLKeys.

The Two Scans

The Cell Capacity Audit (Alt A W C) shows exactly where your 10 million cells went: total allocated, what’s left, which tabs are the problem, and the trailing blank rows and columns you can probably delete. It never deletes anything itself.

The Performance Audit (Alt A W P) scans every formula in the workbook and ranks the patterns most likely to be causing lag, with sample cells you can click to jump straight to the offender. Sheets doesn’t expose per-formula timing, so it’s a ranked list of suspects, not a stopwatch. In my experience the top two or three findings are the whole problem.

Both are XLKeys Pro, with a 30 day free trial and no card. If you want the full manual fix list (closed ranges, taming IMPORTRANGE, cleaning up conditional formatting), I wrote the long version here. More detail on the scans themselves is in the launch post.

Install XLKeys, open the slow workbook, press Alt A W P. What to fix first is usually a shorter list than you think.