Pivot table

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

Guest

I have a pivot table made from last year, I deleted all
of the data and I added some new data. When I go to the
dropdown to filter the data, the data from last year is
still a choice along with the new data. I would like to
delete this data from the choice on the filter, without
having to create a new pivot table. I have refreshed the
data, and I still have this problem. Any way to do this
with vba code. Thanks.
 
Set the MissingItemsLimit property of the pivotcache to xlMissingItemsNone

Jesse
 
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

Unable to Group in Pivot Table 1
Pivot Table Question 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Expand and collapse 2
Using VBA on Excel Pivot Tables 3
Pivot table multiple filters 2
Playing back a Pivot Table macros 2
Pivot Tables - delete rows from Master List 2

Back
Top