Excell Data Filter Fails to Integrate New Data-rows

[Guest]

It seems that whenever I input a new row of data into a spreadsheet-database,
the data filter does not notice/read/integrate the new row's info; so when I
query, even if the new row(s) do(es) not fit the query parameters, they
remain visible.

Is this an unavoidable quirk in the Data>Filter facility, or is there a
work-around, such as inserting rows at the top, or at the bottom (vs.
wherever you're working.)

Thanks

 

[Pete_UK]

This runs contrary to my experience with XL2k (and 97 before that),
where the filter range automatically adjusts itself if you add even
one field of data immediately below the main group of records. There
should be no blank rows between the main database and the new record.

Pete

 

[Guest]

Pete,

Thanks, but the filter is not behaving in that way. I've checked for blank
rows, but there are none. (Good suggestion, though!) Any other ideas?