XL: Advanced Filter Does Not Detect Additions to List

 Last reviewed: February 2, 1998
Article ID: Q126044
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

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: 

   $A$1:$C$10
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: 

   $A$1:$C$10
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, choose Search in Microsoft Excel Help and type: 

   advanced filter

Additional query words: 5.00 5.00a 5.00c 7.00 7.00a 97 98 XL98 XL97 XL7 XL5
database extract
Keywords : xllist
Version : WINDOWS:5.0,5.0c,7.0,7.0,a,97; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.