+ Reply to Thread
Results 1 to 13 of 13

Manual filtering function isn't working

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Manual filtering function isn't working

    Screenshot (72).jpg

    This is probably a really stupid question, but I can't for the life of me figure it out. I need to do some very basic filtering, but the dropdown box where you check off the things that you want to filter by is not defaulting to show checkboxes. This didn't seem like a big deal at first, but it's made it impossible to filter all but one things. For instance, to filter everything but values that are 0, I would have to manually click every single value in the dropdown box. Clicking "select all" is doing literally nothing. It's this way for all my excel documents. Does anyone know how to get the boxes back? I've included a screenshot of what comes up whenever I click on the manual filter button to show what is coming up.

  2. #2
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Manual filtering function isn't working

    filter option there is a multiple selection option, just click therr and continue

  3. #3
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Re: Manual filtering function isn't working

    Screenshot (73).jpg

    I guess I wasn't very clear there, I apologize. Here is an image of what happens when I click "select all." It's like the boxes are just gone, and without them it's impossible to filter manually unless I just want one value. Additionally, clicking select multiple options doesn't do anything. It just lets me choose one at a time. I can't choose all and then remove what I don't want, I can only select what gets included one at a time

  4. #4
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Manual filtering function isn't working

    Untitled.png

    please check attachment

  5. #5
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Re: Manual filtering function isn't working

    Screenshot (74).jpg

    Thanks for throwing that in there. I've been trying to use that, but like I said, it doesn't do anything. Here's a picture of what happens.

  6. #6
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Manual filtering function isn't working

    please attach your sheet

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Manual filtering function isn't working

    Can you upload your troublesome file minus any confidential data so that it can be examined to see what is causing your problems?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  8. #8
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Re: Manual filtering function isn't working

    A very basic example spreadsheet should be attached. This is occurring in all of my spreadsheets right now, this one included. I'm worried it may be an issue with my version of excel, and the error won't show up on anyone else's machine
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Re: Manual filtering function isn't working

    Yeah, I just downloaded that spreadsheet and am still having the same issues with filtering dialog boxes not showing the checkmarks. If this doesn't happen to you, I guess I'll have to uninstall and reinstall office or something.

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Manual filtering function isn't working

    The multiple selection worked right away. I have left it selected.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Re: Manual filtering function isn't working

    That's bizarre. The boxes have come back on that document, but still aren't working in the one I've been working on. Perhaps I need to reinstall excel

  12. #12
    Registered User
    Join Date
    08-14-2014
    Location
    Philadelphia
    MS-Off Ver
    Windows 8.1
    Posts
    7

    Re: Manual filtering function isn't working

    Hey I closed out and opened it back up and it worked! Maybe some of your settings got sent to me, but that was the weirdest solution I've ever seen. Thanks!

  13. #13
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Manual filtering function isn't working

    Before re-installing, go to the Control Panel, Programs and Features (wherever that is in Windows 8) and where you would uninstall, choose CHANGE then choose REPAIR. That could fix the problem without hassle. If it doesn't work, then you can always uninstall and reinstall.

    You might have to use something like Revo Uninstaller to get a complete uninstall.

    http://www.win-install.com/revo-unin...staller%20free

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Autofilter vba not actually filtering - manual steps needed to filter- help
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2014, 01:36 PM
  2. Macro changing calculation to manual not working
    By TactileMist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 06:24 AM
  3. [SOLVED] Simple manual autofill not working
    By FPS in forum Excel General
    Replies: 4
    Last Post: 08-02-2012, 07:09 PM
  4. Manual calculation not working
    By EMAC in forum Excel General
    Replies: 1
    Last Post: 09-28-2007, 01:15 AM
  5. Manual Calculation not working?
    By M. Authement in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2006, 04:55 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1