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...
I have this error as well, and no columns have changed. I add a few rows at the bottom of my data sheet and I can't refresh any pivot tables at all.
can u upload a dummy sample file?
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.
