View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stressed stressed is offline
external usenet poster
 
Posts: 5
Default Pivot Table - Grouping Dates Error

Hi there -
I had my pivot table all set up for the past couple years and all of a
sudden yesterday the woman taking over for my job lost the grouping of dates
on one of my sheets. Now it just lists every date and the sales amounts
associated with each individual date, rather than before where it was grouped
by year, and month.

I tried to right click on my 'Date' colum and go to group; but every time I
hit Group i get an error saying that it's unable to group this selection. I
went through and made sure all my dates were filled in, no blank cells, and
still unable to group. Suggestions?? Please??? It's driving me CRAZY!