If Tools Option is set to Calculation is set to Auto, the filter count does not work.
S s2m via OfficeKB.com Jun 21, 2006 #1 If Tools Option is set to Calculation is set to Auto, the filter count does not work.
D Debra Dalgleish Jun 21, 2006 #2 When your list has many formulas, or if a cell in the list is changed after an AutoFilter has been applied, the Status Bar may show "Filter Mode" instead of a count of the visible records. The following MSKB article has information: The AutoFilter status bar displays the "Filter Mode" message in Excel http://support.microsoft.com/default.aspx?id=213886 And there are a couple of workarounds here: http://www.contextures.com/xlautofilter02.html#Count
When your list has many formulas, or if a cell in the list is changed after an AutoFilter has been applied, the Status Bar may show "Filter Mode" instead of a count of the visible records. The following MSKB article has information: The AutoFilter status bar displays the "Filter Mode" message in Excel http://support.microsoft.com/default.aspx?id=213886 And there are a couple of workarounds here: http://www.contextures.com/xlautofilter02.html#Count
