[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

s: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a non-OLAP slicer item is selected.

Value	Meaning
"true"	A non-OLAP slicer item is selected.
"false"	A non-OLAP slicer item is not selected.

nd: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a non-OLAP slicer item does not have data associated with it. This attribute MUST NOT exist if the crossFilter attribute of the CT_TabularSlicerCache element is equal to "none". For more information, see Slicer Cross Filtering.

Value	Meaning
"true"	A non-OLAP slicer item does not have data associated with it.
"false"	A non-OLAP slicer item has data associated with it.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.86 CT_PivotTableReferences

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: pivotTableReferences

A complex type that specifies a list of PivotTable ([ISO/IEC29500-1:2011] section 18.10) part identifiers for Non-Worksheet PivotTables. MUST contain fewer than 2³¹ elements.

Child Elements:

pivotTableReference: A CT_PivotTableReference element that specifies a PivotTable part identifier of a Non-Worksheet PivotTable.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.87 CT_PivotTableReference

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_PivotTableReferences

A complex type that specifies a relationship identifier to a PivotTable ([ISO/IEC29500-1:2011] section 18.10) part in this workbook. The PivotTable specified by the element pivotTableDefinition ([ISO/IEC29500-1:2011] section 18.10.1.73) identified by this type MUST be a Non-Worksheet PivotTable and MUST satisfy the following criteria.

 The ref attribute of the child element location ([ISO/IEC29500-1:2011] section 18.10.1.49) MUST begin with "A1".

 The enableEdit attribute of the CT_PivotTableDefinition element, as specified in section 2.6.32, MUST NOT exist or MUST be "false" if exists; CT_PivotEdits and CT_PivotChanges elements MUST NOT exist in this part.

 The PivotTable name specified by the name attribute of the element pivotTableDefinition ([ISO/IEC29500-1:2011] section 18.10.1.73), MUST be unique among all the PivotTables in the workbook.

 There MUST be a child CT_PivotCache ([ISO/IEC29500-4:2011] section A.2) element within the pivotCaches element, specified by section 2.4.39, with the attribute cacheID having the same value as the cacheId attribute of the element pivotTableDefinition ([ISO/IEC29500-1:2011] section 18.10.1.73).

 The PivotTable MUST NOT have CT_ConditionalFormats element as specified by section 2.6.49.

Attributes: