title: Excel VBA - RefreshAll not updating pivot tables
body: <p>I have a template workbook, which has several data tables connected to sql connections, as well as some pivot tables who's sources are the data brought through.</p>
  
  <p>I was under the impression that <code>ActiveWorkbook.RefreshAll</code> would update all connections, then update the pivots. That in fact is what happens when I run the refresh all manually. However, when I run the VBA (which is actually in Access, but is correctly referenced etc) it updates the connections but NOT the pivot tables? </p>
  
  <p>I've tried <code>DoEvents</code> after the <code>RefreshAll</code> which had no effect.</p>
  
  <p>Is my only option now to run a <code>For each</code> through all the worksheets, data sources, pivot caches and refresh them that way?</p>