O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PivotTable and PivotTables Members

Use the PivotTables collection to get existing pivot tables. Use the Worksheet object’s PivotTables property to get a reference to this collection. Use the PivotTable object to set the pivot table layout and options. The PivotTables collection and PivotTable object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Add 2

AddDataField

AddFields

Application 2

CacheIndex

CalculatedFields

CalculatedMembers

ColumnFields

ColumnGrand

ColumnRange

Count 1

CreateCubeFile

Creator 2

CubeFields

DataBodyRange

DataFields

DataLabelRange

DataPivotField

DisplayEmptyColumn

DisplayEmptyRow

DisplayErrorString

DisplayImmediateItems

DisplayNullString

EnableDataValueEditing

EnableDrilldown

EnableFieldDialog

EnableFieldList

EnableWizard

ErrorString

Format

GetData

GetPivotData

GrandTotalName

HasAutoFormat

HiddenFields

InnerDetail

Item 1

ListFormulas

ManualUpdate

MDX

MergeLabels

Name

NullString

PageFieldOrder

PageFields

PageFieldStyle

PageFieldWrapCount

PageRange

PageRangeCells

Parent 2

PivotCache

PivotFields

PivotFormulas

PivotSelect

PivotSelection

PivotSelectionStandard

PivotTableWizard

PreserveFormatting

PrintTitles

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required