Hi,
it runs me crazy, I do have two diffrent excel files. With one file I am
able to group data in my pivot table. With my other file I'm not. When I
click on "Grouping" then the error message "Cannot group the selected fields"
appears.

What do I need to change?

Hi

Perhaps you are trying to Group dates?
If so, Excel does not like any blank cells, or any non Excel dates in
the range to be grouped.
Perhaps you could use a dynamic range for the source for your PT so that
you do not include blank cells in the date column.
Another "trick" I sometimes use, if there is an IF formula that returns
a date to a cell if some criterion is met, rather than using Null ("")
if the criterion is not met, I use a date far in the future, the Excel
will allow grouping, but I restrict the data range to exclude these
"distant" values.

--
Regards

Roger Govier


"ROland" wrote in message
...
Hi,
it runs me crazy, I do have two diffrent excel files. With one file I
am
able to group data in my pivot table. With my other file I'm not. When
I
click on "Grouping" then the error message "Cannot group the selected
fields"
appears.

What do I need to change?