If the field in the source data contains text or blank cells, you'll see
that error message. There's information here on fixing the problem:

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


petevang wrote:
Why when trying to use the group feature, will excel says "cannot group
that selection". Is there anyway around this. I am trying to group a
range of numbers? Thanks




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