Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying data in pivot tables
I am trying to alter the information displayed in a pivot table. The problem
I have is that the pivot table refreshes itself after the property has been set for each item. I would like to stop this happening until all of the items have changed and then do one refresh at the end. For i = 2 To j ActiveSheet.PivotTables("PivotTable3").PivotFields ("Invoice Date").PivotItems.Item(i).Visible = False Next Conversely I would also like to be able to 'tick' the equivalent of the "(show all)" box in the drop down list. Any help is apprecitated. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying report filters on Excel Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Data Tables - Displaying | Charts and Charting in Excel | |||
Displaying symbols in charted data tables | Charts and Charting in Excel |