Excel AutoFilter status bar displays "Filter Mode" instead of Filtered Count

I work with quite a few spreadsheets and couldn't figure out why autofiltered data would not consistently show filtered count, instead showing "Filter Mode".

Lo & Behold there's a knowledgebase article for this issue (2 actually).

For Excel 5.0, 95, 97
http://support.microsoft.com/kb/q189479/

For Excel 97, 2000, 2002, 2003
http://support.microsoft.com/kb/213886

Soooo the problem has existed for a really long time, with no Real solution.

Workaround (from 2nd kb article) is as follows:

To temporarily work around this problem, prevent the formulas from calculating 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.

:/

Tech Support Self Service Email

I originally sent as an email, ergo, last line.

Check out xkcd.com for more simply brillant, math/tech based hilarity.

In the unlikely even you do not find this Helpful AND/OR Hilarious
(which means you fail at computers & humor), please see form below....



Addendum: Notice how you only see my name on this email? It's called BCC. Use It! ;p

Can I post again yet?

Just wondering

"BCMLogon.dll"

"A recently installed program has disabled the Welcome screen and Fast User Switching. To restore these features, you must uninstall the program. The following file name might help you identify the program that made the change: C:\WINDOWS\system32\BCMLogon.dll"

First Step: Google "BCMLogon.dll"
Found this site:

Strangely enough, it was a comment below it that gave me an idea of how to resolve this issue. The mention of wireless networking reminded me of this dialog:

Unchecking "Authenticate prior to Windows domain logon" removed the BCMLogog.dll issue and brings you one step closer to without opening the registry. Hopw this is helpful.