Posted to Programming to get a faster reply.

"lj" wrote in message
oups.com...
I have the following formula that I use in visual basic to update a
pivot table from a pivot table. I want to alter the formula to update
a pivot table from a set of data (that was brought in from a query to
excel). How do I alter my formula below?

Sheets("Commissions").Select
ActiveSheet.PivotTableWizard SourceType:=xlPivotTable,
SourceData:= _
"[Munge_Report.xls]Data!Query"