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!
Douglas Campbell commented
Ridiculous. Some should start class-action suit on this. False advertisement.
Nguyen Le Minh Tu commented
I can't believe I paid $99.99 to have a Microsoft Excel that doesn't have the Pivot function. I don't know why the developers thinks that only "business customers" should have it, not home users or students. I'm a college student and have been relied on Pivot almost on every worksheet. What the point of having multiple pages but you can't analyze them anyway.
To make the problem worst, I thought it was a technical issue at first because I've been using it since I purchased the code, only till I installed the new updated that did Microsoft decide to remove the add-in. I called the customer service, and they told me to either pay $499 for technical support or go to the community and search for the solution. The point is no one, not a single agent, told me that the pivot add-in is removed from excel for home users.
You know what. This is shady business. This is not how a big corporation should operate! I purchased the Office 365 knowing that I will get the full version of everything. This wasn't on the description, there was and is still no line on the website saying that "FYI, Pivot function isn't available." If I were to know that Pivot function wouldn't be available, I wouldn't have had purchased Office 365 since I would have a much better deal using other free office software, like Google Sheets, Google Docs, or anything as of sort.
I feel like I'm cheated. Really, Microsoft, this is a bad customer service and a bad way to do business.
I'm very disappointed!!
I am trying to find a version of Excel to convert to that includes Power Pivot and I will read the data on the box and there is no mention of Power Pivot. Users on forums have said they have tried to upgrade, thinking they are getting PPvt, and they do not get it. This has been a very difficult process but you need to market this better with easier help to download and explain what versions of Excel contain it and what don't, how to upgrade, etc. The downloadable version you see often on Google is for Excel 2010 and I have 2016 but it is the online subscription version of Office 365 Personal. I guess I'm going to have to buy the standalong version.
What a shame!
I just purchased the home premium version of office 365 and I Can't use powerpivot!
That's not fair.
Microsoft, you have successfully gotten me to spend well over $200 for your new product, and then left out Power Pivot, driving me literally insane. I will now spend hours trying to get a refund, I will build a backup disc of my 2010 Excel and Word, and have those installed onto my new machine. I feel cheated and misled by your decision to not include Power Pivot in most versions of your excel, and extremely disappointed there is no add-in option.
this idea has already been suggested here: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9018823-make-the-power-bi-family-powerpivot-powerquery
Although despite the votes the Excel Team do not appear to have acknowledged it's existence - add your votes to that idea as well so that hopefully this movement gains some traction
Many of us would use power pivot if we could practice and learn on our home computers with our office licenses. It seems strange to me to block home users from features like this. I can't imagine that microsoft would sacrifice much revenue to open this up to users on their home machines.
Holding back functionality like this makes Microsoft seem very small. The additional revenues created by segmenting the market so narrowly would seem to me not to be nearly worth the ill will generated. If I buy Excel -- in any package -- it should be the full version.
Richard phaneuf commented
I do not enjoy the dumbing down of different versions of office. Over the years I have bought the dos, the win 3.1, of office 6, office 97, office 2000, office 2003, , 2010, 2013, & 2016. Now that I am retired I have to pay the full price to do volunteer work with excel. i
carlos silva commented
Make this happen please! People want to learn how to use this tool!
make this happen - this is a key element to train and retain a large userbase in the world of larger data sets.
Very disappointed that the Full EXCEL experinace has been diluted
Make this happen Microsoft. At least train your people to try to take my money, I was trying to give it and they wouldn't tell me how. If anything, PowerPivot (or BI pack) should be available for purchase as an add-in, in the MS store, for all of us who made the mistake of buying Home.
I read the forums, I knew I had unknowingly purchased the wrong 365 version. Figuring an upgrade was doable and I needed to pay, I chatted online with Jelly B. in the billing department who sent me a link to download the 2010 PowerPivot add-in. When I told her a second time I had 2016, she connected me with the tech support department. Arvi M. in tech support remoted in and checked my version after, I told him I had 2016 Home, and he still tried to install the 2010 add-in....then told me I had to call the "professional people". When I called the "professional people", they told me I have Home and they can't help me. They then told me I have to "call the 'Enterprise people' but they aren't open right now." The funnies part is I told them all that "I have Home and I want to pay for PowerPivot. What are my options?" Not a single one of them provided me options to upgrade. I refuse to buy Excel standalone when I already have 365.
I have just spent nearly 3 hours on the phone & chat with MS, and had conversations with at least a dozen people trying to change from 365 personal to 365 pro plus. I think of everyone I spoke to (in many countries) I was the only one that had ever heard of powerpivot. It seemed no one had a clue as to what version included powerpivot (thankfully I did). I was referred to technical when I had no technical issue ... Complete waste of time, when I would have happily done the upgrade myself online albeit you can't. Then I was told there was a special price, and then you had to sign up for a year to get it, and then that there was no special price ... As a minimum your name, email and phone should be transferred to the next person every time you are ...
Misleading consumers is really a miserable trick to cull customers. The promise of a full version was certainly a misleading claim. I also switched from a standalone version of Office 2013 to O365 where PowerPivot was magically omitted.
Please include PowerPivot in next O365 release again - at least all the disappointed consumers will not have reason to call Microsoft a liar anymore.
At the very least, give DAX and the relationship manager back so that the internal table relationships are useful.
Currently, table relationships are nearly worthless. "Replaces VLOOKUP" it does not.
Simon Lockington commented
Please put this back into this version.
Is that functionality so heavy and complicated to maintain that it is removed from a lot of Excel versions? Even ones which bear the word “business” in their title? We have Office 365 Business, and expected ALL features to be included in this "NEW" build. This is simply ridiculous. Strange marketing strategy to promote a “new” technology (and yes – for a lot of users this is still new) by making it available only to some selected few....
I replaced a fully-paid-for standalone version of Office 2013 Professional which has PowerPivot, with O365 after reading that "FULL" version of all applications were included. And then I find taht PowerPivot is not included.
You lied to me. Please restore POwer Pivot to O365 or modify the language on the O365 site to replace "FULL" with "selectively gutted" versions of Office Applications. Thanks.
Office365 is sold as up to date and fully installed Office applications with the current version of Office being Office2016. If i install a standalone copy of Office2016 that it includes Excel2016 which, I am told (Office365 twitter team), comes with PowerPivot. Having been sold Office365 (O365 Home in my case) on the proviso that it includes fully installed Office2016 apps i consider the lack of PowerPivot in my subscription to be false advertisement
Having PowerPivot available to me through an O365 Home subscription would have allowed me to investigate its potential for our particular work flow and qualify its subscription fee. Keeping it behind an elevated pay wall stops people from seeing what they are missing
We recently were forced to migrate (i.e. downgrade) from the deprecated Office 365 Midsize Business to Business Premium which removed the PowerPivot functionality in Excel. This is an extremely frustrating and unwelcomed move from MS as many of our users relied on this feature for analytics.
Now we are left with the choice of either paying almost double for the more expensive E3 subscription or finding workarounds to get the data to our users.
Please give 'Business' users at least the possibility to add Powerpivot as an add-in.