+ Reply to Thread
Results 1 to 9 of 9

excel filter no boxes are shown to check or uncheck

Hybrid View

  1. #1
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: excel filter no boxes are shown to check or uncheck

    11,000 rows are too much for autofilter to extract each unique value.. Would Advanced Filter be an alternative?

  2. #2
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: excel filter no boxes are shown to check or uncheck

    Quote Originally Posted by JieJenn View Post
    11,000 rows are too much for autofilter to extract each unique value.. Would Advanced Filter be an alternative?
    I can put a filter on a much larger list that 11000 and have done so without this issue. Plus excel will tell you that not all values are loaded because of a size that is too large but that is not my issue. I think you misunderstand. Here is the best way to show you what I am seeing. See picture
    Attached Images Attached Images
    Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.

+ 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. Using Check Boxes to Filter Data
    By EoghanMBH in forum Excel General
    Replies: 0
    Last Post: 10-24-2012, 06:11 AM
  2. [SOLVED] Pivot chart won't refresh when I uncheck filter boxes
    By Dr Martin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-02-2010, 11:46 AM
  3. Uncheck check boxes
    By Brisbane Rob in forum Excel General
    Replies: 3
    Last Post: 02-15-2006, 03:08 PM
  4. How can I insert a box that lets me check and uncheck it in Excel
    By The Lone Ranger in forum Excel General
    Replies: 1
    Last Post: 01-28-2006, 11:10 AM
  5. Uncheck Check Boxes when Workbook Loads
    By JB in Kansas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2005, 09:06 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