Recalculate Method

Recalculates formulas that are out of date.

Syntax

[VB.NET]
Public Sub Recalculate()

[C#]
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 component 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