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