Excel pivot table field name

Asked By densiehope 0 points N/A Posted on - 11/24/2012

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…..

• Status: Open
• Question Views: 1032
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Alcaraz Jody

Go To Solution

Answered By Parthy Goan 0 points N/A #162140

Excel pivot table field name

 

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.

About Parthy Goan

Questions
1

Answers
100

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 11/24/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Alcaraz Jody 5 points N/A #162141

Excel pivot table field name

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.

 

 

About Alcaraz Jody

Questions
2

Answers
100

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 12/22/2012
• Question Category: MS Excel