Trigger a full calculation in VBA

Question

Given a workbook that contains lots of formulas, i realise that when its cell values are up-to-date, F9, ActiveWorkbook.Calculate or Sheets(1).calculate does not trigger a re-calculation.

However, if a cell value that is referenced by another cell through formula changes, F9, ActiveWorkbook.Calculate or Sheets(1).calculate will trigger a recalculation of all the formulas that depend on the changed cell.

In one word, Excel just recalculates which is necessary.

However, I would like to measure the behavior (eg, time) of a FULL calculation of the workbook (ie, refreshing from the constant values, then the formulas depending on them, then a higher level formulas...).

Does anyone know how to trigger such a full calculation in VBA?

Answer 1

You have two options - CalculateFull and CalculateFullRebuild. The latter will rebuild the entire dependency chain so may be overkill here. Note that both will apply to all open workbooks, not just the active one.