Specifies whether to recalculate formula values when cells involved in formula calculation are updated.

Syntax

Connect-Excel -Recalculate bool

Data Type

bool

Default Value

true

Remarks

If this connection property is set to True, the cmdlet recalculates the value of cells containing formulas when any of the cells targeted by the calculation are updated. This recalculated value is then sent back to the corresponding sheet in the workbook file.

If this connection property is set to False, cells containing formulas are not recalculated when any of the cells targeted by the calculation are updated.