Excel Pivot Table- Row Labels not updating

[itzvicc]

Hello-

I have created a pivot table. I use a macro button to update the pivot table. It is not picking up all of the row lables (current months). for some reason i can get it to do anything but add all the row lables (months) and hide the blank(s).

' MonthlyPivotTableUpdatePivot3 Macro
' Update the Monthly Summary Pivot Table

' unlock sheets to update table
Sheets("Monthly Summary").Select
ActiveSheet.Unprotect Password:="4321"

' screen updateing
Application.ScreenUpdating = False

' show all months on the pivot table
Sheets("Monthly Summary").Select
ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh
With ActiveSheet.PivotTables("PivotTable3").PivotFields("Month/ year")

' remove pivot table blanks
With ActiveSheet.PivotTables("PivotTable3").PivotFields("Month/ year")
.PivotItems("").Visible = False
.PivotItems("(blank)").Visible = False

 

[Rastaman]

itzvicc,
Not sure what's going on in your code, you have With statements but no End With, so what you've shown here won't run. However, are the Month/ Year values that you are expecting actually listed in the drop down pick list for this pivot field? If so, take a look at the field settings for the Month/ Year field. If the check box at the bottom, "Include new items in manual filter" is unchecked, then you may want to try it with this setting enabled. This way when new data is added to the pivot it will be included in what the pivot reports.
Rick