This documentation is archived and is not being maintained.

PivotTable.DisplayNullString Property (Excel)

True if the PivotTable report displays a custom string in cells that contain null values. The default value is True. Read/write Boolean.

expression .DisplayNullString

expression A variable that represents a PivotTable object.

Use the NullString property to set the custom null string.

This example causes the PivotTable report to display "NA" in cells that contain null values.

With Worksheets(1).PivotTables("Pivot1") 
 .NullString = "NA" 
 .DisplayNullString = True 
End With

This example causes the PivotTable report to display 0 (zero) in cells that contain null values.

Worksheets(1).PivotTables("Pivot1").DisplayNullString = False
Show: