Installing & Enabling Power Pivot

The first step in your power pivot journey is to install it. In this lesson, learn how to do it.

What is in this lesson?

  • Introduction
  • Checking if you have Power Pivot
  • Enabling Power Pivot add-in
  • Downloading & Installing Power Pivot
  • Troubleshooting Power Pivot Install
  • Things to keep in mind after install
  • What if you are not able to install?
  • How to speed up Power Pivot?
  • Closing thoughts

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

60 thoughts on “Installing & Enabling Power Pivot”

  1. I have Excel 2016 on 365 membership. Pivot table is there in “Insert” on the menu bar but Power Pivot not showing anywhere, not on menu bar, not in COM add-ins; when I got to powerpivot.com it takes me to Business Intelligence & Analytics and talks about Power BI but nothing on power pivot. Assuming that BI includes power pivot, I couldn’t join because it wanted a work email for corporate use, not a personal email. When I found a download power pivot link, it wouldn’t install and said 2012 version not compatible (can’t remember the actual wording …).

  2. OK, it seems my version of excel doesn’t have PowerPivot. This highlights another novice’s problem – I thought Power Pivot was “how to be really powerful at Pivot”; I didn’t realise that it was an actual Microsoft product. Perhaps the title of the course now needs to be clear that it is a particular product, and only available in certain versions of Excel? So, I have paid money to learn Pivot. Can my money be transferred to another course? and what is the best course of action for me to be excellent in Pivot?? Thanks 🙂

  3. Hi Chandoo,

    I am on this page and I don’t see any instructions nor videos. I only see the titles of the of the lessons? Is that what supposed to be?

  4. I have Office 2016 Home & student version and Powerpivot is not available, i tried from File-Options-Addins-COM ADDins, but the powerpivot is not available. what finally understood is Office 2016 Home and Student version doest have Powerpivot option. Please let me know if there is a way i can install

        1. I invested money on MS Office 2016 home and Student and Excel 2016 Stand alone cost me same amount.
          is there any way i can buy only power pivot for MS Office 2016 home and Student . Please advise

  5. Hi Chandoo Sir,

    I am not seeing videos and excel files under the head “Installing & Enabling Power Pivot”
    I am using Excel 2016.
    I enrolled under Excel School 2.0 – Dashboards.

    Please help.

    Regards

    Sukhan

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.