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

minimalRefreshVersion: An unsignedInt attribute ([XMLSCHEMA2] section 3.3.22) that specifies the minimum application version required to refresh the Timeline cache.

lastRefreshVersion: An unsignedInt attribute that specifies the application version that last refreshed the Timeline cache.

pivotCacheId: An unsignedInt attribute that specifies the associated OLAP PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache. This element MUST be equal to the pivotCacheId attribute of an existing CT_PivotCacheDefiniton element (section 2.6.33).

filterType: An ST_PivotFilterType attribute ([ISO/IEC29500-1:2011] section 18.18.59) that specifies type of the filter ([ISO/IEC29500-1:2011] section 18.10.1.33) used in the Timeline.

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.117 CT_WorkbookPr

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

Referenced by: workbookPr

CT_WorkbookPr is a complex type that specifies additional properties for a workbook.

Attributes:

chartTrackingRefBase: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies how data point properties and datalabels in all charts ([ISO/IEC29500-1:2011] section 21.2) in this workbook behave.

Value	Meaning
True	Datapoint properties and datalabels ([MS-ODRAWXML] section 2.2.1.2) in all charts ([ISO/IEC29500-1:2011] section 21.2) in this workbook follow their reference.
False	Datapoint properties and datalabels ([MS-ODRAWXML] section 2.2.1.2) in all charts ([ISO/IEC29500-1:2011] section 21.2) in this workbook follow their position in the chart.

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.118 CT_TimelinePivotFilter

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

Referenced by: CT_TimelineCacheDefinition

A complex type that specifies the filter used by the Timeline Cache (section 2.1.7) to filter PivotTable ([ISO/IEC29500-1:2011] section 18.10) views and Non-Worksheet PivotTables.

Child Elements: