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

Data Type

bool

Default Value

true

Remarks

If this connection property is set to True, the connector 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.