Dashboard feels sluggish
Audit for NOW in every row and replace with a single timestamp cell referenced by the column.
What is recalculation in Google Sheets?
Recalculation is when Google Sheets recomputes formula results after something changes. Most functions update when their input cells change. Volatile functions like NOW, RAND, and OFFSET recalculate more often. Large workbooks may feel slow when thousands of formulas refresh at once.
When to use it
Think about recalculation when dashboards lag, IMPORTRANGE feels stale, or you use NOW and RAND in models that should only update on a schedule.
When to skip it
Do not fight recalculation with hacks when the real fix is smaller ranges, fewer volatile functions, or moving heavy work to a script on a timer.
How it works
-
1
Edit a cell and dependent formulas in the same file usually refresh within seconds.
-
2
Volatile functions recalculate on many sheet actions, not only when their direct inputs change.
-
3
IMPORTRANGE and external data may cache results until the import refreshes or the sheet reloads.
-
4
Circular references block normal recalculation until you enable iterative calculation or fix the loop.
-
5
Copy-paste values to freeze outputs when you need a snapshot that should not change with the next edit.
-
6
Split huge ARRAYFORMULA columns into bounded ranges to reduce work on every keystroke.
Examples in Google Sheets
IMPORTRANGE price list
Prices update when the source file changes, but may lag until you open both files or force refresh.
Monte Carlo with RAND
Each recalc reshuffles results; paste values before presenting to leadership.
Build this without starting from a blank cell
Use a Better Sheets tool for Recalculation, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Using TODAY in ten thousand rows instead of one header cell every formula references.
- Assuming IMPORTRANGE is real-time like a database connection.
- Enabling iterative calculation to silence circular refs without fixing the model logic.
- Pasting formulas over a spill range and wondering why nothing updates correctly.
- Building client reports that still contain RAND and surprise stakeholders on reopen.
Frequently asked questions
- Force recalculate Google Sheets?
- Edit any cell or reload the tab. There is no Excel-style F9, but changes propagate on edit and open.
- What triggers recalculation?
- Cell edits, some formatting changes, and opening the file. Volatile functions add extra triggers.
- Recalculation and version history?
- History stores values at save points. Old versions may show different formula results than live sheet.
- Slow recalculation fixes?
- Shrink ranges, remove volatile functions, limit conditional formatting on huge columns, split tabs.
- ARRAYFORMULA recalc whole column?
- Yes. One ARRAYFORMULA can recompute many rows whenever any dependency in the range changes.
- Does onEdit recalc formulas?
- Edits trigger dependent recalc. onEdit scripts run after the edit, not instead of formula engine.
- Recalc across files?
- IMPORTRANGE and Connected Sheets depend on source refresh rules, not instant cross-file calc.
- Offline recalculation?
- Offline edits recalc when you reconnect. Complex imports may wait for network.
Related blog posts
Guides that explain Recalculation in more depth.
Related glossary terms
Volatile functions
Volatile functions recalculate whenever Sheets recalculates the sheet, not only when their direct arguments change. NOW, TODAY, RAND, RANDBETWEEN, OFFSET, and INDIRECT are common examples. Heavy use in large ARRAYFORMULA columns can make shared files feel sluggish and make results change on every edit.
Read guide →Circular reference
A circular reference happens when a formula chain loops back to the cell you are editing, directly or through other cells. Google Sheets normally blocks this with a warning and may show zero or an error until you break the loop or enable iterative calculation. Most circles in real files are mistakes, not intentional models.
Read guide →Iterative calculation
Iterative calculation lets formulas that reference their own cells converge through repeated passes instead of stopping at an error. You set a maximum number of iterations and a convergence threshold in File > Settings > Calculation. It is an advanced escape hatch for intentional feedback loops, not a fix for accidental typos.
Read guide →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once. It is common with IF, VLOOKUP, and math on full columns before dynamic arrays made many patterns automatic. It still matters for legacy sheets and explicit control.
Read guide →Done reading about Recalculation?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.