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

518 votes
Sign in
(thinking…)
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] (Product Owner, 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
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Sax C commented  ·   ·  Flag as inappropriate

    I'm in Office 2016 Standard - Excel 2016 MSO (16.0.4738.1000)
    I still unable to see Power Pivot under COM Add-in.
    Could you be more clear about all SKU refer to all version of 2016, no matter Office or Excel standalone?

  • Anonymous commented  ·   ·  Flag as inappropriate

    I'm sorry but I'm on build 11029 and still no Power Pivot. What am I missing here?

  • Hardik Gupta commented  ·   ·  Flag as inappropriate

    Hi Ashvini,

    Thanks for making Power_Pivot available to all the versions of Excel. In our organization, we are using Excel 2016 Standard version. Can you please help us with how to get Power-Pivot working in this version.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Opened an account under office 365 professional e3 by company email, but desperately found that all downloads provide only excel online access, with no access to excel that have powerpivot.

    Why office proplus excel is unlicensed, and no trial of power pivot available? It said there is a free trial period.

  • Miguel Ulloa commented  ·   ·  Flag as inappropriate

    Currently, the "roles" functionality, which enables row-level security, is available in tabular data models and Power BI desktop. I would like to use this feature in Power Pivot. To elaborate, I'd like to load a full data set, and have Power Pivot filter the data model shown to the current user, based on their security profile. I can set this fairly quickly in Power BI Desktop, not sure why it isn't an option for Power Pivot.

  • Sean commented  ·   ·  Flag as inappropriate

    I just bought the home and student version and don't see it :( When will the feature be out?

  • malvika kankaria commented  ·   ·  Flag as inappropriate

    Please do add it in office home and student version too. And how long will it take till i can upgrade my excel for the one that includes powerpivot

  • Edward Miles commented  ·   ·  Flag as inappropriate

    Hi, which Home and Student edition build will this be available in and when? I'm looking at an 1806 version and I can't see PowerPivot
    Thanks

  • Anonymous commented  ·   ·  Flag as inappropriate

    Excel-lent news! (sorry for the pun ;-))
    It is really great news, cannot thank you enough to finally have a consistent base for doing models, without the licensing strangeness that was before.
    Finally DAX / modelling skills will be useful and share a natural evolution path from Excel to PowerBI and/or SSAS Tabular.

  • Ed Hansberry commented  ·   ·  Flag as inappropriate

    Because @Mimi - this was a licensing decision that involved little to no coding and was just a decision to include it with all Office SKUs for Windows. The one you linked to is a massive code change to go back to the old way. I doubt they will revert that given they are now targeting the new Sets feature in Windows Redstone 5 due this year, and it won't work effectively with all documents in a single container. But they are looking at specific use cases as the post says at the top.

  • Ed Hansberry commented  ·   ·  Flag as inappropriate

    No exact date for Office 2019, but scheduled for the 2nd half of this year, which could be July 1 or December 31, or somewhere in between. MS hasn't finalized a date yet.

  • Peter Bartholomew commented  ·   ·  Flag as inappropriate

    Good news! Perhaps now, at last, spreadsheet programming will begin to move towards something more professional.
    Peter Bartholomew

← Previous 1 3 4 5 12 13

Feedback and Knowledge Base