Indicates whether to recalculate all formulas when data is read.

Syntax

Connect-Excel -Recalculate bool

Data Type

bool

Default Value

true

Remarks

When cells in an Excel sheet are modified, the formula cells change their value. If Recalculate is set to true, the provider will detect changed cells and recalculate the formulas. These new results are then updated back to the Excel sheet so that a recalculation is not necessary.