- 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.
- On the Tools menu, click Options.
- In the Options 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.
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.
Article ID: 213886 - Last Review: Apr 29, 2008 - Revision: 1