<externalBook> (External Workbook)

This element represents an external workbook which is supplying data to the current workbook.

Parent Elements


Child Elements


<definedNames> (Named Links)


<sheetDataSet> (Cached Worksheet Data)


<sheetNames> (Supporting Workbook Sheet Names)




<id> (Relationship to supporting book file path)

Namespace: .../officeDocument/2006/relationships

Relationship ID that references a link in the <relationships> collection. The @target attribute in the associated <relationship> will specify the worksheet XML file in the current spreadsheetML document ZIP archive that makes use of this @externalbook.

The possible values for this attribute are defined by the ST_RelationshipId simple type (§

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

<complexType name="CT_ExternalBook">
	<element name="sheetNames" type="CT_ExternalSheetNames" minOccurs="0" maxOccurs="1"/>
	<element name="definedNames" type="CT_ExternalDefinedNames" minOccurs="0" maxOccurs="1"/>
	<element name="sheetDataSet" type="CT_ExternalSheetDataSet" minOccurs="0" maxOccurs="1"/>
	<attribute ref="r:id" use="required"/>