Forum Discussion
Solved
The PivotTable field name is invalid error
I have a multi-tab workbook with 14 tables and even more PivotTables. I am getting the error: The PivotTable name is invalid on Data tab Refresh All. Since this error does not point to a certain tabl...
Did you try to refresh PivotTables one by one, not by Refresh All?
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