Please note javascript is required for full website functionality.


Get and Transform - Transformed July 2017

24 July 2017

Microsoft has just announced the latest major update to data import and shaping functionality in Excel. Now, Excel’s data import functionality has been "enhanced" (i.e. rearranged) on the Ribbon so that end users may find it easier to look for the right tools. Just when you thought you knew where everything was!

These updates are available as part of an Office 365 subscription starting from Version 1704 (Build 8067.2115). Obviously, this update only affects Excel 2016 users as it remains as Power Query in Excel 2010 and Excel 2013. Some may already be experiencing deja vu here - many of these changes have been trickling into Excel for some time for non-Current channel users.

You can find out more in August's newsletter (yes, we have made the deadline for once!). If you are not already a subscriber, simply enter your details at the bottom of any SumProduct web page to join our happy band.