Power Pivot

Hi all, 

i am trying to activate power pivot add-in but it s not showing in the list. i have a office 365 .

please help me in activating it as i knew that it s included in 365 . 



You don't have to do anything to activate PowerPivot in 365.  Although some documentation still refers to PowerPivot as an addin, that is only for versions prior to 2016


<snip https://support.office.com/en-us/article/get-transform-and-power-pivot-in-excel-42d895c2-d1d7-41d0-88da-d1ed7ecc102d >


Where can I find Get & Transform and Power Pivot?

With Office 365, the Excel app on Windows for PCs offers the full Get & Transform and Power Pivot features that further enhance your analytics and modeling capabilities



Here are links to some MS documentation about PowerPivot.

! Welcome to PowerPivot           2011 05 22
Welcome to PowerPivot for Excel. This section includes an introduction to PowerPivot, how to install PowerPivot, and where to find sample data and videos.
.  *  Introducing PowerPivot for Excel
.  *  Learn About PowerPivot Capabilities
.  *  PowerPivot Capacity Specification
.  *  Install PowerPivot for Excel
.  *  Get Sample Data for PowerPivot
.  *  Watch Videos About PowerPivot Tasks
.  *  PowerPivot Overview for IT Administrators

!   PowerPivot Help Topics
This link is the home page for links to A LOT of articles and tutorials. Well worth digging through
Power Pivot provides advanced data modeling features in Microsoft Excel. Use the resources below to learn about how you can use Power Pivot to help you gain new insights into your data.

Get started

.  *    Learn more about data analysis tools in Excel
.  *    Power Pivot: Powerful data analysis and data modeling in Excel
.  *    Start Power Pivot in Microsoft Excel
.  *    Power Pivot keyboard shortcuts and accessibility

Partner Features
.  *    Power Query
.  *    Power View
.  *    Power Map

Data Modeling and Visualization Tutorials
.  *    Tutorial: Import Data into Excel, and Create a Data Model
.  *    Tutorial: Optimize your Data Model for Power View reporting
.  *    Get sample data for DAX and Data Model tutorials
.  *    Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX
.  *    Tutorial: Create Map-based Power View Reports
.  *    Tutorial: Incorporate Internet Data, and Set Power View Report Defaults
.  *    Power Pivot Help
.  *    Tutorial: Create Amazing Power View Reports - Part 2
.  *    Understanding the Excel Data Model (Office 15-Minute Webinar)

.  *    Understanding Power Pivot for Excel (Office 15-Minute Webinar)

.  *    Video: Set default fields in Power Pivot
.  *    Video: Hide columns and tables in Power Pivot
.  *    Video: Set the Power View default aggregation using Summarize By

Understand the Power Pivot Data Model
.  *    Create a Data Model in Excel
.  *    Create a memory-efficient Data Model using Excel and Power Pivot
.  *    When to use Calculated Columns and Calculated Fields
.  *    Lookups in Power Pivot Formulas
.  *    VLOOKUP Functionality in Power Pivot
.  *    Version compatibility between Power Pivot Data Models in Excel 2010 and Excel 2013 and Excel 2016
.  *    Upgrade Power Pivot Data Models to Excel 2013 or Excel 2016
.  *    Data Model specification and limits
.  *    Data types in Data Models
.  *    Freeze columns

Add Data
.  *    Get data using the Power Pivot add-in
.           *    Get data from a data feed in Power Pivot
.           *    Get data from Analysis Services
.           *    Import Data from a Reporting Services Report
.           *    Make changes to an existing data source in Power Pivot
.  *    Find out which data sources are used in a workbook data model
.  *    Filter the data you import into Power Pivot
.  *    Create a blank table in Power Pivot
.  *    Refresh imported data in Power Pivot
.  *    Troubleshoot linked tables
Tip: Power Query for Excel is a new add-in you can use to import data from many different source into your Excel workbooks and data models. Learn more at Microsoft Power Query for Excel Help.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated March 17, 2020 Views 29 Applies to: