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.
Bookmarks