Skip to content

Analysis tools · Hard

A workbook has become slow. How do you speed it up?

Short answer

Find the expensive parts: volatile functions such as OFFSET, INDIRECT and TODAY recalculating constantly, whole-column references in thousands of formulas, and repeated lookups. Replace them with Tables, helper columns, XLOOKUP on bounded ranges, Power Query or the Data Model, and switch to manual calculation while editing.

Detailed answer

  • Formulas › Calculation Options › Manual during heavy edits.
  • Replace thousands of lookups with one Power Query merge.
  • Remove unused formatting and named ranges.
  • If the data is truly large, move the analysis to SQL or Python.