Pivot XML fragment

In this example, the PivotTable data cache records /cacheSource@connectionId="2", which associates this PivotTable to the connection whose @id="2" in the workbook connections part.

<pivotCacheDefinition … saveData="0" refreshedBy="Chad Rothschiller"
  refreshedDate="2006-04-13T16:02:14" backgroundQuery="1"
    createdVersion="3"
  refreshedVersion="3" minRefreshableVersion="3" recordCount="0">
  <cacheSource type="external" connectionId="2"/>
  <cacheFields count="2">
   <cacheField name="[Category].[Category Description]"
     caption="Category 
     Description" numFmtId="0" hierarchy="1" level="1">
     <sharedItems count="4">
       <s v="[Category].[All Category].[Current Year's Actuals]"
         c="Current Year's Actuals"/>