VBA PivotTable Refresh seems to leave old data behind

[VenturSum]

Team,

The source data for a pivot table was recently updated.
The "Month" field previously showed: Oct, Nov & Dec
Now the "Month" field shows only: Jan

In the pivot table, when I click on the "Month"
and go to the Filter List, Oct, Nov & Dec are still there!!

The data items: Oct, Nov & Dec
do not appear in the Field: Month

Yet they still appear in the filter list.

Why is this?
How can I make these items disappear / removed?

John,
In Annapolis.

 

[AlphaFrog]

Right-click on any cell in your Pivot Table and select from the pop-up menu Refresh Data

 

[xenou]

More here:
http://www.contextures.com/xlpivot04.html

I usually take the field out of the PT and refresh the pivot table (without the field in it), then put the field back in - as described under "manually clear old items".

ξ

 

[VenturSum]

xenou,

The programmatic method lower on the page was just what I was looking to find.

Thank you,
John,
In Annapolis, MD

 

[VenturSum]

Xenou / anyone,

Please see your Contexture's link in the above post
and scroll down to the vba example.

Any thoughts of running the below code first as opposed to last?

I ask because I'd like to add pt.Update to the top section.
or does the below code do the same as pt.Update?

    '-- refresh all the pivot caches
    For Each pc In ActiveWorkbook.PivotCaches
        On Error Resume Next
        pc.Refresh
    Next pc

any thoughts?

John,
In Annapolis.