title: Refresh pivot tables but not external data source
body: <p>I have a spreadsheet with multiple tables, where the data is pulled from an external data source (SQL database).  The connections/tables refresh by changing an option in a drop down box and then pressing a button to run a VBA.</p>
  
  <p>Attached to each of these tables is a pivot table.  The pivot tables don't refresh with the tables.  If I try pressing refresh all I get the error;</p>
  
  <p>'Data Source name not found and no default driver specified'</p>
  
  <p>However if I go through the spreadsheet and hit refresh on each individual pivot table they update without the error.</p>
  
  <p>So either I need some way to get the pivot tables to refresh with the tables or have a button that refreshes only the pivot tables and not the external data connections.</p>
  
  <p>Any ideas appreciated, I don't know where to begin with this one!</p>