Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Fixed Objects Will Move (2003 SP2)

    Aloha all,
    I have a large spreadsheet (28 cols x 55,000 rows) that, when I use AutoFilter, produces a msgbox saying "Fixed Items Will Move". The msgbox appears 15 to 30 times, without any correlation to the data that I can determine. AutoFiltering on different values in the same column produces a different number of msgboxes. Sometimes no msgboxes appear. Any insight as to why this is happening?
    Mahalo!

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

    Re: Fixed Objects Will Move (2003 SP2)

    Do you have floating objects on the worksheet, such as cell comments?

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Fixed Objects Will Move (2003 SP2)

    Yes I do. There were 11 column headers with coments attached. To see what effect, I cleared all but one comment, on the 28th column and re-opened the file. I'm still getting 31 or 28 or 33 msgboxes upon AutoFiltering on a value.

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

    Re: Fixed Objects Will Move (2003 SP2)

    Could you attach a reduced copy of the workbook (only a few rows) that demonstrates the problem? Remove all sensitive information.

  5. #5
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Fixed Objects Will Move (2003 SP2)

    I've tried reducing the first file as well as reducing a second large file with the same problem, but I can't reproduce the msgboxes in the reduced versions (yet).

    An "Aha!": In the first file I cleared all comments from the entire range, and now I have no msgboxes popping up. I guess I must have attached comments somewhere in the body of data as well.

    And a mystery: The second large file has 44,000 rows, with 13 comments in random locations within the data. So far, every AutoFilter I've tried has produced 3 msgboxes. What's up with that.

    Well, even though the number of msgboxes is still a mystery, it's clear to me that the comments are the culprit. I'll just evaluate for myself the relative value of in-data comments vs. AutoFiltering uninterrupted by msgboxes. OK, did that -- the comments go.

    Mahalo Hans, for your efforts,
    John Jacobson

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fixed Objects Will Move (2003 SP2)

    There may be objects with zero width and height.

    - remove autofilter
    - press F5 (GoTo), special, objects
    - hit Del to remove all of them

    Now set autofilter back on.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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