Sharing Solutions

If PowerPivot solutions consume too much storage for e-mail, keeping multiple copies of a solution is a poor revision control solution. In this chapter, we will cover using SharePoint document library revision control, inherent in the PowerPivot Gallery, as a solution-level rewind button.

In the initial release of PowerPivot, there is no user-level security built into the product. However, using SharePoint and permissions on the storage mechanism, the PowerPivot Gallery, we can implement restrictions on the user's ability to see and open PowerPivot solutions stored in SharePoint.

If SharePoint is the standard deployment platform for PowerPivot solutions, why do we need Excel, or a desktop for that matter, to consume PowerPivot ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.