Databases Reference
In-Depth Information
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.
1.
Click the Save As tab, as shown in Figure 7-1.
2.
In the Save As section, select Computer and then click the Browse button.
3.
Type the URL for the SharePoint site to which you want to upload the workbook and click
Save.
4.
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.
Search WWH ::
Custom Search