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“:
Step 2: Then click on the “Add-Ins” tab and select to manage “COM Add-Ins“:
Step 3: In the COM Add-Ins dialog, check the “Microsoft Power Pivot for Excel” option and click “OK“.
That’s it! Now PowerPivot is enabled! You can see that a new menu named “Power Pivot” appeared:
You can then click on “Manage” and the PowerPivot dialog appears via which you can import data from various sources:
Check also: My eBooks on SQL Server
Rate this article:
Reference: TechHowTos (https://www.techhowtos.com)