changing pivot fields in vba

[esukkar]

Hi I have a pivot table, I have a pivot field with about 100 different
items in it. I want to create a macro that will hide the currently
visible field item, and display the one selected in a dropdown.
However, if I make the selected one visible and create a loop to go
through all the field items and make the ones that dont match the
selected on to invisible, it takes about 1 aminute to run as there are
over 100 field items, and there are 9 pivot tables.

is there a way to do the following...


start
a = currently visible pivot item
b = new pivot item I want visible
make b visible
make a invisible
end


instead of looping through all the pivot field items.
note that there is only ever one pivot filed item displaying at a time

 

[Cindy M.]

I have a pivot table, I have a pivot field with about 100 different

items in it. I want to create a macro that will hide the currently
visible field item, and display the one selected in a dropdown.

Since you haven't gotten any answer here, I suggest you try asking in
the Excel.programming newsgroup, where you're more likely to find the
Excel specialists.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail