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!
|