I have a pivot table that I've updated each month for a few years and now I get and error message when I try to 'Change the Data Source":

"The PivotTable field name is not valid. To create a PivotTable report you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field."

I have not changed anything on this report, and don't understand why this message pops up and prevents me from 'Changing the Data Source' which is merely adding a few more rows!!!

If anyone can shed some light on this I'd appreciate learning how to fix this.

Thank you,

Rob