| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Data Filter Fails to Integrate New Data-rows
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 On Nov 10, 12:15 am, Richard-44 wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Data Filter Fails to Integrate New Data-rows
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? "Pete_UK" wrote: 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 On Nov 10, 12:15 am, Richard-44 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why don't all my data rows show up in auto-filter? | Excel Worksheet Functions | |||
| moving column/cell data to rows/cells fails | Excel Worksheet Functions | |||
| Copy to in Adv filter deletes data in lower rows | Excel Discussion (Misc queries) | |||
| Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Linear Mode
