ConsolidationReference element (Reference element)

Contains the properties of a range data source.

Usage

      
<ConsolidationReference />

Element Information

Element type ConsolidationReferenceType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
Reference "Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element."

Child Elements

Element Description
FileName Contains the name of the file that contains the source range of a PivotTable report.
Name Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.
Reference Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.

Attributes

None.

Definition

      
<xsd:element name="ConsolidationReference" type="ConsolidationReferenceType" >
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp