View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Pivot table field list missing

Hi

First, click on a cell within your data, and choose Insert tabTable.
Then click on any cell within the table, click DesignSummarize with Pivot
Table.

--
Regards
Roger Govier



"filfoot" wrote in message
...
I am currently using Excel 2007, and was able to create Pivot tables
without
a problem. However now when I highlight a range of data and click on
Insert
pivot table, there are no fields in the pivot table list for me to create
the
table.
How can I can i get these fields (effectively the headers of the data
columns) in the pivot table when Excel isn't recognizing them.