Share via

2.3.4 PivotValues

  • Article

PivotValues specifies the collection of values that are in the PivotTable ([ISO/IEC29500-1:2016] section 18.10) data area. The PivotValues contain a collection of PivotValueCells organized as a two dimensional array corresponding to the PivotTable ([ISO/IEC29500-1:2016] section 18.10) data area.

For a Non-Worksheet PivotTable the PivotValues are specified by the pivotTableData element (section 2.4.63).

For PivotTables on a worksheet the PivotValues are specified by the cells of the worksheet ([ISO/IEC29500-1:2016] section 18.3) cell table in the locations specified by the location element ([ISO/IEC29500-1:2016] section 18.10.1.49) of the PivotTable.