Excel 2002 Autofilter

C

Chuck

I have an Excel spreadsheet that I am using the Autofilter option. Sometimes
when I click on the drop down arrow and select a field the drop down arrow
turns blue and then I can not click on any of the drop down arrows to choose
another filter. The original drop down arrow stays blue and prevents me from
being able to use the autofilter again. I have to save and exit and reopen
the document again
 
A

Alok

I have noticed this issue when there is too much data and too many formulas.
In my case I just had to give the worksheet inordinately long time for it to
start showing all the data.(When I clicked on the All option in the filtered
list).

You may want to turn off Automatic Calculations when using this Autofilter
feature and see if that speeds up things.
 

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

Top