Cell C2
The formula expressed in cell C2
(cell C2
is the <c>
element whose @r is
C2
)
is this:
[2]!NameInExternalWorkbook
The external reference to another workbook in this case is tokenized to [2]
. The value inside the brackets is a 1-based index to the <externalReferences>
collection in the workbook part.