title: How to set up refresh sequence in Excel? Contain Database data and more layers of pivot table
body: <p>I have a work book links to 3 databases(<em><strong>SQL SERVER</strong></em>), and have 3 pivot table related to that 3 databases, then have an other pivot table related to 1 of the 1st layer pivot table, and have an other pivot chart related to 2nd layer pivot table.</p>
  <blockquote>
  <p>DB1 &gt; Pivot1 &gt; Pivot11 &gt; PivotChart111 &gt; MainReportView</p>
  <p>DB2 &gt; Pivot2 &gt; MainReportView</p>
  <p>DB3 &gt; Pivot3 &gt; MainReportView</p>
  </blockquote>
  <p>Now, because the default refresh is refresh from the lasted pivot chart back to database. I have to use refresh all for more than 3 times to get my final report view update.</p>
  <blockquote>
  <p>1st time refresh: pivotchart111(nochange)&gt;  Pivot11(nochange) &gt;
  Pivot1(nochange) &gt; DB1(change) result: Reportview(Nochange)</p>
  <p>2nd time refresh: pivotchart111(nochange)&gt;  Pivot11(nochange) &gt;
  Pivot1(change, detected DB1 changed from step 1) &gt; DB1(nochange)
  result: Reportview(partially change)</p>
  <p>and so on ....</p>
  </blockquote>
  <p><strong>Is there any other way I can tell Excel to refresh all DBs first, then all 1st layer pivot than 2nd layer pivot then 3rd layer pivotchart?</strong></p>
  <p>I try to use refresh all VBA, or RefreshPivot VBA but can't solve the problem.
  Also, I assign RefreshALL macro, but have to click that macro more than 4 times to get my report page update.</p>
  <p>THANKS IN ADVANCE!</p>