Page 381 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
PivotTables and PivotCharts

Table 16-5. Key Properties and Methods of the PivotField Object
Property/Method Description
DragToColumn Property: when False, means that the field cannot be dragged
to the column area in the PivotTable.
DragToData Property: when False, means that the field can’t be dragged to
the data area in the PivotTable.
DragToHide Property: when False, means that the field can’t be dragged
away from the PivotTable.
DragToPage Property: when False, means that the field can’t be dragged to
the page area of the PivotTable.
DragToRow Property: when False, means that the field cannot be dragged
to the row area in the PivotTable.
LayoutForm Property: contains the way that PivotTable items appear.
xlTabular implies table format; xlOutline specifies outline
format.
MemoryUsed Property (read-only): returns the number of bytes used by the
current PivotField object.
Name Property: contains the name of the PivotField object.
NumberFormat Property: contains the formatting specifications that will be
used to display the information from the PivotField object.
Applies only to fields used in the data area of the PivotTable.
Orientation Property: contains the location of the field in a PivotTable as
specified by the XlPivotFieldOrientation type (xlColumnField,
xlDataField, xlHidden, xlPageField, or xlRowField). Chapter 16
PivotItems Method: returns the collection of PivotItems representing the
individual items within a particular field.
Position Property: contains the relative position of the field within its
orientation.
ShowAllItems Property: when True, means that all items in the PivotTable
report will be displayed even if they don’t contain summary
data.
Value Property: contains the name of the specified field in the
PivotTable report.

355