+ Reply to Thread
Results 1 to 2 of 2

Table filters - blank boxes

  1. #1
    Registered User
    Join Date
    04-29-2012
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    3

    Table filters - blank boxes

    Im using a table that has filters. When I uncheck filter boxes, the row for that filter does not appear on the table (as expected). The unchecked boxes have been available to re-checked in the drop downs if I want the data to show again. Recently, my file changed. This is a file that others can have access to. The change to the table was that all the unchecked boxes on the file that were previously available on the drop downs, all disapeared. I have lost the data that was available on the unchecked items.

    Is this an option that can be changed on a table in Excel? I would prefer the unchecked items remain available to place back on the file in the future and have the data to use.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,039

    Re: Table filters - blank boxes

    THis sounds like an excel question, but you posted in teh Access forum.

    Do you want this moved to an excel forum?
    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

+ 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: 0
    Last Post: 08-09-2021, 04:33 PM
  2. vba ignore 2 pivot table filters all and blank
    By _eNVy_ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2020, 09:34 AM
  3. [SOLVED] User form: with check boxes how do i allow MULTIPLE auto filters to run at the same time
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2016, 09:13 AM
  4. [SOLVED] Search Funcation, Select boxes and Hyperlinks with existing Advanced Filters
    By sammyp1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2014, 11:27 PM
  5. Macro to print all pivot table filters but excluding blank pages
    By Hdim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2014, 03:03 PM
  6. Button or tick boxes setting filters
    By D-smoke in forum Excel General
    Replies: 16
    Last Post: 07-26-2012, 02:14 PM
  7. Filters and Check Boxes
    By Steved in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-26-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