XL98: Advanced Filter Does Not Detect Additions to List (192215)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q192215 SYMPTOMS
Microsoft Excel automatically recognizes your list as a database. Because
of this behavior, it is not necessary to define the range for your
database. Functions such as sorting, subtotaling or filtering will use the
list as a database even though it is not defined as "database."
CAUSE
The Advanced Filter option in Microsoft Excel will initially recognize your
list, but when the list is filtered, Advanced Filter will not detect
additions to the list.
WORKAROUND
Assume your list initially consists of cells A1 through C10. When you run
the Advanced Filter, the List Range box will display the range:
If you add records to your list so it now consists of cells A1 through C20,
and then run the Advanced Filter again, the List Range box will still be
displayed as:
To update the List Range edit box, after clicking Advanced Filter on the
Edit menu, select the list range on the spreadsheet or manually type the
range into the List Range box.
REFERENCES
For more information about Advanced Filter, click Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
and then click Show Topics. Select the "Filter a list by using advanced
criteria" topic, and click Go To. If you are unable to find the information
you need, ask the Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB192215 |
|---|
|