The information in this article applies to:
SYMPTOMSMicrosoft 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." CAUSEThe 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. WORKAROUNDAssume 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, choose Search in Microsoft
Excel Help and type:
Additional query words: 5.00a 5.00c 7.00a 97 XL97 XL7 XL5 database extract
Keywords : kbdta xllist |
Last Reviewed: July 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |