Error message when creating PivotTable
 

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!

Error message when creating PivotTable
 

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.

--
Regards

Roger Govier


"Alexandre" wrote in message
...
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!