PivotTable.DisplayErrorString Property (Excel)
True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False. Read/write Boolean.
Syntax
expression .DisplayErrorString
expression A variable that represents a PivotTable object.
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.
Example
This example causes the PivotTable report to display a hyphen in cells that contain errors.
With Worksheets(1).PivotTables("Pivot1")
.ErrorString = "-"
.DisplayErrorString = True
End With