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".

532 votes

Sameer Bhide shared this idea · July 25, 2015 · Flag idea as inappropriate… · Admin →

completed ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · October 21, 2019

Hi folks,

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!

Vai
Excel Program Manager

Show previous admin responses (3)

started ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · May 22, 2018

Hi all,

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!

Ashvini Sharma
PM Manager
Excel

Accepting Votes ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · April 02, 2018

(Edit April 2: clarified 2D Map availability below)

Hi Sameer & all,

Thanks for your support for these features and for your passion in driving wider adoption of these. Wanted to take a minute to acknowledge the interest and provide some context on how we’re approaching this:
- Power Pivot: I hear you and am investigating what we can do.
- Power View: With the emergence of Power BI and the feedback we’ve received separately from customers, we’ve updated the roadmap for Power View, please see here: https://support.office.com/en-us/article/Roadmap-for-Power-View-in-Excel-c1f0d0f7-adef-4f03-ae35-46d83294e96b.
- Power Query: this is already available in all SKUs of Office Windows desktop. The only difference in higher SKUs are a few of the connectors as well as Data Catalog functionality.
- Power Map: since releasing Power Map, we received feedback that customers wanted to visualize their data using map charts and as such we’ve released 2D map charts available in all Office 365 SKUs. In order to make this User Voice item contained, those interested in 2D map availability, please open a separate UV item to track interest in that.

So am going to scope this request down to Power Pivot only. Let’s see what we can do.

Thank you once again
Ashvini Sharma
Lead Program Manager
Excel

Accepting Votes ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · March 24, 2018

Hi Sameer & all,

Thanks for your support for these features and for your passion in driving wider adoption of these. Wanted to take a minute to acknowledge the interest and provide some context on how we’re approaching this:
- Power Pivot: I hear you.
- Power View: With the emergence of Power BI and the feedback we’ve received separately from customers, we’ve updated the roadmap for Power View, please see here: https://support.office.com/en-us/article/Roadmap-for-Power-View-in-Excel-c1f0d0f7-adef-4f03-ae35-46d83294e96b.
- Power Query: this is already available in all SKUs of Office Windows desktop. The only difference in higher SKUs are a few of the connectors as well as Data Catalog functionality.
- Power Map: since releasing Power Map, we received feedback that customers wanted to visualize their data using map charts and as such we’ve released 2D map charts available in all SKUs.

So am going to scope this request down to Power Pivot only. Let’s see what we can do.

Thank you once again

Ashvini Sharma
Lead Program Manager
Excel

257 comments

An error occurred while saving the comment

GeneC commented · February 13, 2018 14:40 · Flag as inappropriate

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.

Submitting...
Daniel commented · February 13, 2018 08:24 · Flag as inappropriate

+1 "I am looking into other versions of spreadsheets and not renewing my subscription. Feeling so ripped off!"

Please google, kill ms office

Submitting...
Daniel commented · February 13, 2018 08:15 · Flag as inappropriate

Just suscribed to office 365 personal, no powerpivot, why god? why?

Submitting...
Pedro commented · February 01, 2018 15:01 · Flag as inappropriate

Why, Microsoft? Why?
It doesnt make sense at all.

Really disapointed...
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.

Submitting...
phong commented · January 22, 2018 01:23 · Flag as inappropriate

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 +.

Submitting...
Robert commented · January 20, 2018 03:07 · Flag as inappropriate

PowerPivot is an essential part of Excel and should always be included

Submitting...
Anonymous commented · January 18, 2018 07:03 · Flag as inappropriate

We need PowerPivot to be in all versions of Excel

Submitting...
Pauli S commented · January 17, 2018 10:40 · Flag as inappropriate

All Business versions at least should include PowerPivot.

Submitting...
Ivan commented · January 15, 2018 07:37 · Flag as inappropriate

Hi, making it available for all versions you will just make free advertisement and create a demand for "big customers"

Submitting...
Graham Coles commented · January 10, 2018 04:11 · Flag as inappropriate

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?

Submitting...
Carrie commented · January 05, 2018 16:57 · Flag as inappropriate

I am looking into other versions of spreadsheets and not renewing my subscription. Feeling so ripped off!

Submitting...
Carrie commented · January 05, 2018 16:54 · Flag as inappropriate

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.

Submitting...
Anonymous commented · December 31, 2017 10:57 · Flag as inappropriate

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

Submitting...
Helio commented · December 12, 2017 22:10 · Flag as inappropriate

Very disappointing - why on earth would you remove the power of PowerPivot from an updated version of Excel??

Submitting...
Anonymous commented · December 06, 2017 01:02 · Flag as inappropriate

Really having second thoughts about renewing my Office 365 subscription. What is the point if we do not even have features already present in previous versions!!

Submitting...
kcwilsonii commented · November 03, 2017 12:14 · Flag as inappropriate

D flowers.. Access is still in Office 365

Submitting...
D Flowers commented · November 03, 2017 12:07 · Flag as inappropriate

Access was completely dumped from Office 2016/365. That was bad enough. Now we want to cripple Excel by removing PowerPivot. I really don't understand the logic. We have subscribed Office starting with the 2013 version. It had everything we needed. Now, with 2016/365 MS starts taking things away. We had to purchase standalone copies of Access. I guess we will have to do the same with Excel. Very misleading when we are told that we purchased a "full featured" product.

Submitting...
Anonymous commented · October 31, 2017 07:09 · Flag as inappropriate

Very disappointing - why on earth would you remove the power of PowerPivot from an updated version of Excel??

Submitting...
Kathryn commented · October 18, 2017 19:06 · Flag as inappropriate

Could you include PowerPivot and analytics features with all subscriptions and products that include Excel? It's incredibly frustrating to suddenly realize you don't have the right version when you had no idea there would be a difference between Excel for ProPlus and Excel for Business Premium. I've now wasted about 2 hours of time (both mine and various support personnel), and even customer support didn't understand - they kept telling me I needed Excel 2016. Umm.. I have that. Just not the right one, apparently. Is restricting this add-in really benefiting the bottom line enough to justify the confusion?

Submitting...
kcwilsonii commented · October 17, 2017 21:49 · Flag as inappropriate

I had to download SQL Server Developer to load data.. just stupid

Submitting...