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

Ultimate Blackjack System

Ultimate Blackjack System

Discover the 100 Legal Secrets Las Vegas Professional Blackjack Gamblers Use to Make Literally Thousands of Dollars Every Week... I'll Teach You the Ultimate Step-by-Step Blackjack System, Casino's Don't Want You to Know About! That's Right, I'll show you step-by-step how to have the blackjack odds in your favor, guaranteed!

Get My Free Ebook


Post a comment