2.2.5.6 PivotValues

  • Article

The PivotValues collection is a collection of values that exist in the data area (section 2.2.5.3.8.1.4) of a PivotTable view (section 2.2.5.3). PivotValues contains a collection of PivotValueCell (section 2.2.5.6.1) data units that are organized as rows and columns (1) in the data area of the PivotTable view.

For a Non-Worksheet PivotTable (section 2.2.5.5), the values of PivotValues are specified by the BrtBeginSxvcells (section 2.4.271) and the BrtEndSxvcells (section 2.4.621) records.

For PivotTable structures on a worksheet (section 2.1.7.62), the values of PivotValues are specified by the cells of the worksheet cell table in the locations that are specified by the BrtBeginSXLocation (section 2.4.254) record and the BrtEndSXLocation (section 2.4.604) record.