Short Version: You Want One of These 🙂
Long Overdue Post!
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:
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:
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.