KioskeaKioskeaCommentCaMarcheSign up, it's free !
Saturday May 17, 2008 - 6:38:38 am BST

Excel autofilter stops filtering

They need your help All unanswered messages
Dell wireless wlan card wireless network controller stopped working Excel autofilter Excel countif Excel date format tutorial video clip free Excel mac conditional formatting Excel timecard hours decimal Excel viewer 2007 Mail merge in word 2007 from excel decimal places Microsoft keyboard keys stop working Office 2007 i can open outlook and excel but word and powerpoint wont open Outlook 2003 hangs when opening an excel file Outlook 2007 can not open excel attachment Permission on server to download a temp excel file Play videos in excel Sound stopped working Start up pc and stops on bios screen Stateless packet filtering Stop excel open in internet explorer Stop pdf open with picture manager Vista excel mac os x Vista,wireless,stopped
 
News All news
 
The rules to respect
 Provide a cordial welcome to new users.
 Post message in the most appropriate theme.
 Enforcing the laws in force.
 Making use of formula and polite exchange with courtesy.
 Do not post messages for commercial purposes.
Write messages in plain language without abbreviations or SMS style
In this case, explain the forum rules
Read the complete text of the charter
Opinions / Software Others opinions
Search : in
Unanswered messagesStatistics Ask your question
Excel autofilter stops filtering
par Lucy
 Threaded discussions
Statut : Not resolved
Wednesday April 30, 2008 02:22:38 AM
Hello,
I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I discovered that my autofilter just stoped filtering completely. When I clicked the arrow there is no value in the dropdown list just All, Custom, and top 10. But even these options when I tried to click on them they doesn't work either.

I have removed and reapplied the filter but the problem retained. I did google and tried the manuall calculation mode, that doesn't work for me. Even I tried to copy a dozen of records to a new worksheet and applied the autofilter but it showed nothing.

Please help me guys, I cannot survive without my autofilter.
Thanks a million.
Lucy
Configuration: Windows XP
Firefox 2.0.0.14
Reply to Lucy  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
By crazy_phoebe, on Thursday May 1, 2008 05:50:05 PM Threaded discussions
Why are you still using a 2003 software ? [ sorry to answer with another question ]
   
Reply to crazy_phoebe

2


  • This message seems useful, vote!
  • Report this message to moderators
By Lucy, on Thursday May 1, 2008 11:39:06 PM Threaded discussions
Because we don't want to buy/upgrade to 2007. It's that simple ;)
   
Reply to Lucy

3


  • This message seems useful, vote!
  • Report this message to moderators
By Lucy, on Thursday May 1, 2008 11:43:40 PM Threaded discussions
Just a good news, I have found out why my filter stopped working. After reading serveral notes about autofilter, I have got this trick to check the filter area: Ctrl+G: _filterdatabase. Removing all the filter and recreate it with the right filterdatabase range had my autofilter go again.

Thanks, guys.
   
Reply to Lucy

4


  • This message seems useful, vote!
  • Report this message to moderators
By kathleen, on Wednesday May 7, 2008 09:45:41 AM Threaded discussions
Hy,

I've got the same problem, but I don't understand your solution. If I press CTRL+G in excel, I get the GOTO screen?
   
Reply to kathleen

5


  • This message seems useful, vote!
  • Report this message to moderators
By lucyphan, on Saturday May 10, 2008 11:41:02 AM Threaded discussions
Yeah, and type in the name of your current sheet, followed by ! and the "_filterdatabase" parameter, e.g. sheet1!_filterdatabase. Excel will highlight the area the current filter is applied to. If your filterdatabase area is wrong, select the whole sheet, remove the filter. I think you should also do a data sort first, then select the right area and reapply the autofilter. I hope this will help (it works for me).
   
Reply to lucyphan

6


  • This message seems useful, vote!
  • Report this message to moderators
By lucia4love, on Thursday May 15, 2008 08:31:48 AM Threaded discussions 
   
Reply to lucia4love
Currently no message on this subject
Reply
Message title :
Your nick:
Your E-mail :
Message: 
  •  
  •  
Options: Get the answers by mail.
 

Help