View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard-44 Richard-44 is offline
external usenet poster
 
Posts: 1
Default Excell Data Filter Fails to Integrate New Data-rows

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 DataFilter facility, or is there a
work-around, such as inserting rows at the top, or at the bottom (vs.
wherever you're working.)

Thanks