Excel 'Get and Transform' options

Question

I have Office Professional Plus 2016 but do not have the subject options in the Data ribbon of Excel.

Updates tells me that I have all updates (as of 07Oct18).

How do I get this new functionality?

Answer 1

Most versions of Excel do not include Get and Transform (formerly called PowerPivot); it is only distributed with certain Office products and I'm afraid yours may not be one of those. See https://support.office.com/en-us/article/Where-...

Versions that include PowerPivot are:

Office 365 Pro Plus

Office 365 Enterprise E3

Office 365 Enterprise E5

Office Professional 2016

Office 2016 Professional Plus (available via volume licensing and HUP only)

Office Professional Plus 2013 (available via volume licensing and HUP only)

Excel 2016 standalone

PowerPivot is NOT included with any of the following:

• Subscriptions that do not include PowerPivot Office 365 Education Office 365 University Office 365 Home Office 365 Personal Office 365 Small Business Premium Office 365 Business Essentials Office 365 Business Office 365 Business Premium Office 365 Enterprise E1
• Products with a one-time purchase (perpetual license) That do NOT include PowerPivot Office Home & Student 2013 Office Home & Student 2016 Office Home & Business 2013 Office Home & Business 2016 Office Professional 2013 Office for Mac Office for Android Office RT 2013 Office Standard 2013 All Office versions older than 2013

Excel 2010 did not come with PowerPivot but it was available for all versions as a download. That download, though, does not work with later versions of Excel. If you have a licensed copy of Excel 2010, you can download it from here: https://www.microsoft.com/en-us/download/detail...

This response is inspired by information provided by E for Excel in this previous response: https://answers.microsoft.com/en-us/msoffice/fo...

The list for Office 365 may have changed. It is my understanding, which may be mistaken, that all Office 2019 Excel applications will have power piviot.