CalculateFull Method

Forces every formula in the open workbook to be recalculated.

expression   Required. An expression that returns a Spreadsheet object.

Example

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

Spreadsheet1.CalculateFull