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.