Excel autofilter stops filtering

Lucy - Updated on Jan 29, 2019 at 05:25 AM
 thankful - Jun 11, 2019 at 02:53 PM

I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I discovered that my auto-filter just stopped filtering completely.

When I clicked the arrow, there is no value in the dropdown list. There are just All, Custom, and Top 10. But even these options, when I tried to click on them, do not work either.

I have removed and re-applied the filter, but the problem remained as same. I did google and try the manual calculation mode. That did not work for me.

Even I tried to copy a dozen of records to a new worksheet and applied the auto-filter, but it showed nothing.

Please help me guys, I cannot survive without my auto-filter.

Thanks a million!
System Configuration: Windows XP Firefox

23 responses

May 14, 2010 at 07:14 AM
Hi all,

I had a similar problem in the past weeks - the auto filter was freezing after a couple of use and I had no other choice than to remove the autofilter and unhide the hidden rows before putting it back for a couple more uses.

A colleague then reminded me of a common practice: instead of adding a filter to the title row, insert a blank row between the row bearing the column titles and your first row of proper data, and add the filter to that blank row. Well, it works for me. I think the filter gets stuck when the column titles get too long for some reason.
im using the formula to add =sum(b2:b184) and then enter but it doesnt work
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 22, 2010 at 01:40 PM
make sure the cell is formatted to be "general" and if it is so, could you explain more beside "does not work"
hi I tried the select all and then applied the filer again. It worked.
Heather C