title: refresh both the External data source and pivot tables together within a time schedule
body: <p>In my last post <a href="https://stackoverflow.com/questions/16151084/auto-refresh-pivottables-data-in-excel-on-first-run/16153407?noredirect=1#comment23085456_16153407">Auto refresh pivottables data in excel on first run</a>,  i found that on my <strong>first execution</strong> the <strong>query</strong> from the <strong>External data source</strong> is refreshed and takes approximately 1 min to execute. and in my second run, the pivot tables are updated.</p>
  
  <p>Is there a solution (<strong>VBA code</strong>) to refresh both the External data source and pivot tables together within a time schedule (If suppose we set a timer) by clicking <code>command button</code>?</p>