How to Enable PowerPivot in Excel 2016 or Later

This article, discusses about PowerPivot and explains how you can enable PowerPivot in Excel 2016 or later, via a step by step guide.

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 or Later - Article on SQLNetHub

 

 

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

How to Enable PowerPivot in Excel 2016 or Later - Article on SQLNetHub

 

 

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 or Later - Article on SQLNetHub

 

 

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 or Later - Article on SQLNetHub

 

 

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 or Later - Article on SQLNetHub

 

 


Learn essential SQL Server development tips! Enroll to our Online Course!

Check our online course titled “Essential SQL Server Development Tips for SQL Developers
(special limited-time discount included in link).

Sharpen your SQL Server database programming skills via a large set of tips on T-SQL and database development techniques. The course, among other, features over than 30 live demonstrations!

Essential SQL Server Development Tips for SQL Developers - Online Course
(Lifetime Access, Certificate of Completion, downloadable resources and more!)

Enroll Now with Discount!


 

Featured Online Courses:

 

Other articles to check on SQLNetHub:

 

 

Recommended Software Tools

Snippets Generator: Create and modify T-SQL snippets for use in SQL Management Studio, fast, easy and efficiently.

Snippets Generator - SQL Snippets Creation Tool

Learn more

 

Dynamic SQL Generator: Convert static T-SQL code to dynamic and vice versa, easily and fast.

Dynamic SQL Generator: Easily convert static SQL Server T-SQL scripts to dynamic and vice versa.

Learn more

 

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Easily generate snippets with Snippets Generator!

Secure your databases using DBA Security Advisor!

Generate dynamic T-SQL scripts with Dynamic SQL Generator!

Check our latest software releases!

Check our eBooks!

 

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

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub