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

  <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" 

Parent Elements


Child Elements


<definedName> (Defined Name)


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

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