SOLVED
Home

Please Please Please make it clearer which versions of Excel contain Power Pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-29779%22%20slang%3D%22en-US%22%3EPlease%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-29779%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20office%20365%20plans%20page%20a%20lot%20of%20screen%20space%20is%20taken%20up%20highlighting%20(IMHO)%20fairly%20low%20priorty%20features%20for%20small%20and%20medium%20businesses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20fact%20that%20none%20of%20these%20plans%20contains%20Power%20Pivot%20is%20much%20more%20significant%20and%20should%20be%20flagged%20as%20such.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20shame%20that%20we%20have%20to%20go%20to%20an%20external%20source%20like%20the%20PowerPivotPro%20webpage%20to%20get%20a%20clear%20view%20of%20what%20versions%20of%20Excel%20contain%20Power%20Pivot.%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.powerpivotpro.com%2F2015%2F10%2Fwhat-versions-of-office-2016-contain-power-pivot%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.powerpivotpro.com%2F2015%2F10%2Fwhat-versions-of-office-2016-contain-power-pivot%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F8391i1D2388A7F75B061D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Versions.PNG%22%20title%3D%22Excel%20Versions.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-29779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-77297%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77297%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wyn%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20my%20memory%20there%20was%20no%20backward%20compatibility%20between%20Power%20Pivot%20for%26nbsp%3B2013%20and%20PowerPivot%20for%202010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20as%20I%20remember%20when%20I%20shifted%20on%202016%20with%20G%26amp%3BT%20and%20people%20around%20me%20still%20were%20on%202013%20we%20had%20no%20compatibility%20issues.%20I%20mean%20files%20with%20data%20models%20analysing%20with%20DAX%20and%20Power%20Pivot%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoogled%20a%20bit%2C%20people%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FIntegrations-with-Files-and%2FExcel-2016-Power-Pivot-Compatibility-to-Excel-2013%2Ftd-p%2F167323%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FIntegrations-with-Files-and%2FExcel-2016-Power-Pivot-Compatibility-to-Excel-2013%2Ftd-p%2F167323%3C%2FA%3E%20confirm%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-77214%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77214%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61898%22%20target%3D%22_blank%22%3E%40Bert%20van%20der%20Meer%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20understanding%20is%20that%20all%20versions%20of%20Excel%202013%20and%202016%20should%20be%20able%20to%20view%20%2F%20interact%20with%20Pivot%20Tables%20and%20reports%20created%20using%20Power%20Pivot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaving%20said%20that%20I've%20never%20actually%20tried%20it%2C%20%26nbsp%3Band%20would%20be%20interested%20to%20hear%20from%20anyone%20who%20has%2C%20especially%20if%20models%20containing%20DAX%20work%20well%20also.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-77200%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77200%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Bert%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20test%2C%20but%20my%20understanding%20Microsoft%20tries%20to%20keep%20compatibility%20between%20all%20supported%20versions%20of%20Power%20Pivot.%20And%20that's%20why%20Power%20Pivot%20doesn't%20support%20some%20new%20functionality%20introduced%20for%20Power%20BI%20Desktop%20and%20SSAS%20Tabular.%20Perhaps%20they%20have%202%20or%203%20branches%20of%20the%20same%20Analysis%20Service%20engine%20for%20above%203%20products.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20just%20my%20guess%2C%20better%20if%20someone%20from%20MS%20clarifies.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-77198%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77198%22%20slang%3D%22en-US%22%3E%3CP%3EAshvini%2C%3C%2FP%3E%3CP%3EWhat%20is%20not%20clear%20to%20me%20is%20if%20Power%20Pivots%2C%20prepared%2C%20for%20instance%2C%20in%20Excel%202016%20Professional%20Plus%2C%20will%20(continue%20to)%20work%20in%20Excel%20Professional%202013%20(that%2C%20apparently%2C%20does%20not%20contain%20Power%20Pivot).%3CBR%20%2F%3ECan%20yo%20ugive%20me%20some%20clarity%20on%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-52914%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-52914%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ashvini%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat%2C%20thank%20you%20for%20publishing%20that.%20This%20question%20is%20one%20which%20people%20are%20asking%20for%20years%2C%20now%20we%20have%20straightforward%26nbsp%3Binfo.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-52780%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-52780%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20letting%20us%20know%20there%20is%20some%20confusion%20about%20how%20to%20get%20Power%20Pivot%2C%20and%20which%20versions%20of%20Office%20have%20it.%20We've%20put%20together%20a%20help%20article%20at%20%3CA%20title%3D%22Help%20Article%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2Faa64e217-4b6e-410b-8337-20b87e1c2a4b%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Farticle%2Faa64e217-4b6e-410b-8337-20b87e1c2a4b%3C%2FA%3E%20with%20details%20about%20PowerPivot%20availability.%20Please%20start%20a%20new%20thread%20to%20let%20us%20know%20if%20you%20continue%20to%20encounter%20any%20issues.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAsh%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33293%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33293%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wyn%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuite%20professional%20approach%2C%20i%20like%20it.%3C%2FP%3E%3CP%3EBack%20to%20the%20subject%2C%20i%20fully%20support%20the%20idea%20that%20Power%20Pivot%20is%20to%20be%20included%20in%20any%20version%20of%20Excel%2C%20at%20least%20any%20version%20for%20the%20business.%20I%20could%20understnad%20the%20separation%20which%20was%20few%20years%20ago%20when%20PowerPivot%20starts%20(from%20Gemini%3F%20don't%20remember%20the%20name...).%3C%2FP%3E%3CP%3EIMHO%2C%20right%20time%20to%20expand%20the%20tool%20on%20all%20business%20versions%20was%20together%20with%20adding%20space%20in%20the%20name%20between%20Power%20and%20Pivot.%3C%2FP%3E%3CP%3ENow%20it%20looks%20especially%20strange%20when%20we%20have%20Power%20BI%20Desktop%20having%20exactly%20the%20same%20engine%20as%20Excel%20Power%20Pivot%20and%20which%20is%20free%20of%20charge%20for%20everyone.%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20there%20was%26nbsp%3Bthe%20workaround%20for%202013%20(not%20sure%20about%202016)%20-%20if%20install%26nbsp%3Bany%20trial%20version%20of%20Excel%20%26nbsp%3B(or%20Office)%20with%20PP%20in%20parallel%20with%20version%20without%20it%20excluding%20on%20installation%20everything%20but%20PP%20-%20you%20will%20have%20fully%20functional%20version%20of%20Excel.%20Technically%20no%20additional%20licenses%20is%20required%2C%20not%20sure%20about%20legal%20stuff.%20But%20in%20practice%20that%20doesn't%20work%20for%20the%20company%20%2C%20could%20be%20used%20on%20personal%20level.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33264%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33264%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%20%26nbsp%3Bby%20coincidence%20I'd%20come%20across%20that%20table%20from%20your%20first%20link%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20it%20was%20difficult%20to%20read%20I%20ended%20up%20using%20Power%20Query%20to%20pull%20the%20data%20into%20Excel%20%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fpulse%2Fwhich-versions-excel-contain-power-pivot-wyn-hopkins%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fpulse%2Fwhich-versions-excel-contain-power-pivot-wyn-hopkins%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20goodness%20Power%20Query%20is%20available%20for%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-31047%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Please%20Please%20make%20it%20clearer%20which%20versions%20of%20Excel%20contain%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-31047%22%20slang%3D%22en-US%22%3E%3CP%3EThey%20don't%20contain%20some%20other%20features%20as%20well.%20More%20exact%20comparing%26nbsp%3Bis%26nbsp%3Bhere%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Foffice-applications-service-description.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Foffice-applications-service-description.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20guess%20the%20logic%20is%20since%20you%20compare%20only%20O365%20Business%20plans%20features%20which%20are%20not%20included%20in%26nbsp%3Bany%20one%20of%20them%20are%20not%20mentioned%20at%20all.%20If%20you%20compare%20Enterprise%20versions%20%26nbsp%3Bthey%20mention%20%22Self-service%20Business%20Intelligence%22%20which%20is%20included%20into%20all%20of%20them%20but%20E1%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fen-US%2Fbusiness%2Fcompare-more-office-365-for-business-plans%3FlegRedir%3Dtrue%26amp%3BCorrelationId%3Dcd322a5e-7b9c-467b-96d7-16b8074b9dda%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fproducts.office.com%2Fen-US%2Fbusiness%2Fcompare-more-office-365-for-business-plans%3FlegRedir%3Dtrue%26amp%3BCorrelationId%3Dcd322a5e-7b9c-467b-96d7-16b8074b9dda%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22pmg-page-wrapper%20CSPvNext%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Wyn Hopkins
MVP

 

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 Pivot is much more significant and should be flagged as such.

 

It's a shame that we have to go to an external source like the PowerPivotPro webpage to get a clear view of what versions of Excel contain Power Pivot.   

 

https://www.powerpivotpro.com/2015/10/what-versions-of-office-2016-contain-power-pivot/

 

 

 

 

 

Excel Versions.PNG

9 Replies

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 

https://products.office.com/en-US/business/compare-more-office-365-for-business-plans?legRedir=true&...

 

 

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.

Solution

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

 

Hi Ashvini,

 

Great, thank you for publishing that. This question is one which people are asking for years, now we have straightforward info.

Ashvini,

What is not clear to me is if Power Pivots, prepared, for instance, in Excel 2016 Professional Plus, will (continue to) work in Excel Professional 2013 (that, apparently, does not contain Power Pivot).
Can yo ugive me some clarity on that?

Hi Bert,

 

I didn't test, but my understanding Microsoft tries to keep compatibility between all supported versions of Power Pivot. And that's why Power Pivot doesn't support some new functionality introduced for Power BI Desktop and SSAS Tabular. Perhaps they have 2 or 3 branches of the same Analysis Service engine for above 3 products.

 

However, just my guess, better if someone from MS clarifies.

Hi @Bert van der Meer,

 

My understanding is that all versions of Excel 2013 and 2016 should be able to view / interact with Pivot Tables and reports created using Power Pivot.

 

Having said that I've never actually tried it,  and would be interested to hear from anyone who has, especially if models containing DAX work well also.

 

Hi Wyn,

 

From my memory there was no backward compatibility between Power Pivot for 2013 and PowerPivot for 2010.

 

And as I remember when I shifted on 2016 with G&T and people around me still were on 2013 we had no compatibility issues. I mean files with data models analysing with DAX and Power Pivot tables.

 

Googled a bit, people here https://community.powerbi.com/t5/Integrations-with-Files-and/Excel-2016-Power-Pivot-Compatibility-to... confirm the same.