Forum Discussion
The PivotTable field name is invalid error
Did you try to refresh PivotTables one by one, not by Refresh All?
Doesn't the error message say "The PivotTable field name is not valid"?
The most probable cause of that problem is that the data source of one of the pivot tables on the Data sheet has an empty column header, either because it was left empty, or because the data source contains too many columns.
You'll have to check that manually, I'm afraid.
HansVogelaar thank you for the reply. I have checked all of my data tables and pivot tables several times. This is the first I've heard of too many columns. How many is too many?
Ken
I meant that the data source includes empty columns to the right of the actual data.
Hello Hans,
I wanted to let you know I found my Pivot Table error using SergeiBaklan suggestion of refreshing tables individually. The problem was, I had added a column to a pivot that was using the data model which required I form two new relationships. I added one new filter which pushed the table data source down one more line. This moved the column labels down but the defined data source stayed the same starting one row higher.
I've learned quite a bit from you.
Thank you for your contributions to this community.
Ken
Did you try to refresh PivotTables one by one, not by Refresh All?
- Sergei,
Thank you for the suggestion of refreshing one-by-one. This led me to the problem pivot table.
The problem was, I had added a column to a pivot that was using the data model which required I form two new relationships. I added one new filter which pushed the table data source down one more line. This moved the column labels down but the defined data source stayed the same starting one row higher.Sorry, afraid I can't say something concrete without playing with data model.