CalculateFull Method

Forces every formula in the open workbook to be recalculated.

expression.CalculateFull

*expression   * Required. An expression that returns a Spreadsheet object.

Example

This example forces a full calculation of all data in Spreadsheet1.

Spreadsheet1.CalculateFull

Applies to | Spreadsheet Object

See Also | Calculate Method | Calculation Property