Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 97 Pivot Table Grouping Problem

    Help!! When I had pivot tables with different individual dates across the top in Excel 95, I was easily able to Group those into Months or Quarters. With the same tables I can't do it in Excel 97. The help file says to select a single date item and click the green right arrow (Group) on the Pivot Table toolbar, at which point 'Starting at' 'Ending at' and 'By' boxes are supposed to appear, but every time I click 'Group,' I get a message saying 'cannot group that selection.' Does anyone know what I'm doing wrong? Thank you very much for any suggestions, C. King

  2. #2
    frog_hk
    Guest

    Re: Excel 97 Pivot Table Grouping Problem

    Hi!
    I have this problem too. If I highlight the field to be grouped and click "group", Excel will just group them without asking anything. How can I have that dialog appear? I'm sure I've seen it before.
    Thanks a lot!

  3. #3
    New Lounger
    Join Date
    Dec 2001
    Location
    Maryland
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 Pivot Table Grouping Problem

    I've been spending hours trying to deal with this! I have a set of monthly files. They are [essentially] identical. The pivot table worksheet in some of these files works, but the same PT in other files doesn't work. I have tried to examine for flaws in the layout of the data list; I am not missing any column headings, no vacant rows/records, no squirrelly formulas present.
    I am trying to group on a field containing dates that employees began working in our department. They are formatted as mm/dd/yy, and the format selection is 'Date', '3/4/97'. I, too, get the message, "Cannot group that selection." HELP-HELP...

  4. #4
    Star Lounger
    Join Date
    Jun 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 Pivot Table Grouping Problem

    I've been having the exact same problem. It works sometimes, others times it doesn't. I checked the data to be sure I'm dealing with dates or at least values & it still doesn't work. Did you ever find any answer?

  5. #5
    Star Lounger
    Join Date
    Jan 2002
    Location
    Hunt Valley, Maryland, USA
    Posts
    88
    Thanks
    58
    Thanked 0 Times in 0 Posts

    Re: Excel 97 Pivot Table Grouping Problem

    Tanyar:
    One fault that I have discovered in recent months is that the data I was trying to group contained some cells that were either
    - blank,
    - wrong format, or
    - contained a string like "Greater than 50".

    When I hid those cells on the appropriate Pivot Table Wizard page ("Pivot Table Field" dialog box, "Hide Items" list), then the grouping has worked. However, this doesn't appear to be the complete and universal solution because it doesn't always work.

    Anyone have any better ideas?
    John S. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  6. #6
    Star Lounger
    Join Date
    Jun 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 Pivot Table Grouping Problem

    John,
    I found an MSKB article 115471 that seems to confirm that; a pivottable range containing a blank row is treated as an incorrect data type & thus doesn't allow grouping. But as you said, it seems to be inconsistent. Within my data range there are some blank cells, but no completely blank row.

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2003! Pivot Table Grouping Problem

    OK, that was quite a while ago and I'm STILL having this problem! I found this article too: it talks about how to set up dynamic ranges so you can add data and have your pivot table incorporate it WITHOUT adding any blank rows. I've checked and re-checked my data and it does not have blanks OR data type mismatches, and still I can't group on date. Help! (files attached - Book2.xls has the range hard-coded in, so there shouldn't be a problem with blank spaces, Book3.xls has dynamic ranges instead. Those work great, but still can't Group.).
    Attached Files Attached Files

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2003! Pivot Table Grouping Problem

    2nd File attached (see my previous post for details).
    Attached Files Attached Files

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2003! Pivot Table Grouping Problem

    Hi Angela,

    Long time no see!

    You cannot group the dates (or any kind of values for that matter) in a page field. You'll have to drag the date field to the row area. You can then group it the way you want. Finally, drag the date field back to the page area. The grouping will be preserved.

  10. #10
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2003! Pivot Table Grouping Problem

    Yeah, it's good to browse back through the forum and see all the good stuff that's still going on. Looks like you and Legare Coleman are still actively saving people's lives! [img]/forums/images/smilies/wink.gif[/img]

    Speaking of which - THANK YOU - I was pulling my hair out on this one! Seems obvious, but when you don't know that, it's just plain frustrating! <img src=/S/mice.gif border=0 alt=mice width=50 height=25>

  11. #11
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2003! Pivot Table Grouping Problem

    On the few occasions that Hans has not already answered the question before I see it. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •