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...
Hey! I know this post is old, but I had the same issue thought I'd share the solution I found in case it helps others. If I update the Pivot Table source to use the name of the table that is being refreshed (found in the Name Manager on the Formulas tab) it refreshes successfully.
Good. thanks for sharing.