Excel 2007 Pivot Table - Group Field function is not always availa
 

The Group Field button on my Excel 2007 pivot tables is not always available.
I've even copied all of my data, started a new workbook, and pasted the data
into is as values, created a pivot table, and the Group field button is not
available for some of the columns of data but for others it is. Does anyone
know why this would happen? I've tried other spreadsheets with different
data and it does the same thing. I've tried having the data formatted as
dates and some of the date columns will work and others won't. Have tried
using just as number values and that sometimes works and sometimes doesn't.
This also happens on my co-workers Excel 2007 installs as well. Any help
would be greatly appreciated.

Excel 2007 Pivot Table - Group Field function is not always availa
 

I think I just answered my own question. The columns that do not group have
blank cells in them! DUh! Once I changed the selection to include only
cells with data it worked fine. I'll either have to put in a null or change
the selection area.


"JLW1" wrote:

The Group Field button on my Excel 2007 pivot tables is not always available.
I've even copied all of my data, started a new workbook, and pasted the data
into is as values, created a pivot table, and the Group field button is not
available for some of the columns of data but for others it is. Does anyone
know why this would happen? I've tried other spreadsheets with different
data and it does the same thing. I've tried having the data formatted as
dates and some of the date columns will work and others won't. Have tried
using just as number values and that sometimes works and sometimes doesn't.
This also happens on my co-workers Excel 2007 installs as well. Any help
would be greatly appreciated.