Forum Discussion
Solved
Please Please Please make it clearer which versions of Excel contain Power Pivot
On the office 365 plans page a lot of screen space is taken up highlighting (IMHO) fairly low priorty features for small and medium businesses. The fact that none of these plans contains Power...
Thank you for letting us know there is some confusion about how to get Power Pivot, and which versions of Office have it. We've put together a help article at https://support.office.com/article/aa64e217-4b6e-410b-8337-20b87e1c2a4b with details about PowerPivot availability. Please start a new thread to let us know if you continue to encounter any issues.
Thanks
Ash
Excel
They don't contain some other features as well. More exact comparing is here https://technet.microsoft.com/en-us/library/office-applications-service-description.aspx
I guess the logic is since you compare only O365 Business plans features which are not included in any one of them are not mentioned at all. If you compare Enterprise versions they mention "Self-service Business Intelligence" which is included into all of them but E1
Hi Sergei, by coincidence I'd come across that table from your first link myself.
Because it was difficult to read I ended up using Power Query to pull the data into Excel :)
https://www.linkedin.com/pulse/which-versions-excel-contain-power-pivot-wyn-hopkins
Thank goodness Power Query is available for all!
Hi Wyn,
Quite professional approach, i like it.
Back to the subject, i fully support the idea that Power Pivot is to be included in any version of Excel, at least any version for the business. I could understnad the separation which was few years ago when PowerPivot starts (from Gemini? don't remember the name...).
IMHO, right time to expand the tool on all business versions was together with adding space in the name between Power and Pivot.
Now it looks especially strange when we have Power BI Desktop having exactly the same engine as Excel Power Pivot and which is free of charge for everyone.
By the way, there was the workaround for 2013 (not sure about 2016) - if install any trial version of Excel (or Office) with PP in parallel with version without it excluding on installation everything but PP - you will have fully functional version of Excel. Technically no additional licenses is required, not sure about legal stuff. But in practice that doesn't work for the company , could be used on personal level.
