Excel.PivotItem.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotItem object (Excel)	vbaxl10.chm245072	vbaxl10.chm245072	Excel.PivotItem	5829a1d9-0924-9ce8-1120-229e4595285a	03/30/2019	medium

PivotItem object (Excel)

Represents an item in a PivotTable field.

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 (index), where index is the item index number or name, to return a single PivotItem object.

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

Methods

• Delete
• DrillTo

Properties

• Application
• Caption
• ChildItems
• Creator
• DataRange
• DrilledDown
• Formula
• IsCalculated
• LabelRange
• Name
• Parent
• ParentItem
• ParentShowDetail
• Position
• RecordCount
• ShowDetail
• SourceName
• SourceNameStandard
• StandardFormula
• Value
• Visible

See also

• Excel Object Model Reference

[!includeSupport and feedback]