XL98: AutoFilter Status Bar Message Shows "Filter Mode" (189482)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q189482 SYMPTOMS
If you filter a list in-place in Microsoft Excel, the status bar may
display the following message:
Filter Mode
This message is incorrect. Instead, the status bar should display the
following message
<number> of <number> records found.
where <number> is the appropriate number of records.
CAUSE
This problem may occur when the following conditions are true:
- You have 51 or more formulas in a list.
-and-
- You filter the list in-place (you click AutoFilter on the Data menu
and select a value from the AutoFilter list or you click
Advanced Filter on the Data menu, click to select "Filter the list,
in-place," and select a value from the filter list.
-and-
- Each formula contains at least one cell reference.
-and-
- Excel makes a change to the status bar to indicate the calculation of
formulas before the filter process is completed.
WORKAROUND
To temporarily work around this problem, prevent the formulas from
calculating when you run a filter. To do so, follow these steps:
- On the Tools menu, click Preferences.
- In the Preferences dialog box, click the Calculation tab.
- On the Calculation tab, click Manual under Calculation.
- Filter the list to see the filter results in the Status bar.
To restore calculation, click Preferences on the Tools menu, click the
Calculation tab, and click Automatic under Calculation.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
Calculation of formulas may cause Excel to show the "Calculating <number>%"
message in the status bar. Depending on the complexity of the formulas,
this may occur when there are more than 50 formulas. The act of filtering
causes recalculation of formulas.
When you filter a list in-place, Excel displays the "<number> of <number>
records found" message, unless the status bar is changed before the filter
is completed. If you do not have a large number of formula cells to
calculate, Excel does not indicate the calculation with the status
indicator, but displays the typical "<number> of <number> records found"
message. However, if calculation is indicated in the status bar, even
though it is very brief, the status bar message changes to the "Filter
mode" message.
REFERENCES
For more information about AutoFilter, click Contents And Index on the Help
menu (or on the Balloon Help menu if you are using a version of the
Macintosh operating system earlier than 8.0), click the Index button in
Excel Help, type the following text
and then click Show Topics. Select the "Display a subset of rows in a list
by using filters" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
For more information about Advanced Filter, click Contents And Index on the
Help menu (or on the Balloon Help menu if you are using a version of the
Macintosh operating system earlier than 8.0), click the Index button in
Excel Help, type the following text
and then click Show Topics. Select the "Filter a list by using advanced
criteria" topic, and click Go To. If you are unable to find the information
you need, ask the Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbbug KB189482 |
|---|
|