Forum Discussion
Excel Filter Not Working after Certain Row
jbabineaux92 Is it possible the upper part is a defined table and the data below is not included in that table like this:
You can check the Name Manager to see if a table is defined for that range. If so when you click on any cell in that range you will get a "Table Design" menu item in the menu bar. And then on the left you can select "Resize Table" to include the additional data
mtarler I saw some of the fixes mentioned (e.g. tables).
I have none. This is just a large set of data that was able to filter and now can't
The filter option is grayed out as well.
Tried rebooting but to no avail.
Why is this happening and how do I fix this?
If you added new rows of data, let's say, the following day or even right after you have created the filter- you may experience this problem. You will need to delete your filter on that column, then highlight everything in the column INCLUDING the new data you made, and then create the filter for that column again. Try that and see if it works.