Properties and Methods of the PivotTable 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
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> |
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 |
Average user rating: 5 stars out of 1 votes
Post a comment