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
Please consider adding the Power Pivot into the Office 365 Home Premium Subscription.
I upgraded from office 2010 and realised too late that I could no longer access the models I built in 2010.
Perhaps limiting the size of the models would be a better compromise on the home subscriptions as opposed to removing the feature entirely.
I agree that taking features away from 2013 to Office 365 is not a good move. I was one phone with MS for 3 hours before they figured out that my subscription to 365 did not include powerpivot.
So my job is data analysis and occasionally I work from home testing and using power pivot ... That is until Microsoft decided to not have it available in Office 365 or 2013!!!!! WTF!
Standard in 2010, but not tell your customers what they need to do to receive the added functionality ... Gooood calllll .....
I have Office 365 Home and was looking forward to training myself up on Power Pivot only to find that it is not included
How disappointing and extremely frustrating. Microsoft get into the real world - at the very least look after your customers and let them know what versions it is including in by clearly stating it on your website.
There is no excuse to include PowerPivot and all BI tools available in ALL VERSIONS OF OFFICE 365. Every reference Microsoft makes about PowerPivot indicates that IT IS AVAILABLE to ALL USERS, but apparently that is still not true?
Ajit Singh commented
I have "Office 365 Business Essentials" license. It would be really helpful if you can provide PowerPivot in all editions of office 356 as we need to consume some third party applications developed using PowerPivot and we ourselves are not expert in PowerPivot.
Please add PowerPivot back to Excel. It's vital to analists. You know we are not only working on public computers in company, and such a fundamental function as PowerPivot should not be a prremium for higher price.
For me, I just got an email from Microsoft to invite me to study Excel 10 Tricks. However I cannot even finish your course with my Office 365 subscription! It is ridiculous.
I sincerely hope that PowerPivot can be added back to Excel.
These should be available in any version of Office 365 subscription
Randal McDonald commented
Please!!!! All my work spreadsheets have power pivot components.
Please add to 2016 Office 365 Home (personal). None of the dozens of people I spoke with ever mentioned and now can't believe it is not in 365 Home.
Got Office365 to replace Excel 2010, and much to my surprise I can no longer use PowerPivot. Worth noting that PowerPivot was a free add-in for Excel 2010.
For an average person it is virtually impossible to understand what the differences are between the different versions of Excel. Objectively viewed, it is as clear as mud.
Incredibly poor strategy from Microsoft, making it very hard for someone like me to embrace new technologies.
In order to get into the same position that I was when I had Office 2010, it seems that I now have to buy a stand-alone Excel 2016 (in addition to the Office 365 subscription that I am paying for on an annual basis), or subscribe to a complete Business subscription incorporating numerous features I have absolute no use for. An add-in that used to be free is therefore the equivalent of a new Excel license. It does not take a genius to figure out that it does not add up.
I am definitely not alone in having this view. Bitterly disappointed in the lack of transparency around the whole PowerPivot issue. Are you actively trying to get people to embrace the concept or you trying to make it difficult for them? If you want people to use it, make it freely available, as it used to be, or provide it at a reasonable charge as an option. To avoid any misunderstandings, a reasonable charge does not mean the cost of a new Excel license.
Just "upgraded" to Office 365, opened excel to add-in Power Pivot only to find it is not available on this version of excel. Guess I'll be "upgrading" back to my purchased copy of Office Pro Plus 2013. Please include Power Pivot in all versions of Excel!
So annoying that this is not Included in the office 365 home version
just got office 365. lost all my work in powerPivot. disapointed and angry. going back to excel 2013 and ner get office 365 again!
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.