Microsoft KB Archive/213996

= XL2000: Advanced Filter Does Not Detect Additions to List =

Article ID: 213996

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213996





SYMPTOMS
When you filter a list using the Advanced Filter command, Microsoft Excel 2000 does not detect new additions to the list.



CAUSE
The Advanced Filter command in Microsoft Excel initially recognizes your list, but does not detect additions to the list.

For example, if you have the following information in a worksheet   A1: Region  B1: Sales   C1:     D1: A2: East   B2: 200     C2:     D2: =B2>200 A3: West   B3: 500     C3:     D3: when you click Advanced Filter on the Data menu, the List range box displays the following range:

$A$1:$B$3

When you filter the list using the criteria in D2, and then add the following information  A4: South    B4: 600 A5: North   B5: 700 when you click Advanced Filter on the Data menu again, the List Range box still displays the original range:

$A$1:$B$3



WORKAROUND
Update the List range box. To do this, use either of the following methods.

Reset the List
You can reset the list by turning AutoFilter and Advanced Filter on and off:
 * 1) Select a cell in the original list range.
 * 2) On the Data menu, point to Filter, and then click AutoFilter.
 * 3) On the Data menu, point to Filter, and then click AutoFilter. Excel removes the AutoFilter.
 * 4) On the Data menu, point to Filter and then click Advanced Filter.

Edit the List Range Box

 * 1) Select a cell in the original list range.
 * 2) On the Data menu, point to Filter, and then click Advanced Filter.
 * 3) Type or select the new list range in the List range box. Click OK.



MORE INFORMATION
Microsoft Excel 2000 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 use the list as a database even though it is not defined as a database.

