View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default Cannot group by date in a pivot table

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

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

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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html