HiddenItemsList Property

Microsoft Excel Visual Basic

Show All

HiddenItemsList Property

       

Returns or sets a Variant specifying an array of strings that are hidden items for a PivotTable field. Read/write.

expression.HiddenItemsList

expression   Required. An expression that returns a PivotField object.

Remarks

The HiddenItemsList property is only valid for Online Analytical Processing (OLAP) data sources; using this property on non-OLAP data sources will return a run-time error.

Example

The example sets the item list so that only certain items are displayed. It assumes an OLAP PivotTable exists on the active worksheet.

Sub UseHiddenItemsList()

    ActiveSheet.PivotTables(1).PivotFields(1).HiddenItemsList = _
        Array("[Product].[All Products].[Food]", _
        "[Product].[All Products].[Drink]")

End Sub