Specifies whether the provider should ignore formula calculation errors in Excel worksheets.

Syntax

Connect-ExcelServices -IgnoreCalcError bool

Data Type

bool

Default Value

true

Remarks

This property controls how the cmdlet handles formula calculation errors when reading Excel data.

If set to true, the cmdlet ignores any errors that occur during formula evaluation. While this may result in unreliable values for calculated fields, other non-calculated data remains accurate.

If set to false, the cmdlet stops processing if a calculation error occurs.

Use this property when you want to load available data despite potential issues in calculated cells.