Specifies how cross-sheet references are handled.

Data Type

bool

Default Value

false

Remarks

If this connection property is set to True, all sheets in the workbook are loaded into memory and the values of cells with cross-sheet references are reflected correctly in query results. However, doing so may impact query performance because all sheets involved in the cross-sheet references must be read by the connector to correctly calculate their values.

If this connection property is set to False, the referenced external sheets are not loaded into memory, meaning that, if the referenced external sheet changes, the connector does not detect those changes when reporting the value of cells with cross-sheet references.