You might see that error if the field that you're trying to group
contains text or blank cells. There are suggestions here for fixing the
problem:

http://www.contextures.com/xlPivot07.html#Problems


LisaG wrote:
Why do I get the message "Cannot Group That Selection" when I try to
summarize my Date column into monthly "groups"? This happens most of the
time, but sometimes I get lucky for some unknown reason and I can group the
data.

Help!!!

"yhoy" wrote:


Sorry if this is a dummy question:

Put the mouse in pivot tabe, and choose Pivot tabel/ tabel options, it
prompts: the pivot table report is not valid.

Tried in the related pivot chart, same message. How can I get to the
Autoformat option?






"uslanja" wrote:


On the pivot table options dialogue, uncheck autoformat

/jim

"yhoy" wrote:


Why after I update datasource (with same structure) and refresh Pivot chart,
all the setup are lost? Is there anyway to fix it-- ideal is by clicking one
button, all the charts/tables get updated.

Thanks a bunch!



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