This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable. Show To create a PowerPivot-enabled project, you must create a PowerPivot-enabled Excel 2010 worksheet, design the information, PowerPivot view, and chart for the project, and then finally save and publish the project to a SharePoint PowerPivot gallery, where it can be viewed. Note: In Microsoft Excel 2013, before proceeding, see ARCHIVED: In Excel 2013, how do I enable the PowerPivot add-in? On this page:
Creating a PowerPivot-enabled worksheetNote: To create a PowerPivot-enabled Excel 2010 worksheet you will first need to download and install the PowerPivot for Excel 2010 add-in.
Once you have created the worksheet, you can proceed to designing the project information. Back to top Designing the project information
You will be returned to the PowerPivot for Excel book, and can proceed to designing the PowerPivot view. Back to top Designing the project view
Back to top Designing the project chartTo design a project chart, from the "PowerPivot Field List" pane, drag any of the query objects to either the "Slicers Vertical" or "Slicers Horizontal" pane. This will create a "slicer", which will be available next to the chart; clicking an option within the slicer permits filtering of data choices.
When you have finished designing the chart, you can save and publish the project to your SharePoint PowerPivot gallery. Back to top Saving and publishing the project
Note: If you encounter long delays when publishing your project, you may be able to improve your performance by changing a setting in Internet Explorer; see ARCHIVED: Why does Windows take so long to connect my drive mapped to SharePoint? Back to top Viewing the project in SharePointNavigate to your departmental PowerPivot gallery (the URL used to save the document) to view the end product. |