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



wrote in message
...
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.