| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help setting PivotItems...
Is there a code to "ShowAll" in a PivotField? I have written a code that
correctly sets the visible property of unwanted dates to False. When I refresh the PivotTable to a new list, I must show all items to run the code again. Every time I try to run a code to set all items to true, I get a run-time that says I cannot set the visible property of the PivotItem Class. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help setting PivotItems...
Give this a look...
http://www.contextures.com/xlPivot03.html -- HTH... Jim Thomlinson "Sam" wrote: Is there a code to "ShowAll" in a PivotField? I have written a code that correctly sets the visible property of unwanted dates to False. When I refresh the PivotTable to a new list, I must show all items to run the code again. Every time I try to run a code to set all items to true, I get a run-time that says I cannot set the visible property of the PivotItem Class. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Many PivotItems' Visible property to False | Excel Programming | |||
| PivotItems Bug?! | Excel Programming | |||
| Adding PivotItems | Excel Programming | |||
| Trouble setting visible property for PivotItems | Excel Programming | |||
| Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming | |||
Linear Mode
