Recalculate Method
Recalculates formulas that are out of date.
Syntax
public void recalculate();
Remarks
This method recalculates all formulas in the workbook that depend on cells whose values have changed.
If a formula references a cell whose value has changed the formula must be recalculated to reflect the change. The bean will automatically keep track of which cells a formula references. Call this method to recalculate any formulas in the workbook that may result in a new value.
To recalculate all formulas, regardless of whether referenced cells have changed, call RecalculateAll