title: Excel2013 "Cannot open PivotTable source file" during "Update All"
body: <p>I have an old bloated Excel workbook that I am trying to strip down.
  After I replaced all the external and computed internal data source with <code>table</code>s linked to SQL database queries, every time I do a <code>Update All</code>, Excel always complain  <code>“Cannot open PivotTable source file xxxxxx[yyyy]|zzzz”</code></p>
  
  <p>I reviewed nearly every sheet, but failed to find anything referencing the external Excel file in question. <del> Is there any way to locate which cell, at least in which sheet, this pivotable in question  is? </del></p>
  
  <p>Looks like the cached data is no longer referenced. (see PS2) 
  Is there anyway to purge these cached entries without manually editing the XMLs ?</p>
  
  <p>Thanks.</p>
  
  <p>PS1:
  I have tried the VBA way inspecting the ActiveWB.LinkSource(1)
  It didn't work, all it gives me is a worksheet referenced in a cell that I already know. The worksheet mentioned in the error alert is not listed.</p>
  
  <p>PS2:
  I saved file to xlsx unpackd internal XMLs, a simple grep gives me </p>
  
  <pre><code>$ grep '20160229-9' -r .
  ./xl/pivotCache/_rels/pivotCacheDefinition1.xml.rels:
  &lt;Relationships xmlns="http://schemas.../relationships"&gt;
  &lt;Relationship Id="rId2" Type="http://schemas.../externalLinkPath" Target="OrderList20160229-9.xlsb" TargetMode="External"/&gt;
  &lt;Relationship Id="rId1" Type="http://schemas...relationships/pivotCacheRecords" Target="pivotCacheRecords1.xml"/&gt;
  &lt;/Relationships&gt;
  </code></pre>
  
  <p>But PivotTable1's datasource has already been replaced with a SQL query piped table side by side on the same sheet...</p>
  
  <p>Inspecting the referred pivotCacheRecords1.xml, I got the very old copy of the source table (the new sql query based table has a different format, I can't find the items in these data anywhere in excel either.). Its no longer valid any more. Hmm, is this a bug ?</p>