PivotTable.DisplayEmptyColumn Property

Returns True when the non-empty MDX keyword is included in the query to the OLAP provider for the value axis. The OLAP provider will not return empty columns in the result set. Returns False when the non-empty keyword is omitted. Read/write Boolean.

Syntax

expression.DisplayEmptyColumn

expression   A variable that represents a PivotTable object.

Remarks

The PivotTable must be connected to an Online Analytical Processing (OLAP) data source to avoid a run-time error.

Example

This example determines the display settings for empty columns in a PivotTable. It assumes a PivotTable connected to an OLAP data source exists on the active worksheet.

  Sub CheckSetting()
Dim pvtTable As PivotTable

Set pvtTable = ActiveSheet.PivotTables(1)

' Determine display setting for empty columns.
If pvtTable.<strong>DisplayEmptyColumn</strong> = False Then
    MsgBox "Empty columns will not be displayed."
Else
    MsgBox "Empty columns will be displayed."
End If

End Sub

See Also

• PivotTable Object
• PivotTable Members