SSIS Components for Microsoft Excel

Build 24.0.8963

HasCrossSheetReferences

Indicates how cross sheet references are handled.

Data Type

bool

Default Value

false

Remarks

HasCrossSheetReferences controls how cross sheet references are handled. If there are cross sheet references, changes to one sheet may cause some other formulas in other sheets to be recalculated. If HasCrossSheetReferences is set to true, all sheets in the workbook will be loaded into memory and the cross sheet references would be handled. However, setting the property to true may slow down performance because all sheets will be read from the Excel file.

This value should be set to true if you plan on making updates to the sheet. When this option is disabled the component generates larger files because it cannot reuse shared data across multiple sheets. However, disabling this option allows the component to reuse data across multiple sheets and generate smaller files.

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