Usually, things go smoothly when you when you try to create a pivot table. However, occasionally you might see a pivot table error, such as "PivotTable field name is not valid". See how to troubleshoot and fix those errors.
Sometimes, if you try to create or refresh a pivot table, an error message appears:
“The PivotTable field name is not valid. To create a PivotTable 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.”
If we check the source data for this pivot table, everything looks okay. There are 7 columns of data, and no blank columns or rows in the list.
The pivot table error, "field name is not valid", usually appears because one or more of the heading cells in the source data is blank. To create a pivot table, you need a heading for each column.
Tip: If you create an Excel Table from your data, column headings are automatically added to columns with blank heading cells, and you can avoid this error.
To find the problem, try these steps:
If the steps above don't help you find and fix the problem, use the “List All Pivot Table – Headings” macro to see the details for all pivot tables.
Copy the code from that page, and paste it into a regular code module, then run the macro.
The macro lists each pivot table in the file, with the following information:
Also, if the source data is a list in the same Excel workbook, it shows details about the source data:
To see the pivot table error message, download the Pivot Table Errors sample file. The zipped file is in xlsx format, and does not contain macros.
Last updated: April 23, 2019 10:00 AM
Contextures RSS Feed