Excel.PivotField.VisibleItemsList.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotField.VisibleItemsList property (Excel)	vbaxl10.chm240146	vbaxl10.chm240146	Excel.PivotField.VisibleItemsList	ddcc2dce-30bf-ba50-22fa-a4baf41129f5	05/07/2019	medium

PivotField.VisibleItemsList property (Excel)

Returns or sets a Variant specifying an array of strings that represent included items in a manual filter applied to a PivotField. Read/write.

Syntax

expression.VisibleItemsList

expression A variable that represents a PivotField object.

Remarks

This property is applicable to OLAP PivotTables only.

Example

This example shows manual, inclusive filtering in an OLAP PivotTable.

ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _ 
.[Country]").VisibleItemsList = Array("[Customer].[Customer Geography].[Country].&[Australia]") 
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _ 
.[State-Province]").VisibleItemsList = Array("") 
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _ 
.[City]").VisibleItemsList = Array("") 
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _ 
.[Postal Code]").VisibleItemsList = Array("") 
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _ 
.[Full Name]").VisibleItemsList = Array("") 

[!includeSupport and feedback]