Previous Topic Next Topic

Excel Autofilter not working

Closed
cavemenroaraed - Jul 3, 2008 at 09:37 PM
 Alister - Jun 15, 2009 at 12:23 AM
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.
Related:

2 responses

Answer 1 / 2
David A of Avenues
Apr 9, 2009 at 12:57 PM
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.
Alister
Jun 15, 2009 at 12:23 AM
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?
Answer 2 / 2
jv.java Posts 7 Registration date Friday April 18, 2008 Status Member Last seen May 29, 2009 1
Jul 4, 2008 at 02:02 PM
Please make sure you make the right command.


Or other wise you must do it manually

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses