Thread: Why does the pivot table not allow me to group data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Why does the pivot table not allow me to group data?
If the field in the source data contains blank cells, or cells with
text, you won't be able to group the data. There are some suggestions
here for fixing the problem:

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

Forrest wrote:
I need to group the data in a pivot table, why will it not allow me to?


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

Reply With QuoteReply With Quote