Run-time Error '1004' Pivotfield name is not valid

**polooop** · 02-18-2014, 01:02 PM

Hello everybody,

I'm quiet but not really a beginner in VBA and today i went on an error which it seems, i can t solve alone. So i'm asking your help there. I'm doing a project consisting in "variance" analysis on several excel tables and everything worked fine till i get to the end but today, i just update the different tables and now get this error 1004 saying :

"Run-time error '1004': The Pivot Table field name is not valid. To create a Pivot Table report, you must use data that is organized as a list with labeled columns. If you are changing the name of the Pivot Table field, you must type a new name for the field."

As in my different tables I don t see any difference on the first row and not any blank i wonder from where it could be coming.

Here a part of my code may be someone will see what is wrong here. (It worked fine till today!)

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

The error occurs on the last line.

Please someone help me!

**Norie** · 02-18-2014, 01:15 PM

Have you checked the field names in the raw data to see if they are suitable for a pivot field name?

**polooop** · 02-19-2014, 04:45 AM

Thank you so much Norie

i've now found what was going on. My PivotTable was created with a field that was included in the raw datas but still not created at this point of the program (created by the next module). You helped me a lot with your hint thanks again! I was searching elsewhere for the error and i could have been still searching without your help.

Ps: Sorry for code tags I had written this post at the end of my workday so I tried to be fast but next time i'll put em in!