Scot Hillier (Microsoft MVP) and Bhushan Nene just published an article titled “Building Excel 2007 and Excel Services Dashboards by Consuming Two-Dimensional Data from Web Services”.  The article shows how to develop a solution to consume web services in Excel and Excel Services to build dynamic dashboards.  The highlight of this solution is its ability to maintain the mapping between Excel objects and web services so that Excel and Excel Services workbooks can be refreshed on demand to show latest data.  Excel and Excel Services support such functionality for SQL Server and SQL Analysis Services but there is no out-of-box support for web services.

- Khawar