Thread: Why do I get invalid data source when creating a pivot table?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Why do I get invalid data source when creating a pivot table?
Maybe one of the heading cells is blank. Check to see if there are any
hidden columns, or if you've selected an extra column to the right of
the data.
To create a pivot table, the data must have an entry in every cell in
the first row.

Stricia wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote