Speed up slow Excel formulasYour formulas aren't wrong.
They just run too often.

Too big or slow to open? Slim it first →

standbyChoose a file

awaiting upload
volatile—
single-thread—
mode—

FAQ

Why does Excel freeze every time I edit a cell?

Volatile functions such as OFFSET, INDIRECT and TODAY recalculate on every edit; a VLOOKUP over a whole table recalculates when any of its columns changes; IF(ISERROR(X),…,X) computes X twice.

Will the results change?

Every rewrite passes three checks: the old formula evaluates to the cached value, old and new agree, and they still agree when inputs are swapped for blanks, zeros, negatives, text and other edge values. Anything unproven stays as is.

Why not switch VLOOKUP to XLOOKUP?

An equivalent XLOOKUP needs wildcard mode, which measured 4× slower, and the two differ when the lookup value is blank.

How do I make Excel calculate faster?

Avoid volatile functions and whole-column references, and don't compute the same thing twice. This tool rewrites every formula it can prove equivalent and lists the rest in the report with suggestions for manual changes.

Which Excel functions are volatile?

OFFSET, INDIRECT, TODAY, NOW, RAND, RANDBETWEEN, and CELL and INFO in some forms. They recalculate after any edit anywhere in the workbook, together with every formula that depends on them.

Will the rewritten file work in older Excel?

By default only functions available since Excel 2010 are used; LET, IFNA, CONCAT and other newer functions only when you tick the Microsoft 365 / Excel 2021+ option.

What about formulas that weren't rewritten?

Anything not proven equivalent stays as is. The report lists approximate lookups, remaining OFFSET / INDIRECT, array formulas and similar risks, with forms you can switch to by hand.

Related guides

All tools