+ Reply to Thread
Results 1 to 10 of 10

Checkboxes for Filtering have disappeared :(

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    ND
    MS-Off Ver
    Excel 2013
    Posts
    6

    Checkboxes for Filtering have disappeared :(

    When i try to filter a list in excel and wish to uncheck "select all" and just select individual names, the checkboxes that normally showed up next to the list items to be filtered are no longer showing. When I try to filter within a normal list, it will allow me to but I cannot within a PivotTable. Is there a way to get the check boxes back?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,613

    Re: Checkboxes for Filtering have disappeared :(

    Hi and welcome to the forum

    (stupid question) do you in fact have more than 1 item to filter on?

    Can you upload a sample (cleaned) of what you are working with?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-25-2013
    Location
    ND
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Checkboxes for Filtering have disappeared :(

    Attached is a test file. My issue is that when click on the dropdown to filter in the lists, I am not seeing the checkboxes to select/unselect to pick and choose what I want to filter on. Within the pivot table, It will not let me filter at all. Im curious if a setting got changed that I do not know about.
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,613

    Re: Checkboxes for Filtering have disappeared :(

    I looked at your filer and can filter just fine?
    see the attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-25-2013
    Location
    ND
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Checkboxes for Filtering have disappeared :(

    Is it possible that something got corrupted in Excel and I should just reload it? I can filter within my lists but the little checkboxes next to the names do not show up. lt will not let me filter at all within a pivot table. I did just put MS Project 13 on my machine this week and that is when I noticed this issue. Not sure how that could be causing this issue but...

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,613

    Re: Checkboxes for Filtering have disappeared :(

    it may have become corrupt Did you look at the file I sent you? was the filter applied in it? I applied filters and saved it

  7. #7
    Registered User
    Join Date
    11-25-2013
    Location
    ND
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Checkboxes for Filtering have disappeared :(

    The filters were applied, but when I went to change the filter in the pivot table, I was unable to change the filter. I was able to change the filtering in the list, but the checkboxes were not there. Is it possible some VBA got messed up and it affected the filtering and showing of the checkboxes?

  8. #8
    Registered User
    Join Date
    11-25-2013
    Location
    ND
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Checkboxes for Filtering have disappeared :(

    Looks like this is an issue with Office Updates. This came from Microsoft.com. I have the issue described below, Im running W7x32 and '13 also.

    "I just ran into this problem although im running W7x32 with Office 2013. In my case uninstalling KB2827238 fixes the checkboxes. I will note that when the update installs, it shows up 4 different times under installed updates and I had to uninstall all 4 before the problem was fixed. If I reinstall that update it breaks again."

    Here is the link in case anyone else runs into this issue. http://answers.microsoft.com/en-us/o...3-8bffd50e9f0c

  9. #9
    Registered User
    Join Date
    11-25-2013
    Location
    ND
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Checkboxes for Filtering have disappeared :(

    I got this problem solved. Ended up uninstalling MS Office and reinstalling, problem went away. Thanks for advice on this.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,613

    Re: Checkboxes for Filtering have disappeared :(

    I am happy you got your problem resolved, and thank you for sharing the solution with us

+ 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. Replies: 4
    Last Post: 04-28-2013, 12:47 AM
  2. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  3. Filtering to multiple criteria via checkboxes in VBA
    By Viv_bot in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-11-2012, 04:41 AM
  4. Problems filtering data containing checkboxes???
    By nameyers in forum Excel General
    Replies: 1
    Last Post: 10-18-2007, 02:48 PM
  5. Replies: 1
    Last Post: 07-18-2005, 11:05 AM

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