Hi,

i'm using Excel 2002 german:

How can I reset a pivot table to show all items (select all avaiable
checkboxes) like in the drop down menu via vba?

Currently I realized it with a for loop, but it requires a lot of time
and memory.

What about .showAllItems = True; this seems not to work!


Thx so far,

dotti


--
dotti
------------------------------------------------------------------------
dotti's Profile: http://www.excelforum.com/member.php...o&userid=24114
View this thread: http://www.excelforum.com/showthread...hreadid=377187