Installation of updated Data ribbon?

[Jaymond Flurrie]

This might be a stupid question, but how do I update my Excel 2016 so that it has the new "Get & Transform Data" Data ribbon tab instead of the old "Get External data" tab?

 

[SpillerBD]

Get and Transform is a section on the Ribbon in 2016. I forget if it's on that ribbon or the Data Ribbon. ( I'm at work with 2013 , but have 2016 on my personal machine.)

 

[Scott T]

Yes, in 2016 get and transform is part of the Data tab instead of a separate Power Query tab.

SpillerBD if you think being on 2013 at work is bad I am an 2010 at work.

 

[SpillerBD]

Yes, in 2016 get and transform is part of the Data tab instead of a separate Power Query tab.

SpillerBD if you think being on 2013 at work is bad I am an 2010 at work.

What could be worse? A mixed Office environment with 2007, 2010 and 2013 ! Yes, here!

 

[Jaymond Flurrie]

I have version 16.0.9029.2253 32-bit and the groups on data tab are "Get External Data", "Get & Transform", "Connections", "Sort & Filter", "Data Tools", "Forecast" and "Outline" while it should be "Get & Transform Data", "Queries & Connections" etc.

 

[Jaymond Flurrie]

Here's what I'm talking about: https://www.youtube.com/watch?v=ohGFPF12Qwc&feature=youtu.be&t=53s

I have that top version, the legacy version. And I'd want to have that new version.

 

[Scott T]

Do you have the standalone version or the subscription version? I have office 365, the subscription, at home not sure if the ribbons are different between the two.

 

[Jaymond Flurrie]

Do you have the standalone version or the subscription version? I have office 365, the subscription, at home not sure if the ribbons are different between the two.

I have a MSDN subscription version.

 

[SpillerBD]

Do you have the standalone version or the subscription version? I have office 365, the subscription, at home not sure if the ribbons are different between the two.

They are. I forget if it was Mike Girvin or Ken Puls who had a post on that minor difference. The difference is that the O365 subscriber gets the incremental updates.

edit: add, it also could have been Matt Allington or Rob Collie.

 

[Jaymond Flurrie]

They are. I forget if it was Mike Girvin or Ken Puls who had a post on that minor difference. The difference is that the O365 subscriber gets the incremental updates.

edit: add, it also could have been Matt Allington or Rob Collie.

So even if I try to update and there is an update, I can't update?