This documentation is archived and is not being maintained.

XlPivotCellType Enumeration 

Specifies the PivotTable entity the cell corresponds to.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlPivotCellType1 As XlPivotCellType = XlPivotCellType.xlPivotCellBlankCell

public enum class XlPivotCellType
public enum XlPivotCellType
public enum XlPivotCellType

Member nameDescription
xlPivotCellBlankCellA structural blank cell in the PivotTable.
xlPivotCellCustomSubtotalA cell in the row or column area that is a custom subtotal.
xlPivotCellDataFieldA data field label (not the Data button).
xlPivotCellDataPivotFieldThe Data button.
xlPivotCellGrandTotalA cell in a row or column area which is a grand total.
xlPivotCellPageFieldItemThe cell that shows the selected item of a Page field.
xlPivotCellPivotFieldThe button for a field (not the Data button).
xlPivotCellPivotItemA cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.
xlPivotCellSubtotalA cell in the row or column area which is a subtotal.
xlPivotCellValueAny cell in the data area (except a blank row).

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms