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