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