Filter data in a table Select the data you want to filter. In the Create Table dialog box, you can choose whether your table has headers. To apply a filter, click the arrow in the column header, and pick a filter option.
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! Hi.I also have problem in autofilter, I used excel 2003. Hi roulette21Which Excel are you using, 2003 or 2007?If 2003, I guess this may be the answer to your problem:'Excel 2003 limits the list to 1000 visible unique items ('So MS suggests:'To work around this issue, use the AutoFilter command on several smaller sections of the data instead of on all the data at the same time.
All list items will be visible if each subset has no more unique members than the limit for the particular version of Excel.' I know another method which splits your list into smaller lists with less than 1000 items but could not remember exactly how to do it. (Please google).Another way to check is to use the trial version of Excel 2007 from MS download website.
Excel 2007 lifts the limit from 1,000 to 10,000.Please let me know if you solve the problem or not, thanks. 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.Here how the code goesSheets('HDataSheet').Range('Database').AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets('HfullFiletrs').Range('BigBugger'), CopyToRange:=Sheets('PIL').Range('B9:BZ9')The code works fine in excel 2003 but doesn't returns any filtered rows.i.e the sheet comes blank after filter code.Please if any any can suggest any thing.I have been stuck with this for long now.Please help. 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. Aston and Craig's solution is so easy (de-activated Auto Filter, then control-A to select all data in the spreadsheet, and then re-activate the Auto Filter), and fixed my problem immediately (though I have less than 1,000 rows of data, which I believe is the threshold of Excel 03's capacity for filtering data. Thanks both for this simple, non-techie solution! (For some reason I cannot fathom, my excel was previously only allowing me to filter up to row 534, so my selected filter subject PLUS every row from 535 onward would show up in the spreadsheet, but thankfully it is now working correctly again!).
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.I tried to copy the whole spreadsheet to a new one - didn't workI tried to copy some lines of the spreadsheet - didn't workso I resorted to making a pivot table including the same columns and recreated the same spread sheet this worked! Filter is functional again.If anyone knows why this happens please advise.Thanks,Martine.