Publishing

Publishing a PowerPivot for Excel solution to SharePoint could hardly be easier. After the environment is established, deploying a PowerPivot solution takes one of two major paths. The first of these is conveniently located within Excel 2010's File option off the ribbon. The second is in SharePoint 2010, as an option of the PowerPivot Gallery's Document ribbon.

Working in Excel, publishing to PowerPivot for SharePoint is a simple matter of using the File menu. From an existing file, open PowerPivot for Excel solutions, as illustrated in Figure 7-1, and choose the “Save & Send” File menu option, which will enable options for Email, Web, and SharePoint. Choosing Save to SharePoint will show the most recent SharePoint servers used, similar ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.