I’ve had the question if its possible to show a PowerPivot workbook using a Excel web access webpart. The answer: Of course it is, the workbook is a regular excel workbook, so you can just point from the Excel web access webpart to a PowerPivot workbook from the powerpivot gallery. Users can interact with the PowerPivot workbook instantly as they would in a report:
The excel web part isn’t available at the PowerPivot site collection. I have created a BI site collection and added a PowerPivot Library to it. In the BI site collection we can use the excel web access webpart.
Excel 2010 will be a developers heaven, the MS excel team has written a blog post on how you can get to certain data in a Excel sheet published on Excel Services 2010.
The opportunities for using REST are virtually endless. To spur your imagination, here’s a sampling of some ways to use the REST API:
- Embed a chart or range in a web page, blog post, etc.
- Embed a chart as a “linked” image into a Word document, PowerPoint presentation, or Outlook mail, and have always up-to-date information.
- Build a “mash-up” that uses Excel Services for calculation, charting, and/or as a data source.
- Build a Windows 7 gadget that displays information from an Excel workbook
- …and many more ideas I am sure our customers will think up.
Phew the SharePoint 2010 product will really be “social” and really enable self service. Read the entire post at their blog.
On MSDN you can find an very nice article which provides tips for and answers to frequently asked questions for using Microsoft Office SharePoint Server 2007 with Microsoft Office Excel 2007 and Excel Services. It gleans community-contributed information from the SharePoint – Excel Services forum on the Microsoft Developer Network (MSDN).
