XL2001: AutoFormat Does Not Refresh After AutoFilter Is Applied (270087)


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
This article was previously published under Q270087

SYMPTOMS

When you use AutoFilter to change the properties of a cell in a list that has AutoFormat applied, the AutoFormat feature does not automatically refresh the appearance of the list.

WORKAROUND

To work around this issue, click any cell outside the list to refresh the format of the list.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Excel X for Mac.

MORE INFORMATION

For more information about using the List Manager, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click L.
  2. Scroll down until you locate list, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click Guidelines for creating a list by using the List Manager.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB270087
©2002 Microsoft Corporation. All rights reserved.