Prev: Accessing the Data Connection Strings and Command Text (SQL) i
Next: Splitting a string into columns
From: AB on 1 May 2010 05:47
Do you want to refresh a QueryTable or a PivotTable? I'm not sure you
can refresh PivotTable by refreshing QueryTable.

For PivtTables i usually use something like this:
Workbooks(1).PivotCaches(1).Refresh
or
Worksheets(1).PivotTables(1).PivotCache.Refresh
First  |  Prev  | 
Pages: 1 2
Prev: Accessing the Data Connection Strings and Command Text (SQL) i
Next: Splitting a string into columns