Excel Autofilter not working

[Closed]
Report
-
 Alister -
Hello all,

I'm working in Excel 2003 with a spreadsheet of phone call data I downloaded/imported from my cell carrier. If I activate Autofilter, the AF drop-down menus appear for all columns but one, but they work for only 2 columns (neither of which is the one I really need).

There are only about 600 rows in the spreadsheet and probably fewer than 200 unique strings in any given column.

Ideas?

Thanks.

2 replies


When upgrading from excel 2003 to excel 2007, auto advanced filter problems are solved by removing names from criteria formulae and replacing with absolute cell positions.
8
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Thank you very much for that tip.
Changing named ranges to absolute references in an Advanced Filter also solved my problem where an Excel 2003 macro would not work in Excel 2007.
What do the guys at Microsoft think they are doing by making regressive changes in functionality?
Posts
7
Registration date
Friday April 18, 2008
Status
Member
Last seen
May 29, 2009
1
Please make sure you make the right command.


Or other wise you must do it manually