[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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