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

Thread: Group Problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    After subtotaling my data, I cannot seem to open up the groups using the numbered buttons. I'm getting an error message saying 'cannot shift objects off sheet'.
    I can expand & condense the groups individually, but I need numbered group buttons to work.
    What's happening!?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Problem solved.
    I had a comment in one of the cells and it didn't seem to like it. Be aware!

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    that's weird......

    was it right down the end of the 65,000 rows or very right over by column IV or something ?

    I thought grouping "hid" as oppose to "inserted" rows and columns....!

    As Jack maintains, Excel is as enigmatic as the female of the species

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
  •