title: How to take data from PivotTable cache?
body: <p>I have lost the connection to source analytics service. However, I still have data in PivotTable's cache (I can see from tooltips).</p>
  
  <p>How to get that source data?</p>
  
  <ul>
  <li>I am using Office365</li>
  </ul>
  
  <p>** I cannot use show details since the pivot table has some filteres applied. And i cannot remove filters since it asks me to connect source.</p>
  
  <p>(And yes I have checked this thread but it didn't work for me: <a href="https://stackoverflow.com/questions/1442316/excel-vba-recreate-source-data-from-pivot-table-cache">Recreate Source Data from PivotTable Cache</a>. It gives 1004 error.)</p>