title: Recreate Source Data from PivotTable Cache
body: <p>I am trying to extract the source data from a PivotTable that uses a PivotTable cache and place it into a blank spreadsheet. I tried the following but it returns an application-defined or object defined error.</p>
  
  <pre><code>ThisWorkbook.Sheets.Add.Cells(1,1).CopyFromRecordset ThisWorkbook.PivotCaches(1).Recordset
  </code></pre>
  
  <p><a href="http://msdn.microsoft.com/de-de/library/microsoft.office.interop.excel.pivotcache.recordset%28office.11%29.aspx" rel="noreferrer">Documentation</a> indicates that PivotCache.Recordset is an ADO type, so this ought to work. I do have the ADO library enabled in references.</p>
  
  <p>Any suggestions on how to achieve this?</p>