So i requested a PowerPivot workbook from SharePoint, what happens?

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

In my previous blog posts we made use of a published PowerPivot workbook to use a datasource. In this post we are going to discover what goes on under the hood  when you call a PowerPivot workbook on a SharePoint 2010 server. Thanks to Denny Lee from the PowerPivotTwins for reviewing this post, clearing some things up and providing excellent information.

When I make a connection with the browser to the workbook of a published xlsx by clicking the PowerPivot gallery the following things happen:

  • The Excel web access service starts rendering the workbook
  • It will connect to Excel Calculation Services which will extract the workbook from the SharePoint content dB


Tags: sharepoint


2007-2015 VidasSoft Systems Inc.