Make Power Pivot available in all versions of Excel
Previous title: "Make the Power BI Family - PowerPIvot + PowerQuery + PowerView and PowerMap available in all versions of Excel".
We’re happy to report that Power Pivot is now in all current Windows editions of Excel, including Office 2019 (perpetual) and Office 365 (subscription).
In older versions of Excel (Excel 2013, Excel 2016) only certain Windows editions (Pro Plus and higher) include Power Pivot.
Thanks for helping us to make this a reality!
Excel Program Manager
Office365 with PowerPivot;
Office 365 ProPlus
Office 365 E3, E4 & E5
Office 365 Home
Office 365 Personal
Office 365 Business Essentials
Office 365 Business
Office 365 Business Premium
Office 365 Enterprise E1
Tom Bex commented
@ David, I'm using the Office 365 Home premium version for 5 pc's. But in my versions of 2010 or 2013 it did work but with the upgrade to 2016 it is canceled.
David Aldred commented
@Tom Bex, which version of o365 are you using? I was under the impression that all business plans (inc ProPlus) included the relevant tools.
(see: Self-service Business Intelligence)
It should only be the Home/Personal editions (which aren't licensed for Business Use) which exclude it.
Tom Bex commented
As an employee in a small company that works with big investment data for pension funds or insurance companies I would like to works with the newest versions of BI products that Excel offers. But in my 365 version this is not included. But I thought that in this 365 version i could work with a complete version of Excel. This was obvious a misleading information in my purchase of Office 365. Please include the BI tools to all Office 365 versions.
How many people here have written a comment without VOTING for the idea!
I use excel VS competing products to get extra features and now discover that do not have access to powerpivot. this is a downgrade that is completely unexpected. Very frustrating. I will recommend everyone to steer clear of your "upgraded" subscription products ....
Cliff Brown commented
I'll add my name to the list. Very deceptive that your advertising does not indicate that they're are different "flavors" of excel. I was working though a Microsoft produced course on Data Analysis (edx.com), and decided to "upgrade" from 2010. The course also makes no mention that some versions of 2016 won't work, In fact they imply any version of 2016 will work.
Suresh Reddy commented
Please add power pivot in Office 365 Subscription. Highly disappointed with subscription as nothing was mentioned about power pivot feature in office 365 personal subscription.
Carlos Villoria commented
PLEASE make PowerPivot available for O365 Home edition! It is such a useful tool, even for us small guys that can't afford SQL services. I had it in Excel 2010 and now since I "upgraded" (now questioning that decision) to 2016 I no longer do... Yes I copy this message from Mr. John Shield`s post. This is exactly my opinion.....Please, we need Power Pivot...
Jon Shields commented
PLEASE make PowerPivot available for O365 Home edition! It is such a useful tool, even for us small guys that can't afford SQL services. I had it in Excel 2010 and now since I "upgraded" (now questioning that decision) to 2016 I no longer do. NOWHERE was this disclosed! SHAME ON YOU MICROSOFT, I thought you were better than playing greedy childish games like that!
John Hinze commented
Please add PowerPivot functionality to the O365 Home subscription. PP is an awesome tool but only accessible to a niche audience starting with Excel 2016. Thanks
Giuseppe Nicolella commented
please add power pivot to the excel 365 version, it is included in 2010 and not in 2016???
Peter Ballantyne. commented
I spent a long time looking at the pros and cons of an Office 365 Home subscription vs a standalone. Never did i see any reference to this being omitted from the subscription i purchased. Even now, knowing that its not included, it is still not obvious from your sales materials that PowerPivot is not included as part of the O365 Home package.,
I am perhaps one of Microsoft's biggest fans, i'm even doing Microsoft's Data Science course, but this blatent hiding of product information is testing even my trust.
yes, make power pivot available for all office 365
David Aldred commented
If you're already on o365 for Business subscription, it's a case of moving to an appropriate plan. I'm on E3, and this includes everything needed.
They list the 'feature' as 'Self-service Business Intelligence in Excel'
My small business needs Power Pivot quickly. We upgraded to Office 365 and now miss a valued tool. How can we get it??
Mohammed Hossain commented
Please add Power Pivot in Office 365 subscription. I am doing a data analysis course conducted by MS where Power Pivot is required. I am unable to know the features of Power Pivot and hence complete the course with full knowledge. What a disappointment!!!
Dave M. commented
I feel scammed too. It is very dangerous to the future of the brand to start fragmenting your user base the way you guys have started doing. There should only be one version of subscription Office 365, and it should offer the exact same functionality as the stand alone version as well. You guys are running the risk of users not being able to send and share files with full functionality between each other, and that just makes an otherwise wonderful software feel really... blah! A step backwards for sure! It is the opposite of collaborative.
I use my personal PC to try out MS Excel tools because our company does something to the company PC image to block all Excel addins. I then try to advocate to the IT department to allow us to use these add ins. I started with Solver and was about to move on to PowerPivot after reading about it. But I can't try PowerPivot on my PC!!! and I bought a stand alone version!! Common on man!
John May commented
I am extremely disappointed that Power Pivot is not available in my Office 365 subscription. Knowing this would have influenced by purchase of Office 365. The advertising certainly does not say that the purchaser is getting a scaled down product.