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
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.
Giving people the option to learn these features on their home PCs will help drive adoption in the workplace. Fragmenting versions of Excel like this is short-sighted penny pinching.
The problem with having different functionality in various versions of the application is Microsoft is assuming that we only use our work computers. I personally have better equipment at home than the company has provided. I'm the only person in my office which has been using or implementing the Power BI features of Excel. I was able to accomplish this because I was able to use and play with it on my home computer before I installed it on my work computer.
Microsoft producing different builds of the same software is exactly what scares the hell out of our IT department from installing upgrades until absolutely necessary. On top of that about half of the people working for our company work from home on their own computers. Our company employees a number of consultant that use Office 365 Home, which means that none of them are able to work on the models that I build at work. That now includes me!!! Thankfully I still have another older computer with Office 2010 on it, which is what we're using at work. Hopefully we just stay with that and don't upgrade in the next few years.
Pamela Nathe commented
This has been totally frustrating to me. I have a standalone version of Office 2013 Professional which has the PowerPivot. However, now that I "upgraded" to Office 365 2016 Home subscription, I have lost this functionality. Furthermore, I cannot run Office 2013 and Office 2016 on the same computer. I would get rid of the subscription, but I do need certain functions in PowerPoint that are not available in 2013. I don't know why MS decided in their "wisdom" to remove the PowerPivot and PowerQuery from the home version. I am a computer trainer and I totally resent having to buy a standalone version of Excel when I already have a standalone version that I can't run. This is ridiculous.
Ron MVP commented
In last graphic you say "Higher enterprise plans". too vague. Explicitly state E3 and E5, NOT E1!
But the whole point of creating the Office bundle since 1991 was to expose people to features and applications they would not normally pay for. So someone would have only bought WordPefect (which had 97% of the market before Office) bought Office and got excel and powerpoint. Before Office there were "levels", ie "Standard" and "Pro", all that was leveled out. Now you are bringing back the bad old days of the 1980s marketing. Where and when do you think people learn new features like PowerPivot? At home and in school. But those 2 groups no longer have access to BI.
Come on, get your head out of your a...natomy, get back to the real world.
Since I'm ranting about Office, why are Visio and Project not included in ANY Office bundle? Same idea, make them available t people who don't normally have access to them so they can play with them and learn to become dependent on them!