In This Chapter
Understanding SharePoint and Excel Services
Publishing an Excel workbook to SharePoint
Using the Power Pivot Gallery
Refreshing Power Pivot data connections
By publishing your Excel reports and dashboards to SharePoint, you can make them available to others in your organization via a browser and prevent multiple users from having separate versions of your workbooks on their computers. You can also make your Power Pivot reports easier to find, share, and use.
In this chapter, you first discover how SharePoint helps organizations share and collaborate on data. You will then explore the options for publishing your Power Pivot reports to SharePoint.
SharePoint is Microsoft’s premier collaborative server environment, providing tools for sharing documents and data across various organizations within a company’s network.
Typically deployed on a company’s network as a series of intranet sites, SharePoint lets various departments control their own security, workgroups, documents, and data. As with ...