Thread: Pivot table field phantom data

Hi all,

I've recently been introduced to the greatness that is pivot tables, and I'm trying to understand an odd situation I've run into. I have some data which all had the same month value. I added some more data w/ a different month value to investigate showing and hiding data sets on the pivot tables and charts. However, after removing that new, different month data, it's still presented as a tick box for the month field in all the tables and charts. What's the right procedure to really clear out those entries? I've attached a picture of the phantom entries (circled in red) and the good entry (green). How do I get rid of the items in red from that listing?

-Adam

Hi,

I generally use the following procedure

Code:

Sub CleanPivotTables()
Dim pc As PivotCache
For Each pc In ActiveWorkbook.PivotCaches
    pc.MissingItemsLimit = xlMissingItemsNone
    pc.Refresh
Next pc

End Sub

HTH