View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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!