Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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

506 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sameer Bhide shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded  · 

    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

    255 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Mike McCaffrey commented  ·   ·  Flag as inappropriate

        I guess I am not the only one that feels scammed - I bought an Office 365 package that included Excel, but now I know that there is more than 1 flavor of Excel. I imagine this was hidden in the fine print somewhere. Yet another reason to be annoyed with Microsoft.

      • Keith Johnson commented  ·   ·  Flag as inappropriate

        I had standalone office and now that I paid even more, I don't have the tools I once did. Bad idea, MSFT....and I'm a shareholder!!!!

      • Victor commented  ·   ·  Flag as inappropriate

        I am probably what most people would call a Mac user. I have not been using windows for several years. Not even at work. Unfortunatly, I read that the PowerPivot functions is missing in the Excel version for Mac. Therefore, I bought a pre-used PC and then I purchased Microsoft Office 365 Home. Offcourse, I paid for a year of usage.

        I looked forward to get startet with all of the data analysis tools which I thought was included in the office product that I just had bought. Talk about a hugh dissapointment, specially when I realized that theese tools are missing in the Office 365 home edition. I had literaly spent hours trying to fix the COM-add on for PowerPivot. And as many of you already mentioned, I feel cheated. At least, you could mention something, somewhere that theese tools are missing.

      • James Allen commented  ·   ·  Flag as inappropriate

        This is beyond frustrating. How am I supposed to complete the MS Data Science Program on my own time without this?

      • Raphael Queiroz commented  ·   ·  Flag as inappropriate

        How sad I was when I discovery that Power Pivot don't Belongs to Office 365. If it persist, I do not renew my 5 accounts of my company.

      • John Redberg commented  ·   ·  Flag as inappropriate

        This is the most ridiculous product planning I've seen in a long time, and moreover blatant false advertising.
        After spending HOURS trying to enable these features in my 365 Home version, I landed here. And I still don't know what version I would have to buy if I wanted to.
        It is advertised countless times all over Microsoft's websites that the 365 subscriptions include "Fully installed Office applications". How does Microsoft define the word "full" ?!

      • me commented  ·   ·  Flag as inappropriate

        So after Microsoft decides to downgrade excel (their choice and their right) - they miss lead consumers on their page by saying that "Office is fully installed" and that it has all features - but as we know it doesn't. They have ignored all requests to provide a product as advertised on their website --- I think now is a good time for a class action law suite for misrepresentation of their product.

      • James commented  ·   ·  Flag as inappropriate

        Wow, still going.
        I got my money back for my 2016 Office purchase.
        They tout power pivot, then you come home hundreds of dollars poorer, and find out you don't have it.
        MSFT: when you 'upgrade' something, you don't remove a free app. Doing so is actually called a 'downgrade'.

      • Kirk Phillips commented  ·   ·  Flag as inappropriate

        Microsoft - please make BI tools readily available in Office 365 subscriptions! Developers and end users need to get their hands on and become comfortable with these tools so they become the "go to" choice over competitor BI offerings. Make these BI tools as ubiquitous as Excel itself.

      • Tim commented  ·   ·  Flag as inappropriate

        I am taking a course in Excel 2016 which is one of the main reasons I signed up for it and now I find that I can't complete the course because the PowerPivot is not available in Office 365. Thanks a lot! Just add it back or give us a plugin!

      • Kerry commented  ·   ·  Flag as inappropriate

        Hello, if I create power pivot tables using excel 2016, can other users see the results/graphs if they are using 2013 excel? If not, do I need to revert back to 2013 excel so others can see report?

      • Kerry commented  ·   ·  Flag as inappropriate

        I am a business analyst and my employer generously gave me access to Office365 and 2016 office packages. However, I cannot run the power pivot tables in excel. This has prevented me doing my job, and now looks like we need to go back to 2013 excel. Does anyone see any probs with that?

      • Tom commented  ·   ·  Flag as inappropriate

        Would really like to use PowerPivot to develop data models from Dynamics NAV to PowerBi, but now find that our Office 365 Business does not include this feature. Very disappointing!!

      • Angelo commented  ·   ·  Flag as inappropriate

        Hello,
        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.

        Thanks,
        Angelos

      • Bill commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base