Results 1 to 5 of 5

Thread: Microsoft Excel autofilter has stopped working

  1. #1
    Join Date
    Apr 2009
    Posts
    97

    Microsoft Excel autofilter has stopped working

    Hey Everybody,

    I have installed Windows Xp along with Microsoft Office 2003 on my pc. Recently i was entering some records to my file, which has about 20,000 rows in it. While entering the records, i came to know that my autofilter had just stopped filtering the records. When i was trying to click on the arrow, it was not showing me any value in the drop-down list. I tried removing as well as re-applying the filter, but couldn't succeed in it. I even tried to copy the records to a new worksheet, but was facing the same problem. Can any body tell me that why i'm having such problem on my pc? What can i do in order to get rid of the above problem? Does any body knows about this issue? Kindly help me out to resolve the above issue.

    Thanks.

  2. #2
    Join Date
    May 2008
    Posts
    3,316

    Re: Microsoft Excel autofilter has stopped working

    If you need to use your data filter regularly put a button on your toolbar and try to attach a macro to it:

    Sub AutoFilterOff()

    ' AutoFilterOff Macro

    Selection.AutoFilter
    End Sub

    Now you will be able to do the filter on and off with a single click.

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: Microsoft Excel autofilter has stopped working

    Just try out the following steps in order to get back your autofilter working on your system. Juts press the Ctrl+G key, which will pop-up a window on your screen. Then enter the following _filterdatabase in it, it will remove all the filter and recreate it with the right filterdatabase range on your Excel.

  4. #4
    Join Date
    May 2008
    Posts
    4,570

    Re: Microsoft Excel autofilter has stopped working

    Check to make sure that there are no blank rows in that worksheet Excel usually stops the filtering at the first blank row.

  5. #5
    Join Date
    Jan 2008
    Posts
    3,755

    Re: Microsoft Excel autofilter has stopped working

    The (Top 10) option is only available for columns that Excel identifies as containing numeric values. This Excel filter option allows you to display only the N highest or the N lowest values from the current column. If you click on this option, Excel brings up an options box, as shown on the right. This contains 3 options:

    1. Select the Top (highest) values or the Bottom (lowest) values

    2. Option to select the number, N

    3. Select Items or N Percent of entries to be displayed

Similar Threads

  1. Microsoft Excel has stopped working
    By jayaprakash_7@yahoo. in forum MS Office Support
    Replies: 3
    Last Post: 06-01-2014, 11:53 AM
  2. how to enable Autofilter and Sorting in Protected Excel Sheet
    By ChittiBabu in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 08:38 PM
  3. Replies: 4
    Last Post: 28-08-2011, 11:02 AM
  4. Excel autofilter stops filtering
    By roumieh2000 in forum Windows Software
    Replies: 3
    Last Post: 15-10-2009, 03:31 PM
  5. MS Excel stopped working completely
    By Soumen in forum MS Office Support
    Replies: 1
    Last Post: 23-08-2008, 10:52 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,817,618.63296 seconds with 16 queries