What if the Excel PivotTable field name is not valid?

When you insert a PivotTable report, you often jump out of a field name is not valid prompts, do not know what the reason, also do not understand how to deal with this problem, the following has a good solution, we can refer to.

Description: Excel does not do a pivot table, display PivotTable field name is not valid. When you create a PivotTable report, you must use data that is grouped together with a list of flagged columns. This is the same as the previous perspective, there is no problem, today suddenly do not.

Resolve: The selected header row is a blank field, a hidden blank field.

Or:

The first row (field row) of the data range has merged cells, please fix it. In fact, to do a good job of PivotTable reports, the range of data best matches the standard list format without merging cells.

Specific steps

1, with this data table as an example of inserting a PivotTable report

2, after the completion of the settings can not enter the PivotTable page, but the field name is not valid prompts.

3, turn to check the original image, you can see that the header row has a cell is blank, which is the reason the field name is invalid.

4, add a title to it "total score", insert the pivot table to see.

5, now will not jump out of the error prompts, its PivotTable report is completed.

Attention matters

One of the main reasons is that the header name is empty, and one is that the header row has a merged cell, which is restored to a standard cell and has a caption to continue creating the pivot table.

The reason above is that the field name does not match the main reason, encountered such a hint can first find whether to commit the two errors mentioned in this article.

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join