Pivot Table Selecting Items

A

AK

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
 
D

Debra Dalgleish

You could use something like this:

On Error Resume Next
.PivotItems("A").Visible = True
.PivotItems("B").Visible = True
.PivotItems("C").Visible = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Items Visible 1
Change report firlds in pivot tables and charts with one selection 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Pivot Table Filtering - Macro 3
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Pivot table - unwanted lines 2
Pivot Table - How do I "Show All Data" of a particular field? 6
loop on pivot items 0

Top