PowerPivot for Excel and SharePoint
Publishing to SharePoint
After creating 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
In Excel, click the File tab on the Excel ribbon.
Click Save & Send, as shown in the following illustration.
In the Save & Send section, click Save To SharePoint.
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-enabled SharePoint document library with additional functionality that goes above and beyond the features available in standard SharePoint 2010 document libraries.