Using PowerPivot for SharePoint 2013
- A brief history
- When do I use PowerPivot for SharePoint?
- Publishing to SharePoint
- Scheduling data refreshes
- Workbooks as a data source
Publishing to SharePoint
After you create a PowerPivot workbook by using PowerPivot for Excel, you’ll likely want to share it with others in your department or organization. Your workbook becomes much more useful when others can use it.
To publish your workbook, perform the following procedure:
- In Excel, on the ribbon, click the File tab to display the Backstage view.
- Click the Save As tab, as shown in Figure 7-1.
- In the Save As section, select Computer and then click the Browse button.
- Type the URL for the SharePoint site to which you want to upload the workbook and click Save.
If you are publishing to a SharePoint site that has PowerPivot for SharePoint installed, you should publish it to the PowerPivot Gallery. The PowerPivot Gallery is a special PowerPivot-enable SharePoint document library that provides additional functionality beyond what’s available in the standard SharePoint 2013 document libraries.
Figure 7-1 Publishing a PowerPivot workbook to SharePoint.
The PowerPivot Gallery
The PowerPivot Gallery is a visually rich SharePoint document library that is installed with PowerPivot for SharePoint. Its enhanced visual presentation helps you to better interpret the data in each sheet of a PowerPivot workbook in the Gallery, as demonstrated in Figure 7-2.
Figure 7-2 The PowerPivot Gallery.
Clicking a specific sheet in the PowerPivot workbook opens the workbook in the browser where you can further analyze it, as illustrated in Figure 7-3.
Figure 7-3 Analyzing a PowerPivot workbook in the browser.