Excel Autofilter not working
Closed
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.
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:
- Excel Autofilter not working
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
2 responses
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.
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
Jul 4, 2008 at 02:02 PM
Please make sure you make the right command.
Or other wise you must do it manually
Or other wise you must do it manually
Jun 15, 2009 at 12:23 AM
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?