Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding data in pivot tables
I am trying to alter the data items that are displayed inside a pivot table.
This hides everything except the first item - but it recalculates the table after everytime it changes one of the properties. I would like to stop this so that there is only one recalculation made when all of the properties have been set. For i = 2 To j ActiveSheet.PivotTables("PivotTable3").PivotFields ("Invoice Date").PivotItems.Item(i).Visible = False Next I would also like a bit of code that is equivalent to ticking the "(show all)" box in the drop down list on the pivot table. Any help appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding data in pivot tables
Turn on the macro recorder while you tick ShowAll.
-- Regards, Tom Ogilvy "rikky" wrote in message ... I am trying to alter the data items that are displayed inside a pivot table. This hides everything except the first item - but it recalculates the table after everytime it changes one of the properties. I would like to stop this so that there is only one recalculation made when all of the properties have been set. For i = 2 To j ActiveSheet.PivotTables("PivotTable3").PivotFields ("Invoice Date").PivotItems.Item(i).Visible = False Next I would also like a bit of code that is equivalent to ticking the "(show all)" box in the drop down list on the pivot table. Any help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | 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 | |||
Hiding rows containing zeroes or blanks in pivot tables? | Excel Discussion (Misc queries) | |||
About Hiding Fields in Pivot Tables | Excel Discussion (Misc queries) |