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
Reply to crazy_phoebe
|
Hi..
|
To: K8ster598
|
I tried the GOTO thing, it selected what looked like the right area - although some columns did not have the non-working drop down arrows. I did an Autofilter command and it added arrows on every column that did work. When I did it again, it removed the working ones, leaving the non-working ones as they were before I did anything. I redefined the name to be the entire area. I can add and remove new drop down arrows as much as I want, but those three useless bits of grey picture are still there. Any ideas? |
The following also solves the problem:
|
For autofilter to work properly, make sure that your data range does not have any empty columns when filtering.
|
Hi... actually i been using the advanced filter in my excel sheet and its being working fine...but now since i have been upgraded to excel 2007 the excel has stopped working. I have a source data sheet, a filter criteria in another sheet & i copy the filtered rows to another sheet.
|
My auto filter stopped working- the dropdown box is empty and it's not over 1000 lines - i think it's something to do with blank characters when I copied/pasted from web based application, but I don't see them.
|