| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table refresh reverts to "Show all" | Excel Discussion (Misc queries) | |||
| Hide "Show details" when right click on data field in Pivot Table | Excel Discussion (Misc queries) | |||
| How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
| "Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) | |||
| Pivot Table "Include hidden items in totals" | Excel Discussion (Misc queries) | |||
Linear Mode
