PivotData Object

Multiple objects PivotData Multiple objects

Represents the data in a PivotTable list.

Using the PivotData Object

The following properties return a PivotData object:

• The Data property of the following objects: PivotCell, PivotResultAxis , PivotResultColumnAxis , PivotResultDataAxis, PivotResultFilterAxis, PivotResultGroupAxis, PivotResultPageAxis, and PivotResultRowAxis.

• The PivotTable object's ActiveData property.

Properties | Cells Property | CellsEx Property | ColumnAxis Property | Control Property | CurrentCell Property | DataAxis Property | DetailLeft Property | FilterAxis Property | IsConsistent Property | Label Property | Left Property | Left2 Property | LeftOffset Property | PageAxis Property | Range Property | Recordset Property | RowAxis Property | Top Property | Top2 Property | TopOffset Property | View Property | ViewportLeft Property | ViewportTop Property

Methods | HideDetails Method | MoveLeft Method | MoveTop Method | ShowDetails Method

Parent Objects | IPivotControl Object | PivotCell Object | PivotResultAxis Object | PivotResultColumnAxis Object | PivotResultDataAxis Object | PivotResultFilterAxis Object | PivotResultGroupAxis Object | PivotResultPageAxis Object | PivotResultRowAxis Object | PivotTable Object

Child Objects | IPivotControl Object | PivotCell Object | PivotColumnMember Object | PivotRange Object | PivotResultColumnAxis Object | PivotResultDataAxis Object | PivotResultFilterAxis Object | PivotResultLabel Object | PivotResultPageAxis Object | PivotResultRowAxis Object | PivotRowMember Object | PivotView Object

See Also | ActiveData Property