Indicates how cross sheet references are handled.

Syntax

Connect-Excel -HasCrossSheetReferences SwitchParameter

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 cmdlet generates larger files because it cannot reuse shared data across multiple sheets. However, disabling this option allows the cmdlet to reuse data across multiple sheets and generate smaller files.