Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Advanced Filter crashes (2002)

    I'm running a small macro to apply an Advanced Filter. The criteria area and area to copy to are on one sheet and the list is on a separate sheet. This ran perfectly last week, but now crashes the computer. Even trying to do it manually, rather than from a macro, still crashes. Anyone come across this before? Thanks, Andy.

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

    Re: Advanced Filter crashes (2002)

    Perhaps the workbook has become corrupt? Try Jan Karel Pieterse's Corrupt Files troubleshooting guide.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Filter crashes (2002)

    I'm hitting a brick wall. I can open the file and use it as normal, but as soon as I try the Advanced Filter it crashes Excel! I've tried copy all sheets to a new workbook..
    Help! Any other suggestions? Andy.

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

    Re: Advanced Filter crashes (2002)

    If you wish, you can post a (if necessary stripped down, anonymized and zipped) copy of the workbook, so that Loungers can investigate the problem directly.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Filter crashes (2002)

    It seems to have been resolved by copying the main list area (values only) to a blank workbook.. and then re-creating the ENTIRE workbook. Not an ideal situation?!

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

    Re: Advanced Filter crashes (2002)

    That confirms my suspicion of corruption. If you copy an entire worksheet to a new workbook, you copy the corruption with it. If you copy a range of cells, you usually avoid copying the corruption.

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

    Re: Advanced Filter crashes (2002)

    I've helped out a colleague just last week with the exact same problem.

    Problem was caused by many zero-sized charts on the sheet with the filter area.

    F5, special, objects, delete solved the issue.
    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
  •