Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Advanced Filter Causing Crashes (2000 SR1)

    Often when I use Advanced Filter to filter based on criteria, Excel crashes. It generally happens after the 2nd or 3rd filter.
    Any ideas on how to avoid these crashes. I rely on this a lot to filter certain stores from a list of 2000 stores.

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

    Re: Advanced Filter Causing Crashes (2000 SR1)

    I've never heard of this problem before. Maybe your workbook contains some sort of corruption.
    Try saving this workbook as HTML. Then open the HTML file and save-as a normal workbook (use a new name to prevent overwriting your original!).
    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
  •