The PivotTable Field name is not VALID.

Question

I have a August pivot chart that it is working very well.

Then I dragged the sheet tab to create September and select CHANGE DATA SOURCE., then pick the September and was able to create the September pivot chart without problem.

However, when I wanted to create October. I did the same steps when I create September. But when I click OK and I selected the October data, I got this window message.

I do not understand where is the problem because I created September without problem. Besides I did not change any fields.

Could you please tell me how can I fix this problem.

Thanks,

Answer 1

It seems like the error message you are receiving is related to the field name in your October data source. The error message is indicating that the field name is not valid.

To resolve this issue, you can try the following steps:

1. Check the field names in your October data source and make sure they are spelled correctly and do not contain any special characters or spaces.
2. Ensure that the field names in your October data source match the field names in your previous data sources (August and September).
3. If the field names in your October data source are different from the previous data sources, you can try renaming them to match the previous data sources.
4. If none of the above steps work, you can try creating a new PivotTable using the October data source and see if the issue persists.