Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Filter/Sort/Undo Bug (Excel 97)

    Does anyone know if the following known bug in Excel '97 has been fixed in either Excel 2000 or Excel 2002?

    1. Turn on Autofilter and Filter on one or more columns
    2. Sort the resulting AutoFiltered Sheet
    3. Attempt to Undo the Sort

    Consistently gives a "Program has committed an Unrecoverable Error and will Exit." message.

    All data not stored is lost.

    Thanks.

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

    Re: Auto Filter/Sort/Undo Bug (Excel 97)

    The error doesn't seem to occur in Excel 2002 (SP-2).

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Filter/Sort/Undo Bug (Excel 97)

    I cannot replicate the error in 97(Sr-2 ).

  4. #4
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Filter/Sort/Undo Bug (Excel 97)

    I can't replicate it either: XL 2000 sr1 (in a file generated in xl97 sr2).
    Strikes me a good case if you're doing something 'ambitious' to save as... [newname] and do it on the copied file first.
    Once bitten, twice shy...
    John

Posting Permissions

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