The AutoFilter status bar displays the "Filter Mode" message instead of no. of record found in Excel. Microsoft has confirmed that this is a problem in the Excel. There are some temporarily workaround provided by Microsoft.
- 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.
For details documents from Microsoft, please refere to The AutoFilter status bar displays the "Filter Mode" message in Excel (Q213886)