PivotTable.DisplayErrorString Property
True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property DisplayErrorString As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.DisplayErrorString
instance.DisplayErrorString = value
bool DisplayErrorString { get; set; }
Property Value
Type: System.Boolean
Remarks
Use the ErrorString property to set the custom error string.
This property is particularly useful for suppressing divide-by-zero errors when calculated fields are pivoted.