definedNames (Defined Names)

This element defines the collection of defined names for this workbook. Defined names are descriptive names to represent cells, ranges of cells, formulas, or constant values. Defined names can be used to represent a range on any worksheet.

[Example:

<definedNames>
<definedName name="NamedFormula"
comment="Comment text for defined name.">SUM(Sheet3!$B$2:$B$9)</definedName>
<definedName name="NamedRange">Sheet3!$A$1:$C$12</definedName>
<definedName name="NamedRangeFromExternalReference" localSheetId="2"
hidden="1">Sheet5!$A$1:$T$47</definedName>
</definedNames>

end example]

Parent Elements

workbook (§3.2.27)

 

Child Elements	Subclause
definedName (Defined Name)	§3.2.5

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

<complexType name="CT_DefinedNames">

   <sequence>

   <element name="definedName" type="CT_DefinedName" minOccurs="0" maxOccurs="unbounded"/>

   </sequence>

</complexType>