Expand Minimize

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.

expression .DisplayErrorString

expression A variable that represents a PivotTable object.

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.

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
© 2015 Microsoft