Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

How to Enable PowerPivot In Excel 2010 Using Simple Steps

How to Enable PowerPivot In Excel 2010 Using Simple Steps

“PowerPivot will bring a lot more freedom to our information workers because they will have powerful, easy-to-use data analysis tools right on their PCs…without having to come to the IT department for help…”
Ayad Shammout, Lead Technical Database Administrator, CareGroup Healthcare System

I am sure above words will definitely inspire you. If you really want freedom in data analysis, PowerPivot is your buddy. When I have started using it in Excel 2010, there was only one issue which I had faced is to Enable PowerPivotIn Excel 2010, unlike earlier versions of Microsoft Excel you have to activate it first before using it.

If you are still using excel 2010, this post is for you. I will show to How to Activate PowerPivot In Excel 2010 which is just like all other Add-Ins.

System Requirement to Enable PowerPivot In Excel 2010

  • A Windows version of Excel, either 32-bits or 64 bits.
  • Minimum of 1 GB of RAM (2 GB Recommended by Microsoft)
  • 3.5 GB of available hard disk space in your system.

Steps to Enable PowerPivot In Excel 2010

In Microsoft Excel 2010, PowerPivot not comes with main office application. You have to download it from the Microsoft’s Download Center. Once you download the package just follow these simple steps to install in your  system.

  • Just install the PowerPivot from the file you have downloaded. It’ll take 2 – 3 minutes to install in your system.

Start Installation To Enable PowerPivot In Excel 2010

Finish Installation To Enable PowerPivot In Excel 2010

  • Once you install the PowerPoint In Excel 2010, Just start your excel application.
  • Now you have a new, Tab in your Excel Ribbon.

Your New tab For To Enable PowerPivot In Excel 2010

Here is a short video by Microsoft to Install PowerPivot In Excel 2010.   WMA | MP4

More Tips

Back To Blog


  • Ogundepo Ezekiel Adebayo

    What is the use of power pivot in Excel?

  • Rahim Zulfiqar Ali

    I am using excel 2010 32 bit and have installed power pivot add in. Every time I restart excel the add in goes off from ribbon and I have to reactivate it. I also have personal macro workbook in xlstart with lots of macros in them. I have gone over internet to see the possible causes and most common reason I have found is conflict of personal macro workbook with power pivot in excel 2010. I am also using power query which is working just fine. Do u have any fix for me plz?

    I cant change the version as it is licensed version (professional plus) used by my company. I have found couple of solutions to fix the problem through regedit but those are for excel 2013 or later.