Forum Discussion
Pivot table won't refresh.
I'm getting an error when I try to refresh PivotTable data - and it's not updating a field I've made changes to. The error message is: "The pivot table field name is not valid. To create a valid Piv...
Probably, you are trying to refresh a pivot table where the columns in the source data may have changed.
to fix the issue, try to remove the pivottable labels, refresh then see whether you can still find those columns in the pivottable fields.