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?

 

[van den acker]

Hi Nathan

I have similar issue. How has yours been solved?

thanks
Luc
l

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?

"Roger Govier" wrote:

> Hi Nathan
>
> With your cursor within the table, select Design tab>Properties>Resize Table
> What does it show for the current range?
> If it does not include all of your rows, then re-select the are concerned
> and click OK.
>
> --
> Regards
> Roger Govier
>
> "NathanGRobinson" <(e-mail address removed)> wrote in
> message news:(e-mail address removed)...
> > 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?
>