Check Microsoft Power Query for Excel, then OK to activate it. Go to File > Options > Add-Ins, then in the Manage drop-down at the bottom of the pane, select COM Add-Ins > Go. Learn more about starting the Power Pivot add-in for Excel 2013.Įxcel 2010 - Download the Power Pivot add-in, then install the Power Pivot add-in,Įxcel 2016 & Excel for Microsoft 365 - Get & Transform (Power Query) has been integrated with Excel on the Data tab.Įxcel 2013 - Power Query is an add-in that's included with Excel, but needs to be activated.
Excel 2016 & Excel for Microsoft 365 - Power Pivot is included in the Ribbon.Įxcel 2013 - Power Pivot is part of the Office Professional Plus edition of Excel 2013, but is not enabled by default.
