+ Reply to Thread
Results 1 to 20 of 20

PowerPivot Will Be Available In All Windows Excel Skus Going Forward

  1. #1
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    97

    PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    This is great news from Microsoft Excel Team!!!

    Hats off to the team for making this important change.
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Here's a useful link posted by Hui on the Chandoo forums: https://app.powerbi.com/view?r=eyJrI...MiOjEwfQ%3D%3D

    It takes you to a list of feature requests regarding Power Query, all in one place.

    EDIT: The link seems not to be working today - it was yesterday. I'll leave it, though, as if it's fixed, it may prove useful to some.
    Last edited by AliGW; 05-23-2018 at 01:20 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    The link seems to work- you just need to click on the button afterwards (not sure why).
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    You probably have not read the small print.

    There are different versions of office products with different features. It is highly unlikely MS will treat all its different class of customers the same.
    Have you also noticed the size of office 365 is almost 1GB now? By the look of MS' constant update, it will hit 2GB soon.

    I had to wait for 2 hours for update. Since Windows 10, we have lost control of MS' botched update.

    No one except MS knows with our harvested data.

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    It clearly states all Windows SKUs. Not great for Mac users, but everyone else with 2016 or later gets it.

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    So does anyone know how to get the update?

    I just updated Home and Student 2013.

    After restarting it's still not on the ribbon or in Options > Add-ins.

    No links enlighten me. What am I missing?
    Dave

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    It is from build 9330 onwards - my Office 365 is up-to-date, but not yet on that build, so it’s a case of waiting until we are. I’m not on the insider programme.

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Ali,

    Thank you. I'll keep an eye out.

    Dave

  9. #9
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    It's not coming to any new 2013 or non-subscription 2016 SKUs. If you have one of those and don't already have Power Pivot, you're still out of luck.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Build 9330 is now available for Office 365 and the Manage Data Model (PowerPivot) icon now appears on the ribbon. Now to try using it!

  11. #11
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Found download here today.

    https://www.microsoft.com/en-us/down....aspx?id=39379

    Under System Requirements it states:
    Microsoft Power Query for Excel requires Internet Explorer 9 or greater.

  12. #12
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Dave, you've win10 so probably you've IE11 also (whatever but for sure higher than 9)

  13. #13
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Thanks sandy. But I have Firefox and want to keep it.

    Anyway I finally "threw in the towel" and upgraded Office 365 this evening. I wanted the new functions, too. I'm delighted to find they didn't over write my Custom Lists, QAT or other settings. Excel loads as I left it in 2013. Yay.

  14. #14
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Dave, now you'll be Excel Wizard, LOL

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Dave - you don't have to use Edge (or IE) - it just needs to be on your PC, which it will be along with Windows 10, as Sandy pointed out. I have Firefox and Microsoft haven't prevented me from using it since the PowerPivot functionality appeared in the 365 version of Excel.

    I don't think you'll regret the move to the subscription model.

  16. #16
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    Thank you Ali. I was a little bit 'on edge' about the move anyway. Really wanted the new functions and PP/Get and Transform. I finally "caved in" and made the move instead of going the add in route.

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    I resisted it for such a long time, also dubious about it, but I have never looked back. OneDrive is another thing that is really worth having.

  18. #18
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    OneDrive (with different names) exist from [edit:]2007. This is not new feature
    Last edited by sandy666; 06-18-2018 at 02:18 AM. Reason: see edit

  19. #19
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    I didn't say it was, did I? I said it was worth having. In any case, the older versions were not great: it has improved significantly over the past two or three years.

  20. #20
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: PowerPivot Will Be Available In All Windows Excel Skus Going Forward

    whatever you say

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  2. PowerPivot in Windows 7 XP Mode
    By tonyph17 in forum Excel General
    Replies: 3
    Last Post: 05-13-2012, 06:15 PM
  3. skus in columm a for each sale, qty. of skus sold, each sale in co
    By JMB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  4. skus in columm a for each sale, qty. of skus sold, each sale in co
    By confused1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] skus in columm a for each sale, qty. of skus sold, each sale in co-Need to sort
    By confused1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1