<ST_SourceType> (PivotCache Type)

This simple type defines the cache types for PivotTables.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<consolidation> (Consolidation Ranges)

Indicates that the cache contains data that consolidates ranges.

<external> (External)

Indicates that the cache contains data from an external data source.

<scenario> (Scenario Summary Report)

Indicates that the cache contains a scenario summary report

<worksheet> (Worksheet)

Indicates that the cache contains worksheet data.

Referenced By

<cacheSource@type> (§3.10.1.7)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_SourceType">
	<restriction base="xsd:string">
	<enumeration value="worksheet"/>
	<enumeration value="external"/>
	<enumeration value="consolidation"/>
	<enumeration value="scenario"/>
	</restriction>
</simpleType>