You are currently offline, waiting for your internet to reconnect

The AutoFilter status bar displays the "Filter Mode" message in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q213886
This article has been archived. It is offered "as is" and will no longer be updated.
If you filter a list in-place in Microsoft Excel, the status bar maydisplay the following message:
Filter Mode
This message is incorrect. Instead, the status bar should display thefollowing message:
number of number records found
where number is the appropriate number of records.
This problem may occur when the following conditions are true:
  • You have 51 or more formulas in a list.

  • You filter the list in-place (that is, you click AutoFilter on the Data menu, and then select a value from the AutoFilter list; or you click Advanced Filter on the Data menu, click Filter the list, in-place, and then select a value from the filter list).

  • Each formula contains at least one cell reference.

  • Excel makes a change to the status bar to indicate the calculation of formulas before the filter process is completed.
To temporarily work around this problem, prevent the formulas fromcalculating when you run a filter. To do this, follow these steps:
  1. On the Tools menu, click Options.
  2. In the Options dialog box, click the Calculation tab.
  3. On the Calculation tab, click Manual under Calculation.
  4. Filter the list to see the filter results in the status bar.
To restore calculation, on the Tools menu, click Options. Click the Calculation tab, and then click Automatic under Calculation.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.
XL2000 XL2002 XL2003

Article ID: 213886 - Last Review: 12/05/2015 12:22:42 - Revision: 4.3

Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft Excel 97 Standard Edition

  • kbnosurvey kbarchive kbbug kbpending KB213886