none
How to Update PowerQuery in Excel 2016 RRS feed

  • General discussion

  • Hi guys,

    how do you update Powerquery add-in in Excel 2016? When I download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=39379

    I am able to install the latest version over the older one in Excel 2013 but not in Excel 2016.

    When I try 2016, I get message that "I already have the latest version" which is certainly not the case since I dont see some new features which can be seen in the 2013 version.

    DZ



    Tuesday, June 21, 2016 2:27 PM

All replies

  • Anyone? MS Support?

    Friday, July 1, 2016 8:16 AM
  • The Power Query functionality is built into Excel 2016, under Get & Transform. It's not a separate add-in. You can check to see if an Office update is available by navigating to File-->Account-->Update Options-->Update Now. If an update is available, it will include any new "Power Query" functionality.
    Friday, July 1, 2016 12:20 PM
  • Hmmm. Is it possible the stand-alone add-on has more features than the built-in 2016 version?

    I am especially interested in the multiple Merge options which I currently don't see in Excel 2016.

    DZ


    Friday, July 1, 2016 12:52 PM
  • Both should have feature parity. I wasn't aware of a multiple merge option in Power Query, and when I checked, I notice only the mechanism that's always been there for merging queries. Perhaps you can help me understand that more.

    Both have multiple append though, which you've probably already noticed.

    Friday, July 1, 2016 1:44 PM
  • 
    Friday, July 1, 2016 1:48 PM
  • See above. I dont think these options are available in the 2016 version.

    This is basically why I am stuck with 2013 Office Suite.
    Friday, July 1, 2016 1:48 PM
  • Huh? That's want you meant by multiple merge? As far as can recall, those options have been available in Excel 2016 as long as they've been available in Power Query. I use Excel 2016 almost every day.
    Friday, July 1, 2016 2:07 PM
  • Yep... Multiple merge options :)

    See 2016 below:

    Friday, July 1, 2016 2:11 PM
  • Dan, are you using a standalone version of Office 2016?
    Friday, July 1, 2016 2:26 PM
  • What do you mean? 

    We have some sort of entreprise license. Everything is installed on our PCs. We have Outlook, Excel, Word, PowerPoint etc... 

    Friday, July 1, 2016 2:31 PM
  • Oh, okay. I'm not sure what kind of updates get pushed to enterprise licenses (might be bug and security fixes only), so someone else will have to comment on this. I use an Office 365 license, so features are updated roughly once a month.
    Friday, July 1, 2016 2:45 PM
  • Hmmm, ok.

    Well, I do get updates from time to time to my 2013 Add-on, but my colleagues dont really get anything, not even when they try to force it.

    DZ


    Friday, July 1, 2016 2:47 PM
  • Seems that someone needs to have a chat with IT.
    Friday, July 1, 2016 3:34 PM