Edit

Share via

PivotField.VisibleItemsList property (Excel)

  • Article

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("")

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.