Error message when creating PivotTable

G

Guest

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

Guest

Hi
When specifying the data range to be used for a pivot table each cell in the
first row is considered to be the heading for that column. You need to make
sure that every cell in the header row has a heading. Hope this helps
Elise
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RUN TIME ERROR 1004--The PivotTable field name is not valid. 1
Cannot open pivottable source file error 3
The PivotTable field name is not valid (error) 1
Pivottable locks up the worksheet selection tab 3
"Run-Time Error '1004' 2
Function to return a range of cells from a PivotTable 2
Creating a PivotTable w/o selecting data in an existing PivotTable 6
ODBC PivotTable Error 1

Top