XL: AutoFilter Status Bar Message Shows "Filter Mode"ID: Q189479
|
If you filter a list in-place in Microsoft Excel, the status bar may
display the following message:
Filter Mode
<number> of <number> records found
This problem may occur when the following conditions are true:
To work around this problem, temporarily prevent the formulas from
calculating when you run a filter. To do so, follow these steps:
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
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.
For more information about AutoFilter, click Contents And Index
on the Help menu, click the Index tab in Excel 97 Help, type the
following text
filters, autofilter
filters, advanced
Additional query words: XL97
Keywords : kbdta xllist
Version : MACINTOSH:5.0,5.0a; WINDOWS:5.0,5.0a,5.0c,7.0,7.0a,97
Platform : MACINTOSH WINDOWS
Issue type : kbbug
Last Reviewed: May 3, 1999