Hello,
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 autofilter just stoped filtering completely. When I clicked the arrow there is no value in the dropdown list just All, Custom, and top 10. But even these options when I tried to click on them they doesn't work either.
I have removed and reapplied the filter but the problem retained. I did google and tried the manuall calculation mode, that doesn't work for me. Even I tried to copy a dozen of records to a new worksheet and applied the autofilter but it showed nothing.
Please help me guys, I cannot survive without my autofilter.
Thanks a million.
Lucy
Configuration: Windows XP
Firefox 2.0.0.14