INVALID name of the pivot table field
AL07_1104
Posted messages
1
Registration date
Status
Membre
Last intervention
-
DjiDji59430 Posted messages 4277 Registration date Status Membre Last intervention -
DjiDji59430 Posted messages 4277 Registration date Status Membre Last intervention -
Hello,
I need to update an Excel file every month by importing a .csv file that is supposed to refresh my monthly data. However, when I try to refresh, I get this same error message: "The name of the pivot table field is not valid. To create a pivot table report, you must use data in list form with column labels. If you change the name of a pivot table field, you must type a new name for the field."
I have no hidden columns, no merged or empty cells... and it worked in previous months, it's incomprehensible!
Does anyone have any other solutions that I haven't already tried?
I need to update an Excel file every month by importing a .csv file that is supposed to refresh my monthly data. However, when I try to refresh, I get this same error message: "The name of the pivot table field is not valid. To create a pivot table report, you must use data in list form with column labels. If you change the name of a pivot table field, you must type a new name for the field."
I have no hidden columns, no merged or empty cells... and it worked in previous months, it's incomprehensible!
Does anyone have any other solutions that I haven't already tried?
1 réponse
Hello everyone,
All you have to do is upload the faulty file to the forum using https://www.cjoint.com/ along with your version of Excel so that someone can look into your case.
Best regards
All you have to do is upload the faulty file to the forum using https://www.cjoint.com/ along with your version of Excel so that someone can look into your case.
Best regards