L
Liz
I have used autofilters extensively and never had problem
until now. I have autofilters in a spreadsheet turned on
and use these to filter successfully - then the next time
I try to change the filter by using the drop down arrow I
get no selections. The only way I can reset is to turn
autofilter off and then unhide the rows (as these are not
automatically unhidden when I turn the filter option off)
then turn to filter back on. This only solves the problem
temporarily as it reoccurs within 10 filters being
performed. Any ideas why this happens and how to resolve?
until now. I have autofilters in a spreadsheet turned on
and use these to filter successfully - then the next time
I try to change the filter by using the drop down arrow I
get no selections. The only way I can reset is to turn
autofilter off and then unhide the rows (as these are not
automatically unhidden when I turn the filter option off)
then turn to filter back on. This only solves the problem
temporarily as it reoccurs within 10 filters being
performed. Any ideas why this happens and how to resolve?