Skip to content

Excel.PivotField.HiddenItemsList.md

Latest commit

 

History

History
47 lines (28 loc) · 1.15 KB

Excel.PivotField.HiddenItemsList.md

File metadata and controls

47 lines (28 loc) · 1.15 KB
title PivotField.HiddenItemsList property (Excel)
keywords vbaxl10.chm240129
f1_keywords
vbaxl10.chm240129
api_name
Excel.PivotField.HiddenItemsList
ms.assetid 279eeb80-75cd-c758-98b5-668754417482
ms.date 05/04/2019
ms.localizationpriority medium

PivotField.HiddenItemsList property (Excel)

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

Syntax

expression.HiddenItemsList

expression A variable that represents 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 that 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

[!includeSupport and feedback]