MS Excel has a powerful feature called Pivot table that can be used lớn provide a summary of a vast chunk of data. However, if you are not careful while creating the pivot table, you are likely to lớn encounter the following error –
Pivot Table field name is not valid
In this article, let us discuss the causes of seeing this and possible fixes to overcome the Pivot Table field name is not valid error.
Bạn đang xem: Pivot table field name is not valid
Pivot Table field name is not valid error
This error is mostly seen during the creation or when you try lớn refresh the pivot table. This happens when there are one or more blank heading columns in the data.
Consider the below data,
When you try khổng lồ create a pivot table, you see an error as follows,
Fixes khổng lồ solve the error – Pivot Table field name is not valid
Fix 1: Create an Excel Table from the data và then turn it into a Pivot Table
When an Excel Table is created, headings to lớn the blank columns are added automatically.
Step 1: Select the required data
Step 2: Click on Insert from the top-menu
Step 3: Click on Table
Step 4: In the Create Table window that opens, verify the data range
Step 5: Click on OK
Fix 2: Verify the Range in the Create Pivot Table dialog box
At times, by mistake, the blank column next to lớn the last column will be selected.
In the Create Pivot Table Dialog, under Select a table or range section, ensure that the range specified does not contain blank columns.
Fix 3: kiểm tra if columns with blank headings are hidden
Step 1: Select all the columns within the Pivot table & then right-click on it
Step 2: Choose Unhide from the context menu.
Fix 4: Unmerge the merged cells in Heading Row
Step 1: Identify the Merged Cell within the Heading Row và click on it
Step 2: From the vị trí cao nhất menu, click on Home
Step 3: Click on the downward arrow next to lớn Merge và Center
Step 4: Choose Unmerge Cells
Fix 5: kiểm tra if the Heading name has overlapped with a blank heading next to lớn it
Consider the below example, Serial Number from column A has overlapped B
Step 1: Click on each column & verify its content in the formula bar. Refer khổng lồ the below example, A1 has the value Serial Number
Step 2: Repeat the same process và identify the blank cell.
Step 3: Once identified, give a suitable heading.
Things to lớn remember to avoid the Pivot Table field name is not valid Error :
Column Headings cannot be blankProper range should be selected while creating the Pivot TableBlank columns shouldn’t be present in the range.That’s All
We hope this article has been informative. Thank you for Reading.
Anusha Pai
Anusha Pai is a Software Engineer having a long experience in IT industry and having a passion to write.
Xem thêm: Tổng Hợp Lỗi Không Vào Được Fifa Online 4 Mới Nhất (30S Xong)
Related Posts:
Filed Under: excel
Reader Interactions
Leave a Reply Cancel reply
Your thư điện tử address will not be published.