Not all versions of Office 2016 Include Power Pivot

Short Version: You Want One of These 🙂

Office 365 ProPlus

Office 365 E3

Office 365 E4 andE5

Long Overdue Post!

2016 power pivot - what versions of Office Contain It?

You Want This, But What Versions Have It?

Awhile back, I posted about all of the cool improvements in Power Pivot 2016 as compared to 2013.  This followup helps you decide what version of Office 2016 to purchase.

Versions of Office 365 that DO Contain Power Pivot

Power Pivot *IS* included in the following Office 365 Plans:

Office 365 ProPlus

Office 365 E3

Office 365 E4 andE5

Good News:  It’s Also Back in Pro Retail!

For those of you who prefer non-subscription versions, good news.  Unlike the 2013 debacle, Office 2016 *does* offer Power Pivot in the Pro SKU that’s available for retail purchase:

Purchase and Download Office 2016 Pro from Amazon Here

What About Excel Standalone?

YES, Power Pivot WILL be included in the Standalone Excel SKU as well, but that is not available yet for purchase.

UPDATE: Power Pivot in Excel 2016 Standalone is now available here!

What Versions of Office 2016 do NOT Include Power Pivot?

Just to be clear, here are some Office 2016 versions that we are positive do NOT include Power Pivot:

Home and Business

Home and Student

Office 365 Home

Office 365 Personal

Office 365 Business Essentials

Office 365 Business

Office 365 Business Premium

Office 365 Enterprise E1

There also may be other versions that don’t include Power Pivot (for instance we are currently unsure about Office 365 University), so please don’t treat this as an exhaustive list, but those above are guaranteed NOT to have Power Pivot.