PivotItem PivotItem PivotItem Interface


Represents an item in a PivotTable field. 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.

public interface class PivotItem
public interface PivotItem
Public Interface PivotItem


Use PivotItems(index), where index is the item index number or name, to return a single PivotItem object.


_Default _Default _Default

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Caption Caption Caption

The label text for the pivot item. Read-only String.

ChildItems[Object] ChildItems[Object] ChildItems[Object]

Returns an object that represents either a single PivotTable item (a PivotItem object) or a collection of all the items (a PivotItems object) that are group children in the specified field or children of the specified item. Read-only.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.

DataRange DataRange DataRange

Returns a Range object. Read-only.

DrilledDown DrilledDown DrilledDown

True if the flag for the specified PivotTable field or PivotTable item is set to "drilled" (expanded, or visible). Read/write Boolean.

Formula Formula Formula

Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write String.

IsCalculated IsCalculated IsCalculated

True if the PivotTable field or PivotTable item is a calculated field or item. Read-only Boolean.

LabelRange LabelRange LabelRange

Returns a Range object that represents all the cells in the PivotTable report that contain the item. Read-only.

Name Name Name

Returns or sets the name of the object. Read/write String.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

ParentItem ParentItem ParentItem

Returns a PivotItem object that represents the parent PivotTable item in the parent PivotField object (the field must be grouped so that it has a parent). Read-only.

ParentShowDetail ParentShowDetail ParentShowDetail

True if the specified item is showing because one of its parents is showing detail. False if the specified item isn’t showing because one of its parents is hiding detail. This property is available only if the item is grouped. Read-only Boolean.

Position Position Position

Position of the item in its field if the item is currently showing. Read/write Integer.

RecordCount RecordCount RecordCount

Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. Read-only Integer.

ShowDetail ShowDetail ShowDetail

True if the outline is expanded for the specified range (so that the detail of the column or row is visible). Read/write Object.

SourceName SourceName SourceName

Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report. Read-only Object.

SourceNameStandard SourceNameStandard SourceNameStandard

Returns a String that represents the PivotTable item's source name in standard English (United States) format settings. Read-only.

StandardFormula StandardFormula StandardFormula

Returns or sets a String specifying formulas with standard English (United States) formatting. Read/write.

Value Value Value

The name of the specified item in the PivotTable field. Read/write String.

Visible Visible Visible

Determines whether the object is visible. Read/write Boolean.


Delete() Delete() Delete()

Deletes the object.

DrillTo(String) DrillTo(String) DrillTo(String)

TheDrillTo(String) method supports drilling to a specified PivotField from a PivotItem.

Applies to