How to "show all" items in a Pivot Table via vba
 

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

How to "show all" items in a Pivot Table via vba
 

Doesn't seem to work in Excel 2003 either.

--
Regards,
Tom Ogilvy


"dotti" wrote in
message ...

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