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!
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
Just suscribed to office 365 personal, no powerpivot, why god? why?
Why, Microsoft? Why?
It doesnt make sense at all.
Good that Qlik Sense Desktop is free, and I can use that at home to replace the part I would use Power Pivot.
As a BI professional, learning a different BI language just for my personal stuff is a pain, but would be good for the long run.
I absolutely agree that 299$ of Office 2016 home and business should include Power Pivot, View and Map. If not, I should not buy this at the first place. Since in Thailand stores, they do not sale 2016 Professional +.
PowerPivot is an essential part of Excel and should always be included
We need PowerPivot to be in all versions of Excel
Pauli S commented
All Business versions at least should include PowerPivot.
Hi, making it available for all versions you will just make free advertisement and create a demand for "big customers"
Graham Coles commented
After three hours of valiant effort, MS Tech Support just managed to downgrade me from Office 365 home and resurrect my 2013 Office Home installation and my Excel 2013 stand-alone version purchased solely to use Power Pivot back then. Fortunate that I purchased everything legitimately and online. Thank-you Tech Support, the problem does not lie with you!
I have just completed a project with a major US Multinational which allowed me to introduce PP to an international team of users who had never heard of the product. It was life-changing for many of these career Excel users who were buried in @Vlookups and @SumIfs, and could not begin to imagine that spreadsheets could handle multiple millions of rows of data in mere seconds.
The sad part was that no one had time to learn anything new as the company was totally lost in maintaining broken models and manually moving data from model to model. They didn't need Excel 2016, they didn't even need Excel 2010 as the skill levels were that low.
Dear Microsoft - we all want you to succeed with Power Pivot - but how will anyone learn this if in the office there is no time and at home or university there is no access? Isn't that at the core of why this product has failed to take off since the intro in 2010? Isn't that why you, sadly, can hardly even give it away in the form of Power BI Desktop?
I'm a believer. I've been in spreadsheets and macros for over 30 years - yes even Lotus 123 and the short-lived Lotus 123 R3. I have never seen anything which comes close to this functionality in the way it delivers on the promise of self-service BI, but unless you change the thinking in Marketing it will continue to fail. Please dont let it fail.
Come June 2018, I will dutifully line up with the millions to buy Excel 2019. Apparently I will also be buying Office 2019 Home as rumours have it that it will again only be possible to install a stand alone Excel 2019 on top of the Office 2019 Home release. I don't like it, I think you can do better, I think you have to do better for current and future users of Office. I know - I can buy the Office 365 ProPlus, but this is a very expensive option as a learning platform or for my daughter to use for her primary school homework. I would love to continue my subscription to Office 365 Home, but it is becoming ever harder to justify the 'convenience' of this platform.
Like the banks in 2008... Office is too big to fail...or is it?
I am looking into other versions of spreadsheets and not renewing my subscription. Feeling so ripped off!
No Power Pivot in 365 Home? Not cool MS. Not cool. I'm not going to pay extra for the upgrade, BUT I just might learn to settle for Apple's Numbers or Google's sheets. At least they're free! You know, consumers get awfully tired of feeling ripped off.
I am really angry that the features I need to learn to hold a job are not available with my version of Excel. Powerpivot, PowerQuery are much needed tools. I cannot afford to buy another version of Excel exclusively. You all should be ashamed of yourselves