Is it normal that 8000 rows takes 20 seconds to recalculate after every edit Formula Help
Roughly 8,000 rows, 15 columns, mostly SUMIFS with a few INDEX MATCH and some conditional formatting. Every time I type in a cell the whole thing freezes for about 20 seconds. The file is only 4 MB. Is this normal at that size or is something specific in there dragging it down?
@kernel_ring_buf · 2mo ago · 3 replies
Not normal. 8,000 rows should feel instant, so something in there is either volatile or scanning whole columns. The order I check:
A:Ainstead ofA2:A8000. Fifteen columns of SUMIFS over full columns means a million row scan per formula, per recalculation.Fix those and it drops under a second.
Reply
Report
@pomodoro_pat · 2mo ago
The conditional formatting rules manager had about 1,900 entries in it. I did not know that could happen.
Reply
Report
@kernel_ring_buf · 2mo ago
It happens every time someone copies and pastes formatted rows. Delete them all and reapply once to the used range. Check the used range itself while you are there — Ctrl+End sometimes lands on row 900,000 because of old formatting, and everything is slower for it.
Reply
Report