Counts showing up when filtered

[Dan Colgan]

Hello, I'm sure this is a simple thing but for some
reason, Excel is not showing the count at the bottom of
the screen when I apply a filter. It used to say "100 of
1707". I have tried changing status to "Count" but that
doesn't seem to fix the problem.

Any help would be appreciated.

Thanks

 

[Jason Morin]

Here are some links from MVP Debra Dalgleish's website
that explain:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter
Mode" Q213886)

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q213886

XL: AutoFilter Status Bar Message Shows "Filter Mode"
(Q189479)

http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q189479

HTH
Jason
Atlanta, GA

 

[Andy B]

Hi

Have a look at this:
http://tinyurl.com/2oo3o
There is an explanation and workarounds.