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 本製品 handles formula calculation errors when reading Excel data.

If set to true, the 本製品 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 本製品 stops processing if a calculation error occurs.

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