This documentation is archived and is not being maintained.

PivotTable.ErrorString Property (Excel)

Returns or sets a String value that represents the string displayed in cells that contain errors when the DisplayErrorString property is True.

expression .ErrorString

expression A variable that represents a PivotTable object.

The default value for this property is an empty string ("").

This example displays a hyphen in cells in the specified PivotTable report that contain errors.

With Worksheets(1).PivotTables("Pivot1") 
 .ErrorString = "-" 
 .DisplayErrorString = True 
End With