Specifies whether to include spreadsheet calculation error types in query results.

Syntax

Connect-Excel -IgnoreCalcError SwitchParameter

Data Type

bool

Default Value

false

Remarks

This connection property controls how the cmdlet treats cells containing invalid calculations in query results.

When this connection property is set to True, the cmdlet returns the name of the error type, as it appears in the spreadsheet, (e.g. "#Name?") for these cells in query results.

When this connection property is set to False, the cmdlet returns a null value for these cells in query results.

Note that, regardless of how this connection property is set, the cmdlet does not halt query execution or display a cmdlet-level error message when it detects a cell with invalid calculations.