Error message when creating PivotTable

A

Alexandre

I selected the range of data to use for the table, but when I go to the
wizard and click "finish", I get the error message:The PivotTable name field
is not valid.

I made sure that the data are really neat, but that does not change anything!
Thanks for your help!
 
R

Roger Govier

Hi Alexandre

All columns used in a Pivot Table must have a heading in row 1.
If you want to include blank columns in the range, then type blank1,
blank2 etc in cell 1 of any such columns.
Make the font white and they won't show up to spoil the appearance of
your source data, but they will then enable the PT to work.
 
Top