Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: PIVOT TABELS!!!!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm tearing my hair out!!

    I am having problems grouping my data. It is in date format and therefore I want to group by month. I have done this before on other files but when I try to do it now i get the message "cannot group selected data". I have checked the formatting etc etc and I don't know where elese to go!
    Can you help??

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-25 08:45, AJMalta wrote:
    I'm tearing my hair out!!

    I am having problems grouping my data. It is in date format and therefore I want to group by month. I have done this before on other files but when I try to do it now i get the message "cannot group selected data". I have checked the formatting etc etc and I don't know where elese to go!
    Can you help??
    You can't have any blank (empty) cells in your date column. If you do you'll have to replace them with an arbitarily high or low date value, re-create your PivotTable (your existing PivotTable will "remember" the old (blank) cells), and hide your arbitrary date value (or exclude it from your groupings).

    [ This Message was edited by: Mark W. on 2002-04-25 08:49 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the reply. I have checked the data and there are no blank cells. Any other advice?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-26 01:52, AJMalta wrote:
    Thanks for the reply. I have checked the data and there are no blank cells. Any other advice?
    What's the Range you are using at Step 2 of 4 on the PivotTable wizard?

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-26 06:56, Mark W. wrote:
    On 2002-04-26 01:52, AJMalta wrote:
    Thanks for the reply. I have checked the data and there are no blank cells. Any other advice?
    What's the Range you are using at Step 2 of 4 on the PivotTable wizard?
    It was looking at the whole sheet but I have specified a range now and it works! Thanks for this....
    Eternally greatful.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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