Excel pivot table field name

Asked By 0 points N/A Posted on -
qa-featured

While making a weekly report for my boss, I am facing the following error message in excel, “Pivot Table field name is not valid” time. I am not able to complete my report without using Pivot Tables. Need urgent help…..

SHARE
Best Answer by Alcaraz Jody
Answered By 0 points N/A #162140

Excel pivot table field name

qa-featured

 

Hello Densie

You have to check all the field names in the first row of your excel sheet. This error mostly arises whenever any of these field names is empty. Check all column names in the first row, edit the empty fields and then re-insert the pivot table hopefully your issue will be resolved.

Best Answer
Best Answer
Answered By 0 points N/A #162141

Excel pivot table field name

qa-featured

Dear Densiehope,

Pivot table is a great feature for summarizing data from different columns, So it depends on the name of these columns and it may be the main reason for your error message.

1-  Go to tools tab in excel.

2-  Then from tools tab select change data source, to check how your pivot table imports its data. And also check formulas used.

3-  Check the names you are using in Names Manager.

4-   Correct errors you find in the names or formulas and it should work correctly.

 

 

Login/Register to Answer

Related Questions