Properties and Methods of the Pivot Table Object

The members of the PivotTable object are shown in Table 20-2. We'll discuss the most important of these members by their function.

Table 20-2. Members of the PivotTable Object

_Default

ErrorString

PrintTitles<v9>

_PivotSelect<v 10>

Format<v9>

RefreshDate

AddDataField<v10>

GetData

RefreshName

AddFields

GetPivotData<v 10>

RefreshTable

Application

GrandTotalName<v9>

RepeatItemsOnEachPrintedPage<v9>

Cacheindex

HasAutoFormat

RowFields

CalculatedFields

HiddenFields

RowGrand

CalculatedMembers<v10>

InnerDetail

RowRange

ColumnFields

ListFormulas

SaveData

ColumnGrand

ManualUpdate

SelectionMode

ColumnRange

MDX<v10>

ShowCellBackgroundFromOLAP<v 10>

CreateCubeFile<v 10>

MergeLabels

ShowPageMultipleItemLabel<v10>

Creator

Name

ShowPages

CubeFields<v9>

NullString

SmallGrid<v9>

DataBodyRange

PageFieldOrder

SourceData

DataFields

PageFields

SubtotalHiddenPageItems

DataLabelRange

PageFieldStyle

TableRange1

DataPivotField<v 10>

PageFieldWrapCount

TableRange2

DisplayEmptyColumn<v10>

PageRange

Table Style

DisplayEmptyRow<v 10>

PageRangeCells

Tag

DisplayErrorString

Parent

TotalsAnnotation<v9>

DisplayImmediateItems<v10>

PivotCache

Update

DisplayNullString

PivotFields

VacatedStyle

Dummy 15 <v 10>

PivotFormulas

Value

EnableDataValueEditing<v10>

PivotSelect

Version<v10>

EnableDrilldown

PivotSelection

ViewCalculatedMembers<v10>

EnableFieldDialog

PivotSelectionStandard<v10>

VisibleFields

EnableFieldList<v10>

PivotTable Wizard

VisualTotals<v10>

EnableWizard

PreserveFormatting

+2 0

Post a comment