Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Selecting Items
Is there a way to select certain Pivot items based on a data source that
changes frequently? If all the items were included it would be 5 items, "A - E" I only want to show A, B, and C. I'm familar with the ....Visible=True statement, however what if B doesn't exist in the data source for this week, however it was last week. ......PivotItems("A").Visible = True Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Selecting Items
You could use something like this:
On Error Resume Next .PivotItems("A").Visible = True .PivotItems("B").Visible = True .PivotItems("C").Visible = True On Error GoTo 0 AK wrote: Is there a way to select certain Pivot items based on a data source that changes frequently? If all the items were included it would be 5 items, "A - E" I only want to show A, B, and C. I'm familar with the ....Visible=True statement, however what if B doesn't exist in the data source for this week, however it was last week. .....PivotItems("A").Visible = True Thanks in advance -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - old items | Excel Discussion (Misc queries) | |||
How I can create a Pivot table by selecting two Different Pivot | Excel Worksheet Functions | |||
Pivot Table Items | Excel Discussion (Misc queries) | |||
Pivot table items | Excel Discussion (Misc queries) | |||
Selecting Rows in Pivot Table | Excel Programming |