Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to Show All Pivot Table Items
I have a pivot table and a user form that allows the user
rearrange the pivot table by just clicking a button. The problem I'm having is when they hide items from a field then rearrange the table, those items remain hidden. Is there a code I can write that checks the "(Show All)" option on a field before my other code runs to alter the pivot table? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - show items with no data | Excel Discussion (Misc queries) | |||
Show Pivot Table Items That Have No Data | Excel Discussion (Misc queries) | |||
Using Code to show all pivot items | Excel Discussion (Misc queries) | |||
Pivot table-show all grouped items | Excel Discussion (Misc queries) | |||
Pivot Table - show items with no data | Excel Discussion (Misc queries) |