Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter Drop Down (Excel 2000)

    We've just switched to Excel 2000. I'm having trouble with Auto Filter. The drop down list does not appear. The check mark appears next to "AutoFilter" on the menu, but there is no drop down arrow. HELP!!! Please. It's driving me crazy. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> I have opened older files, created under Excel97, that have filters applied. Once I turn them off, I have the same problem - can't get the drop down arrow to appear.

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

    Re: Filter Drop Down (Excel 2000)

    Does choosing Help, detect and repair do any good?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter Drop Down (Excel 2000)

    This was a regular problem for me when I first moved to 2K. It seems to have stopped happening but only after two or three months of closing excel and running the command line "C:Program FilesMicrosoft OfficeOfficeexcel.exe" /regserver from the start run box every time it did. I have noticed that about (finger in air time) 5% of the users at my company experienced this as they moved from 97 to 2K. I've never tried Jan Karel's suggestion, but I'll keep it in mind if I see the problem recur. It may well be a service pack related issue - but I can't remember when I applied what to my machine. Can you get hold of SR1a and apply that?

  4. #4
    New Lounger
    Join Date
    Mar 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter Drop Down (Excel 2000)

    Thanks for the responses. After all the frustration of yesterday, I now can't get the problem to repeat!!! So I haven't tried the Repair suggestion (yet!). I was thinking about the problem on the way home from work. Our company uses SAP, and I regularly export from SAP to Excel - there is an automatic export to Excel - the data transfers immediately to an unsaved workbook. I also had problems when I opened an excel file from Windows Explorer , rather than from Excel itself. But I can't test that theory this morning since things seem to be working ok.
    This was my first post although I've come here many times to search for help. I appreciate the quick responses. Thanks!!!! <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

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