auto filter problem

R

RandyR

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?
 
B

BorderMan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto filter filtering incorrectly 0
auto-filter image 3
auto filter on columns 2
Auto Filter - It's broken! Help! (Office '03) 2
Auto-filter not grabbing all the data 2
Auto-filter selection 1
Auto Filter 3
Auto Filter Stops Working 0

Top