After users create the PowerPivot Workbook, they can share it with their colleagues or some other important people. For this kind of process, Microsoft has a feature called PowerPivot for SharePoint, which shows the PowerPivot gallery in the SharePoint site if the user enables this feature. The people who are going to see the report need the permissions and URL in order to enter into the PowerPivot gallery. Herein, they can modify the file, interact with reports, and slice and filter the data in the browser mode. Everything that is done in the Excel workbook to create a report can also be done in the browser mode of PowerPivot through the SharePoint Server. The user can use PowerPivot in the SharePoint Server as a data source for another PowerPivot Workbook, and it is not necessary to install PowerPivot or even Excel on your local machine if you are using PowerPivot through SharePoint.
In this chapter, some typical explanations about...