Pivot table Page field Name Switch

[goldfish]

I have a macro that accidentally tried selecting a page field (New York) item that didn't exist. This renamed the currently selected page field (Alabama) to the value I tried to select (New York).

I now have 3 or 4 values that are now wrong. Is there a way to refresh these pivot table values to the correct values without recreating the pivot table from scratch?

 

[DRANDON]

You have to refresh the Pivot Table Cache (PivotCache)

try this code -

Sub Clean_AllPivotsOnSheet()
Dim pt As PivotTable
For Each pt In ActiveSheet.PivotTables
pt.PivotCache.MissingItemsLimit = xlMissingItemsNone
Next pt
msgbox "Done."
End Sub

Then refresh the Pivot Table. Note: you may have to remove the Field (State or whatever) and reinsert - then refresh the Pivot Table.

 

[goldfish]

Thank you.