Posted to Programming to get a faster reply.

"lj" <lj@spu.edu> wrote in message
news:1132600147.868091.262230@g14g2000cwa.googlegroups.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"
>