How to Enable PowerPivot in Excel 2016

Quick tech tips on Tech How To's

PowerPivot is an add-in for Excel that enables you to import and process millions of records from various sources right into Excel very fast.

For old versions of Excel (i.e. version 2010) you needed to download and install PowerPivot in order to enable it in Excel. In Excel 2016 (or 2013) you can just enable PowerPivot as per the below steps:

Step 1: In Excel 2016 (or 2013), navigate to “File” and then “Options“:

How to Enable PowerPivot in Excel 2016 - Article on TechHowTos.com

 

Step 2: Then click on the “Add-Ins” tab and select to manageCOM Add-Ins“:

How to Enable PowerPivot in Excel 2016 - Article on TechHowTos.com

 

Step 3: In the COM Add-Ins dialog, check the “Microsoft Power Pivot for Excel” option and click “OK“.

How to Enable PowerPivot in Excel 2016 - Article on TechHowTos.com

 

That’s it! Now PowerPivot is enabled! You can see that a new menu named “Power Pivot” appeared:

How to Enable PowerPivot in Excel 2016 - Article on TechHowTos.com

 

You can then click on “Manage” and the PowerPivot dialog appears via which you can import data from various sources:

How to Enable PowerPivot in Excel 2016 - Article on TechHowTos.com

 

Read also on SQLNetHub: The PowerPivot Experiment

Check also: My eBooks on SQL Server

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 5.00 out of 5)

Loading...

Reference: TechHowTos (https://www.techhowtos.com)

© TechHowTos.com

Share this!
Avatar
About Artemakis Artemiou 33 Articles
Artemakis Artemiou is a Senior SQL Server and Software Architect, Author, and a former Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.