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 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 2.0.0.14