When I apply the autofiltering to a spreadsheet, and I select an item from a 
drop-down box, I find all the rows that respect the filter. But when I select 
another column, the drop-down box shows all the items of the column, and not 
only the items from filtered rows. On the other hand, the drop-down box of 
Excel97 shows only the items from rows shown, and not from hidden rows.