View original (French)

Pivot table update issue

EZV12 Posted messages 22 Status Membre -  
EZV12 Posted messages 22 Status Membre -
Hello,

Could you help me solve the issue with updating the Pivot Table? I have my database and the Pivot Table based on that database, and I recently encountered a problem with updating the data in the Pivot Table. A message pops up every time I click the "Refresh" button, the message is "The name of the Pivot Table field is not valid. To create a PivotTable report, you must use data in a list format with column labels. If you change the name of a PivotTable field, you need to type a new name for the field."

I don't quite understand this message, yet my database hasn't changed. I have always updated the Pivot Table without any issues every time I added new data.

Thank you for helping me find a solution.

Best regards.

2 réponses

Réponse 1 / 2
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 
Hello,

didn't you put a title in a merged cell?

If you want to upload your file to the forum, you need to go through https://www.cjoint.com/ (or another one!) and post the link obtained on the forum

Best regards
0
EZV12 Posted messages 22 Status Membre
 
Thank you for your response. No, I haven't placed a header in a merged cell.

Since the file contains confidential data, I can't upload it to the forum, sorry.

Do you have any idea where this problem might come from? Thank you.
0