software

I get an message saying I cannot group on that selection.

The values in that field have to be all numeric--they can't even be
blanks/empty.

MCVCOTE wrote:
gt;
gt; I get an message saying I cannot group on that selection.

--

Dave Peterson

The field itself is a date and each entry does have a date. I've grouped on
it before but can no longer do it. I've tried refreshing, updating the data,
and nothing seems to work. It brought in the data on a daily basis and I'm
trying to group it by month instead.

quot;MCVCOTEquot; wrote:

gt; I get an message saying I cannot group on that selection.

There may be a left over field from a previous grouping. There are
instructions here on how to fix the problem:

www.contextures.com/xlPivot07.html#Problems

MCVCOTE wrote:
gt; I get an message saying I cannot group on that selection.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html