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".
I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.
We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.
Thank you for pushing for this!
Ed Hansberry commented
For those questioning the Insider track, you don't have to do that. LIke all features, MS is apparently rolling this out to Fast Insider first, then will move to Slow Insider when a bit more stable, then to normals when fully tested.
If you want it right now, then yes, you need to get Fast Insider, but understand you are getting a beta version of ALL of the office apps and there are bugs that may impact you. MS doesn't recommend using Fast Insider on production machines.
Ed Hansberry commented
@mark - Office 365 for home is not licensed for commercial use. If your clients are individuals that just pay you to help with their PC needs, that is fine (though seems odd that kind of person would care about Power Pivot), but if your ciients are small businesses, they need to have an Office 365 business license, not home.
Mark Skilling commented
That's great news, but I can't find any confirmation of this on any Microsoft website.
Is it actually going to be available in the office 365 home official release?
I want to use it for my clients and can't use it unless I can be sure everyone can get it.
Can somebody from Microsoft please confirm what is officially happening?
No, opt in Office Insider Program : from any Office app, go to File -> Account -> Office Insider, check "Get early access to new releases of Office" box, and the update will download ...
so, opt into windows insider program you mean?
In effect Power Pivot is now available in home edition under the insider program! Yippee!
Thanks Microsoft for listening and thanks "anonymous" below for informing us!
Power Pivot is available in Home Edition for 2 weeks now, opt in for the insider program and there you go ;-)
Thank you MS !
Please make this a standard feature for all versions. While many analysts may use this feature in office, many students use their home edition to practice their skills.
Add it now!
Dear Ashvini, good to see someone from Microsoft responding to our comments.
I agree Power Pivot should be included in the business line but please also give the possibility for those with home version to at least add it to their subscription. Students and also adults following data analysis or business analysis courses or any other course related to analysis need this option.
It boggles the mind that such an important business analytics tool so many of us have come to depend on was left out of the *Business* line of products. Our only options are downgrade to Pro Plus, or pay twice as much for Enterprise just for PowerPivot. Neither is a viable option but most of my clients that are small business owners have chosen to downgrade.
Given away as a free add-on for years and now ripped away unless you pay out the nose for it, or for some reason beyond comprehension, *downgrade*. Seriously. Mind boggling.
This is annoying. I use E3 at the office and am eligible to use on a second computer but I bought Office 365 Home edition for my family thinking I would have have same Office features. I already have a G-Suite license so I didn't need to do the O365 upgrade because it's only me who uses Excel to this level. So much for brand loyalty. I have just started a business and had costed in an O365 Business plan to replace G-Suite but now I'm not so sure because I don't know what the "fine print" will be on that. You should at the least offer these add-ins as a subscription addition so people can level up.
Lejdio Kaceli commented
It feels frustrating not being able to use Power Pivot feature on Excel 2016
Mark Skilling commented
I have been starting to recommend the use of power pivot to clients only to find that only some versions of excel 2016 have this feature. When working with small businesses this is a ridiculous situation. ALL versions of excel should have power pivot available so that we can actually increase the usage of this very useful feature.
David Morgan commented
I bought Office 365 Home, and one of the main reasons I'm using office and not one of the competitor products for home use, such as google sheets, is so that I can improve my office knowledge on my own time. I'm taking a class on PowerQuery and PowerPivot and about half way through the class when we start using power pivot I don't see "Manage Data Model" button. Extremely frustrating going through page after page of suggestions, only to eventually find out its just not included in my version of Excel. This really needs to be here, or an option to download install it. Have to imagine students with Office 365 Student or Education, which may be learning excel have this same frustration!
Hope, PowerPivot will be available in all Excel versions. Thank you in advance
Thank god I didn't buy office 365 before reading this. I hope you add Power Pivot to all versions asap, otherwise I won't "upgrade" from excel 2010.
Raymond Wong commented
The power bi data engine/model is already available in Excel 2016 Office365 and you can connect when creating a PivotTable using "external data source".
However, it feel like MS deliberately CRIPPLE the functionality by removing the PowerPivot menu and other feature to manage data engine/model.
I understand MS push to PowerBI desktop. There are a few key major reasons to use Excel instead of powerbi desktop.
1. Power bi desktop does not have ANY print function. I have to send the data out to the Powerbi cloud/Service in order to print any reports from powerbi desktop. Why?
2. In powerbi desktop, I cannot create a report table by combining bespoke data points such as impression, visits, transactions by same date and some business category in power bi.
In Excel, I can look up each metric from different worksheets or workbooks and combine them into a single table template for managers. The ability to combine bespoke data points is a major advantage that Excel has over other BI reporting tools.
Mimoune Djouallah commented
I have paid for office 2013, and i am happy with it, I love to pay for office365 home, but as long as PowerPivot is not included, I will not upgrade, one lost customer and I suspect I am not alone.
Why are you giving your business away? Myself and many colleagues are being driven away from Microsoft BY MICROSOFT. We MUST try Tableau, Google sheets, etc. You wont even give us a sign-on to Power BI. Even if map charts were available in Excel 2016, they evidently do not include a map base layer (roads cities etc), so you are laying down and letting Google Fusion Maps beat you?