AutoFilter Dropdown Lists not working

R

Ray

I'm using Excel 2002. I use autofilter a lot and have never had a problem.
However, on the current workspace the autofilter will only let me select from
the dropdown lists occasionally.

So I'll activate autofilter, filter a few columns, enter some data /
formulae, then when I go to change the filters the dropdowns are no longer
"clickable". I then have to deactivate Autofilter and use "unhide" to see my
data again.

Anyone know what's going on?
 
Top