View original (French)

Pivot table update issue

EZV12 Posted messages 22 Status Member -  
EZV12 Posted messages 22 Status Member -
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 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   718
     
    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
    1. EZV12 Posted messages 22 Status Member
       
      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