Pivot Tables - Field Error

G

Guest

I'm getting the following error when trying to create a pivot table.
"The PivotTable name is not valid. To create a PivotTable report, you must
use data that is organised as a list with labeled columns. If you are
changing the name of a PivotTable field, you must type a new name for the
field".

The data is in a Excel Worksheet with a bunch of columns. Row 1 has a list
if headings. Are there specific rules for what these headings can be? Why
am I getting this error?

Help ....
 
D

Debra Dalgleish

There aren't too many rules for naming the fields, but every column
needs a heading. Maybe one of the columns has a blank heading cell. The
column could be hidden, or the pivot table range might include a blank
column to the left or right of the data table.
 

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

The PivotTable field name is not valid (error) 1
pivot 2
Pivot Table operation is different 1
Pivot Table Error...Help! 1
Pivot Table Field Name 1
Creating a calculated field in a Pivot Table 1
Pivot Table Page Field value from cell in another worksheet 3
View Pivot Table Source data as a Data Table 6

Top