auto filter problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Frequently, as in many many many times each day, with auto filter engaged, clicking the arrow to expose the drop down list does nothing, leaving many rows hidden. Turning auto filter off and then on, enables the drop down list, allowing access to all rows. Why does this happen? It happened with an older version of Excel and Windows 98. I thought upgrading to XP and Excel 2003 might cure. It did not. In fact it got worse. What is the fix?
 
A guess- If the auto filter is applied to many columns and you lets say you filter column 1. Works good. Then you filter column 2. Nothing changes. It could be the filter in column in 1 needs to be set to (All)

Hope that helps.
 
It's not that it just stops working, it leaves rows hidden. The only way I've found to re display the hidden rows is to turn auto filter off, then on and them selecting something from the drop down list. Doing nothing is not an option. To continue using my spreadsheet I must turn auto filter of and on many many many many times each day. It must be a bug. Do Excel programers monitor this discussion? If not, how can I email them?
 
Filtering witiin columns you can use "and", "or"; however, between columns it is just "and". It is the way it is designed. Sounds you like you want to add a feature. Maybe they will do it in a future version of Excel. I don't know who monitors this board. Good luck

P.S.- I use a spreadsheet everyday just like you. I recorded a macro- go to Data, Auto Filter, and then set it to off. I assigned that macro to a toolbar button. So when I want to clear the filters for another query, I just click on the button or the ALT_key combination first. Hope that helps.
 
Back
Top