Pivot table error message

[jaypatel]

Hi,

I need help with a pivot table i have.

The error message says "The PivotTable field name is not valid. To create a pivottable report, you must use data that is organised as a list with labelled columns. If you are changing the name of the pivottable field, you must type a new field name for the field"

I have re-created the pivot table, which gives the results i want, but when you refresh, the same message comes along.

Can someone tell me what i am doing wrong,

Cheers

Jay

 

[GlennUK]

Look at the field names, in the first row of the source data, look for blank cells ( not allowed ), or weird characters.