title: VBA: refreshing just one pivot table for each external data source
body: <p>Okay so I have the following code to refresh all the pivot tables in the active workbook:</p>
  
  <pre><code> For Each oSht In Active Workbook.Worksheets
  
      For Each oTab In oSht.PivotTables
  
        oTab.RefreshTable
  
      Next oTab
  
  Next oSht
  </code></pre>
  
  <p>However, I feel that this is inefficient because, when you refresh a pivot, it automatically refreshes all other pivots connected to the same data table.</p>
  
  <p>I would therefore like to refresh only one pivot table for each external data table i have in the active workbook but cant work out a way of implementing this...</p>