Search : in
By :

Excel Autofilter not working

Last answer on Jun 15, 2009 5:23:17 am BST cavemenroaraed, on Jul 4, 2008 2:37:13 am BST 
 Report this message to moderators

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.

Best answers for « Excel Autofilter not working » in :
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Download Excel Viewer Show
Download Excel Password Recovery Master Show
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

jv.java, on Jul 4, 2008 7:02:49 pm BST

Please make sure you make the right command.


Or other wise you must do it manually

   
Reply to jv.java

2

David A of Avenues, on Apr 9, 2009 5:57:36 pm BST
  • +5

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.

   
Reply to David A of Avenues

3

 Alister, on Jun 15, 2009 5:23:17 am BST
  • +2

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?

   
Reply to Alister
Ask your question Reply
They need your help