PivotTable.DisplayEmptyColumn (Excel)

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.

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

ActiveCell.PivotTable.DisplayEmptyColumn = True