Advanced Filter May Function on Protected Worksheet (175228)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
This article was previously published under Q175228 SYMPTOMS
If you have a protected Microsoft Excel worksheet and you try to filter a
list by using the Advanced Filter command, the list may be filtered in
place. Also, after your list is filtered, you cannot click Show All on the
Filter menu.
WORKAROUND
Because the Show All command is unavailable on a protected worksheet, you need to display all of the records in a filtered list in order to work around this problem. To do this, follow these steps:
- On the Data menu, point to Filter, and then click Advanced Filter.
- Clear the "Criteria range" box, and then click OK.
All of the records in the list are now displayed.
NOTE: Currently, there is no way to prevent the Advanced Filter command
from filtering a list in place on a protected worksheet.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
When a worksheet is protected (with the default settings), you are unable
to resize or hide rows and columns in the worksheet. However, when you use
the Advanced Filter command to filter a list in place, certain rows in your
list may be hidden based on the criteria you specify.
REFERENCES
For more information about using Advanced Filter, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to "Filter a list by using
advanced criteria" topic.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | KB175228 |
|---|
|