oData is an Open Data Protocol for querying and updating data. You can view a few demos here. The PowerPivot is one of the most useful/HOT features in my view. Only drawback is it’ll be consumed in Excel 2010 ONLY, not in Excel 2007 which the most of the world may still use next few years (i.e. Enterprises/small-medium businesses which can’t afford to upgrade to Office 2010).

To make this available in Excel 2007, I’ve suggested on the Connect site here. Please please vote!

2 Comments

• James Tharpe said Friday, August 20, 2010 10:58:42 AM

  Voted! I work in a corporate environment and upgrading to Excel 2010 is not under my direct control. Having it in Excel 2007 would be great.

• Matt Simms said Friday, September 10, 2010 1:50:38 PM

  I know this comment is late but you can write a COM accessible .NET wrapper for Querying your OData services.