Share via

PivotTable.DisplayErrorString Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  With Worksheets(1).PivotTables("Pivot1")
    .ErrorString = "-"
    .DisplayErrorString = True
End With

See Also