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

Jazz w/ a GeneraL Problem

Jazz with a General problem @ Yahoo! Video

Diablo III

Yeah, I'm a bit late on this. I've been busy >p

Damned if you Do Damned if you Don't

Wasting hours on a non-problem is frustrating to say the least.
Such is the case of not knowing about the CancelSelectOnNullParameter property of the ASP.NET 2.0 SqlDataSource control.

There was a time when if I wanted use a language / IDE I'd study a couple manuals cover to cover and Then dive in. While this was time and energy consuming, there was nothing like understanding your tools in their entirety to really solve problems in the most efficient manner. Well, I've gotten older and have a lot less time. My current method of solution discovery is trial and error. While frustrating & rewarding, it saves time in that I'm focused on the areas I believe I need to be in. I've used the SqlDataSource, GridView, FormView and most recently Telerik RadGrid Many times and never ran into a situation where the CancelSelectOnNullParameter was relevant. Now 2+ hours after I should have been on to the next section of the project I'm finally able to adequately test the BASICS of Data Access. I swear I thought I was losing it when the data grid wasn't showing up on a tested and working SqlDataSource. Why does the test work differently than the actual implementation?!?! No more bitching, but a HUGE thanks to ecbruck from the ASP.NET forums.

I'd post a thank you there, but they have the Most RETARDED (that is a medical and technical term not to be confused with salnder again the mentally challenged) non-passport login system! I forgot my password. Send me a link to a page to reset it, except I'm Denied Access to the reset page. WTF!!?!!? Ok. Now, no more bitching... for now.


So, in summary:

If your Gridview, RadGrid, DataReader, etc is not returning data when you KNOW it should be and its DataSource is a SqlDataSource (or AccessDataSource) and there are parameters with no value (null) being passed to it, it's probably because the CancelSelectOnNullParameter property is set to True (the default). Set to false and let the data flow again. I'm so frustrated right now.

I LOVE O'Reilly Safari Video

Another year and I Still Love my virtual bookshelf. In addition to adding publishers,
they've added Video! Currently over 600 hours.

It's gotten to the point where It's not about available content, but managing the available content. With over 300 books in my favorites (at this point I think of them as marked for perusal) it's getting a bit more difficult to even open existing favs before a whole new set is coming down the pipe. Mmmmm, Information Overload (*Homeresque Gargle...*)

	Programming (89)
	Java (19)
	JavaScript (16)
	C# (12) ">More >
	Internet/Online (65)
	Web Development (17)
	.Net (10)
	JavaScript (8) ">More >
	Business (50)
	Project Management (21)
	Executive Skills Development (7)
	Personal Development (7) ">More >
	Databases (46)
	SQL Server (30)
	SQL (10)
	Data Mining (4) ">More >
	Graphics (42)
	Photoshop (16)
	Flash (12)
	Digital Photography (10) ">More >
	Markup Languages (21)
	XML (14)
	HTML (5)
	Schema (2) ">More >
	Operating Systems (18)
	Linux (11)
	Windows (4)
	UNIX (2) ">More >
	Software Engineering (18)
	Management (5)
	OOP (2)
	Process (2) ">More >
	Networking (13)
	Administration (4)
	Windows (2)
	Architecture and Design (1) ">More >
	Security (7)
	Internet/Online (2)
	Networking (2)
	Software Engineering (2) ">More >
	Computer Science (6)
	Coding (3)
	Information Theory (1)
	Certification (4)
	Microsoft (4)
	Desktop Applications (4)
	Office (2)
	Excel (1)
	Groupware (1) ">More >
	Human-Computer Interaction (4)
	Interface Design (4)
	Usability (2)
	Artificial Intelligence (3)
	Cognition (2)
	Machine Learning (1)
	IT Management (3)
	Network Management (1)
	Multimedia (3)
	After Effects (1)
	Animation (1)
	Desktop Publishing (2)
	Fonts (1)
	Print Production (1)
	Enterprise Computing (2)
	System Administration (1)
	Hardware (2)
	Networking (1)
	Upgrading and Repairing (1)

I still can't help but recommend this service (can't just call it a site) to anyone that consumes technical books and has an internet connection. For those that prefer real books for the type and layout, there's now an option on many title for reading in print fidelity.

I'm still not a fan of the token system. I use them because I have them, but have no real interest in creating a collection of random chapters. However, this feature is completely obscured by the overall awesomeness of the service.