ChangingPivot Table programmatically
 

Hey guys,

I have a pivot table and when you right click it and
select Wizard the Pivot Table Wizard Step 3 of 3 dialog
pops up. I then can change what fields the pivot table
displays by clicking on the Layout button. Now lets say I
currently have the field Sum of EID in the data section of
the table. I want to remove this field and add the field
BID into the data section. I then want it to display the
SUM of field BID. To do this manually I simply drag and
drop the feild BID into the data section of the table
wizard and then double click the field and select SUM.
Then I click OK. And then I click finish. If I wanted to
do this programmatically, how would I do this? What is
the code to do this?

Thanks.


Todd Huttenstine

ChangingPivot Table programmatically
 

Turn on the macro recorder as you manually perform the steps, and it
will create the code for you.


Todd Huttenstine wrote:
I have a pivot table and when you right click it and
select Wizard the Pivot Table Wizard Step 3 of 3 dialog
pops up. I then can change what fields the pivot table
displays by clicking on the Layout button. Now lets say I
currently have the field Sum of EID in the data section of
the table. I want to remove this field and add the field
BID into the data section. I then want it to display the
SUM of field BID. To do this manually I simply drag and
drop the feild BID into the data section of the table
wizard and then double click the field and select SUM.
Then I click OK. And then I click finish. If I wanted to
do this programmatically, how would I do this? What is
the code to do this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html