PivotItem Object

Remarks

The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

Example

Use PivotItems(), where is the item index number or name, to return a single PivotItemobject. The following example hides all entries in the first PivotTable report on Sheet3 that contain "1998" in the Year field.

Worksheets("sheet3").PivotTables(1) _ .PivotFields("year").PivotItems("1998").Visible = False

See also:

• Excel Object Model Reference
• PivotItem Object Members
• PivotCache Object
• PivotCell Object
• PivotField Object
• PivotFormula Object
• PivotItemList Object
• PivotLayout Object
• PivotTable Object