Share via

2.2.5.5 Non-Worksheet PivotTables

  • Article

A PivotTable (section 2.2.5) with a PivotTable (section 2.1.7.40) part that is a target of an explicit relationship from a workbook (section 2.1.7.61) part, is specified to be a Non-Worksheet PivotTable. Non-Worksheet PivotTables provide a way for Charts (section 2.2.3) to be based on PivotTable data without having to show the data in a worksheet (section 2.1.7.62), for more information see [MS-ODRAWXML] section 2.6.1.21. A Non-Worksheet PivotTable MUST NOT be referenced by any other part than the workbook part.

There MUST be a BrtPivotCacheIdVersion (section 2.4.740) record between the BrtBeginPivotCacheDef (section 2.4.168) and BrtEndPivotCacheDef (section 2.4.518) records as defined by the PivotCache Definition (section 2.1.7.38) part ABNF, that specify the PivotCache (section 2.2.5.2) associated with a Non-Worksheet PivotTable.

The value of the bVerSxMacro field defined in the BrtBeginSXView (section 2.4.275) record associated with a Non-Worksheet PivotTable MUST be greater than or equal to 3.

The field rfxGeom of the BrtBeginSXLocation (section 2.4.254) record as specified by the SXLOCATION rule in the PivotTable (section 2.1.7.40) part ABNF, MUST have value 0 for its members rwFirst and colFirst.

The records BrtBeginSxEdits (section 2.4.246) and BrtEndSxEdits (section 2.4.596) as specified by SXEDITS rule in the PivotTable part ABNF MUST NOT exist in this PivotTable part.

The records BrtBeginSxChanges (section 2.4.236) and BrtEndSxChanges (section 2.4.586) as specified by SXCHANGES rule in the PivotTable part ABNF MUST NOT exist in this PivotTable part.

The records BrtBeginSXCondFmts (section 2.4.239) and BrtEndSXCondFmts (section 2.4.589) as specified by SXCONDFMTS rule in the PivotTable part ABNF MUST NOT exist in this PivotTable part.

The BrtBeginSXView (section 2.4.275) record that specifies a Non-Worksheet PivotTable MUST satisfy the following conditions.

  • The fEnableDataEd field MUST be 0.

  • The PivotTable name specified by the irstName field MUST be unique among all the Non-Worksheet PivotTables in the workbook.