Indicates whether to ignore errors that occurred during the calculation.

Syntax

Connect-Excel -IgnoreCalcError SwitchParameter

Data Type

bool

Default Value

false

Remarks

IgnoreCalcError defaults to false. If IgnoreCalcError is set to true, the provider will ignore any errors that occur due to formula calculation. If this happens, the formula result may be unreliable, but other data will be accurate.