Really appreciate the article, hope SQL Server Central will consider many more articles like this one.

Could SQL Server Central please create a major category for SQL / Excel with the sub folders?

Excellent article, that only scratches the surface.

As a consultant to an international organization, I provide Excel 2010 reports that include Excel Object programming distributed with Citrix.

The use of SQL Server, Excel Objects, and Access 2010 run-time is extremely powerful for custom real-time analysis.

When groups of engineers, accounting, and compliance meet, they can perform "what-if" decision processes dynamically with Excel, a tool they know.

Rich User Interfaces such as Excel instead of HTML post increases worker efficiency. Data-Mining SQL Server with Excel is very powerful.

Users provided with selected views of Excel can work with the results more efficiently and cost effectively.

The speed of a seasoned Excel Object Model Programmer to deliver complex Business-Rule-Based decision tools over SharePoint is another consideration.

SharePoint and SSRS are very efficient for high-volume standard Internet-wide uses.

There is still a need for small-business or business units to utilize rich interface tools such as Excel for critical and timely business rule based decision process.