Hiding data in pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

VBA Pivot Table Error 1
Pivot table - unwanted lines 2
Playing back a Pivot Table macros 2
Pivot Table, Variable Inputs 1
Pivot table code question 2
remove/delete/hide/exclude all (Blanks) in a pivot table macro 3
Format Pivot total rows 2
VBA Pivot Table Change Criteria - Help?! 1

Back
Top