[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

volTypes (Volatile Dependency Types)

Represents the collection of external dependencies for a workbook. This element defines the structure of the volatilateDependencies part. There can only be one volatileDependencies part for each workbook. However, the part may contain one or more dependency types.

The volatileDependencies part stores the following information for Real Time Data (RTD) and CUBE functions:

Cached values

Parameters used

Connection and Server names

[Example: Outline of XML Structure

<volTypes xmlns="…">
<volType type="realTimeData">
<volType type="olapFunctions">


end example]

Parent Elements

Root element of SpreadsheetML Volatile Dependencies part


Child Elements


extLst (Future Feature Data Storage Area)


volType (Volatile Dependency Type)


The following XML Schema fragment defines the contents of this element:

<complexType name="CT_VolTypes">


   <element name="volType" type="CT_VolType" minOccurs="1" maxOccurs="unbounded"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>