I have an Excel 2010 workbook with a main table on one sheet and several Pivot Tables on other sheets. All of the columns have headings, all of the headings contain only text, there are no hidden columns. The pivot tables were working fine until I moved
a column in the table (from column F to B). The column contains a formula and I confirmed that it is calculating correctly. =INDEX(EMPLOYEES!B:B,MATCH(DATABASE!$E2,EMPLOYEES!A:A,0))
When I try to use an existing Pivot table or create a new one, I get the error message "The PivotTable field name is not valid. To create a pivot table report you must use data that is organized as a list with labeled columns, If you are changing the name
of a PivotTable field, you must type a new name for the field."
All the posted answers addressing this error message state the problem is unlabeled columns or values other than text in Row 1.
Since this is not the case, what are the other causes that would generate this error message? This is a large spreadsheet with many formulas and I don't want to start over.
And here I thought I was the only one with this problem. As with any other problem the error message means something to someone, if you know where to start. The comments made by AussieJim made me re-think my errors, and I figured it out, for my scenario.
My problem was very simple, but easy to overlook. I used a range and not a Named Range for my PivotTable. So, when I was done filtering the PT to make my chart everything was great, chart did the trick. But, when I closed and re-opened the report I got the error message in question. I ended up changing my PT source from the range I originally selected to creating a Named Range (I did mine in VBA but you can do it in the Name Manager) and whalla, error message gone!
Look at where you are pulling your source data from by selecting your Pivot Table, then go to PivotTable Tools > Change Data Source to check the data source, does it pull from a differnent location/cell than you thought?
Good luck!
SD
Report abuse
Details (required):
Thank you.
Reported content has been submitted
42 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.