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!
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?
If map chart is only available in 365, please admit it. And please CORRECT THIS MARKETING STRATEGY! Why do you say "available in all SKUs"? So Office Professional Plus 2016 is not an SKU????????????
2D map chart is NOT AVAILABLE IN Office Professional Plus 2016 latest Version as of 3/25/2018 (Version 1802 Build 9029.2253 Click-toRun)! WHYYYYYYY?
Craig Calvert commented
Long enough to know they don't care to fix it
This thread has been going on for ...... 1 year? 2 years. How long?
Pamela Nathe commented
Hello Ashvini, and thank you for your thoughts. I am particularly frustrated by not being able to access PowerPivot especially since I already have a version of this feature in Office 2013 which I cannot run with Office 365 as they are not compatible. Since there are features in Office 365 which I like which are not in Office 2013 I have decided to do without PowerPivot, but frankly I just feel gypped.
Please add powerpivot and related tools to ALL office365 versions of Excel; trying to come up with a plan that supports Excel with powerpivot but also something like Teams... is quite complex and unncessarily difficult and expensive.
I remember years ago, I was privileged to Beta test Office 2010, and the add-in, Project Gemini, the precursor to PowerPivot. I used it all the time at home until I could get it installed at work. Now you take it out of Excel 2016 (Office 365 Home) to promote Power BI!? WTF?! I don't use Powerpivot, a known staple of Excel at home much, but I just renewed my Office 365 account and for this reason alone, I'm thinking of dropping Office 365 altogether and converting back to Excel 2013. Really Microsoft, you BUILT Powerpivot for Excel and now rip it out? I do NOT NEED/REQUIRE a locked product of Power BI. I NEED Powerpivot. Bring it back or lose my subscription.
When people buy a subscription to Office 365 Home edition, the Microsoft web page clearly states: Fully installed Office applications
Always have the latest, fully installed versions of Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access and capture your ideas however you work best—using a keyboard, pen, or touchscreen.
FULLY INSTALLED MEANS POWERPIVOT IS SUPPOSED TO BE INCLUDED IN THE HOME (AND EVERY OTHER SUBSCRIPTION MODEL).
WE DEMAND THAT MICROSOFT PROVIDE POWERPIVOT FEATURES IN ALL SUBSCRIPTIONS IMMEDIATELY!
MICROSOFT IS COMMITTING FRAUD AND DECEPTIVE ADVERTISING, ALL OF WHICH SHOULD BE INVESTIGATED BY THE DOJ IF THE COMPANY FAILS TO DELIVER THE PROMISED FULLY INSTALLED VERSIONS OF ALL APPS.
Please add PowerPivot and the related BI features available to ALL VERSIONS OF EXCEL 2016 and later. It is blatant and misleading advertising that states that when we sign up for Office 365 we are getting ALL OF THE FEATURES in EXCEL.
Dear Microsoft. I am one of your champions. I spend my day teaching your products (especially Excel) in a corporate environment. I get people aware and jazzed about PowerPivot. Many of these people want/need to take work home and be productive. They are very surprised and distraught to find out that they can't use the PowerPivot features on their home version. This is a reality for hundreds of thousands of people. The fact that I had it for free with 2010 and lost it by upgrading is ridiculous. Please stop making bad decisions that infuriate your users and teachers.
What's really infuriating is that I had it for years for free with 2010 as a free add-on. To upgrade to 365 and now not have access to it is ridiculous.
While the user interface is different, the Excel 2016 subscription includes under Data-tab in the "Get & Transform Data" and the "Queries and Connections" section most of the capabilities. Check it out.
+1 "I am looking into other versions of spreadsheets and not renewing my subscription. Feeling so ripped off!"
Please google, kill ms office