Posted to microsoft.public.excel.programming
|
|
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
|