Microsoft Excel Filters (last row doesn't filter)

[NathanGRobinson]

Hi,

I'm using tables in MS Excel 2007 (I also remember having similar issues
with 2003). The table contains static data, text and formulas. I'm using the
auto-filter function, but for some reason some of the rows aren't filtering
properly. At the moment, the table has 70 rows in it, but when I filter, it
doesn't filter the final 4 rows. (eg: I filter column D for the value 22,
which works up to row 66, but the final 4 rows stay in the table regardless).
Upon unfiltering the data, some of the rows remain hidden. I've no idea why
this is happening. I've tried turning the auto-filter on and off but to no
avail. FYI: The formatting doesn't change between any of the rows. Any ideas?

 

[NathanGRobinson]

Hi Roger,

Thanks for your response. I've double checked the table and all rows are
included in the range. I've actually also discovered that if I continue to
filter the same column over and over again, each time I do so, an extra row
is dropped off the bottom as a non-filtered line.

Am I possibly looking at a corrupted worksheet?