Autofilter not showing all data
Posted by Mike on February 14, 2001 9:26 PM
I recently assisted a user with a excel filter problem. He had a large spreadsheet with Autofilter applied to all columns. His problem was the pulldown menu would not show all the items in the column, i.e., the number 832267 was in the column but did not show up in the pulldown list. I corrected the problem by sorting that column and following the sort everthing works fine. Is this a fluke or is this symptom caused by something else.