XL5: Advanced Filter Extracts All RecordsLast reviewed: September 12, 1996Article ID: Q117753 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel version 5.0, the Advanced Filter may return all records to the "Copy To" range, even though the criteria to return all records is not specified.
CAUSEThis problem occurs when a Print Area is set on the worksheet and you do either of the following:
WORKAROUNDSTo work around this problem, do either of the following:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows version 5.0c.
|
KBCategory: kbprb
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |