Speed up slow Excel formulasYour formulas aren't wrong.
They just run too often.
standbyChoose a file
The processing server is unreachable right now (maintenance or network). Uploads will fail; please try again later.
standbyChoose a file
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.
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.
An equivalent XLOOKUP needs wildcard mode, which measured 4× slower, and the two differ when the lookup value is blank.
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.
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.
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.
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.