Pivot Tables and Column Labels

  • Thread starter Thread starter Mark McDonough
  • Start date Start date
M

Mark McDonough

I'm having some trouble creating a pivot table with a large amount of data
that has fields arranged in columns - store, brand, address, supplier a,
supplier b etc.

When I go to create a pivot table, I select all the data including the
titles and get an error telling me I have to create column labels before it
will do the pivot table.

What's wrong here? Shouldn't it just pick up on the titles as being the
fields?
 
Does the source data table have one row of headings?
Is there text in every heading cell? Perhaps there are hidden columns
that don't have heading text.
 
Well if that is the cause, I do have hidden columns with no data labels.
Thanks for the advice.
 
You must log in or register to reply here.

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

Pivot table filter list - listing irrelevant subcategorys 1
about pivot table 1
Pivot Table field names don't match 1
pivot 2
Pivot table column limits 2
Excel 2007 Pivot Table Question 2
Pivot table, IF function, calculated item versus calculated field 1
Referencing a pivot tables Grand Totals Column 1

Back
Top