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
It is inconceivable to provide this feature in the earlier version of Excel just to completely eliminate the compatibility for the later version. This is extremely crippling to the business after building a data analysis tools around this feature. Please consider bringing this back immediately to Office 365 Home.
Raymond Wong commented
My understanding is that Powerbi desktop (free) share the same data engine as the PowerPivot in Excel. Yet, PowerPivot is not available in all version of Excel. After upgrading from Office 2010 to Office 2016 Business, Excel lost PowerPivot completely.
Powerbi desktop is great but cannot create data solution/analysis like PowerPivot in Excel. This is because I can feed the data from Powerpivot to another worksheet for further calculation. I also mention this aspect in Powerbi forum. I do not understand MS decisions. There are way more users of Excel. If MS want more people to adopt Powerbi ecosystem, let them have powerpivot in Excel. This will allow any data analyst to learn how powerful the data engine is. They will want Powerbi for sharing data across the organization. Yet MS decided to limit access to an upsell version of Excel and block a large community of Excel User to dip their toes in the data engine.
I found out about Powerpivot because I needed a solution to carouse a data and Excel files when I was using 2010. Company upgraded to 2016 business and lost PowerPivot. I am limping along with Powerbi desktop and Powerbi Pro service but not the most satisfactory solution because once your data is in Powerbi desktop you cannot get them back in Excel without manual export from the grid widgets. The other way is to upload the data into the cloud and bring in back to Excel with the “Analyze in Excel” - doing the data round trip. If you do not have internet access, you are doomed. Powerbi Desktop IS not Excel and will not replace Excel. - end my rant.
Eric Engel commented
I started using PowerPivot at work and wanted to improve my skills at home, until I just found out that the Office 365 Home edition of Excel does not include it! Apparently it is not available as an add-in anymore either. Makes no sense. MS wants you to use these advanced tools so they become a standard (and integrate with SQL Server of course), but they limit them to just users who have Office Professional. Certainly one way to limit acceptance!
I have Home and Business 2016 and Office 365. I guess I have to buy another suite for PowerPivot? Please add this back for those of us that have been using it for almost a decade now. Why take it away from us?
Like other users below, I moved to the Office 365 subscription only to lose functionality. Without the Power functions, excel is Power-less.
Jesse J Burgen commented
Just add it back in, if I can find an alternative product that allows me to reproduce the results I need, well, you lose another customer
Charles Davis commented
PowerPivot should be in ALL versions of Excel after its original introduction. We are using it and expect it to be available as we upgrade. Upgrades should provide additional features, not a reduction in capability. Luckily I stumbled on this before I upgraded.
Ha sido realmente decepcionante actualizarme a Office 365 y ver que hay opciones a las que antes podía acceder y ahora no.
I have been taking Harvard online courses on Excel. To my surprise my office 365 subscription does not have Power Pivot. WHY? It doesn't make any sense. its in 2010. I am forced to use an old version of excel that provides this capability and thus cancel my subscription to office 365.
Rick Frazier commented
A while back I updated my Office 365 to a more expensive Office 365 Business Premium and lost Powerpivot in Excel by surprise. Bad customer satisfaction move Microsoft. Now I hear I must move to E3 at substantial extra cost to get it. Only need Powerpivot, not rest of E3. Please rebundle Powerpivot in Business Premium or offer a low cost Powerpivot O365 module addon.
Rick Piekos commented
Please add it back
Simple, how much does it cost additional to get it from the home version and how do i, a home user get it. Not impressed with this.
I just bought excel 2016 / Office 365 personnel a few hours ago. My first action was to install powerpivot. I am very disappointed to learn that Power pivot is not available for this version of office. It is ridiculous.... Don't forget the first ambassadors are the consumers. Please reintroduce Powerpivot to office 365 for all versions. Hoping an answer from your part.
Add PowerPivot to Office again - even in case one would think about upgrading it is ridiculous time intensive to find what needs to be done.
With a name like "Office 365" you would think i'm paying for software that can handle my "office" needs 365 days a year, but this is not true... please re-introduce PowerPivot to Office 365. When our company was persuaded by microsoft to join a subscription based product, we were promised we would benefit b/c we would have access to all of the same great features we were used to while being kept up-to-date with new features and bug fixes. We already pay for google apps as well as filemaker pro.. without PowerPivot, we don't have a need for "office365" please return this feature or we'll be making a software change next quarter.
Add PowerPivot to all Excel versions. It's advertised all over the place, but it took me ages to find out that it is not available in my 365 subscription. Your web site has contradictory links. This is a pretty basic use of Excel, and it should be included in all Excel versions.
Please add PowerPivot to Office 365
It should be added to all versions of 365
MSFT did promise a response to this topic some 6 weeks ago;
David Aldred commented
I can sort of understand them not including it in home / personal (but disagree with it), but to not include it in Business or Business Premium is just crazy.
(For those wondering; Business Essentials & E1 don't have Excel anyway)
MSFT really need to consolidate some of these plans and bring clarity to what is / isn't included - and that goes beyond Excel/PowerPivot (eg, I'm on E3 for personal use, yet don't have the new Visio Web Access)