SSIS Components for Microsoft Excel

Build 24.0.8963

Recalculate

Indicates whether to recalculate all formulas when data is read.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963