Jump to content


Version 1606 - July 5, 2016 - Draw tab with shape recognition, new external data sources and Get & Transform improvements

  • Please log in to reply
No replies to this topic

#1 Jonathan


    Forums Administrator

  • Administrators
  • 888 posts

Posted 05 June 2017 - 09:01 PM

Version 1606 (Build 16.0.7070.2022)


Released to Current Channel on July 5, 2016


Draw Tab and Shape Recognition


A new Draw tab option is now available for the Ribbon (it must be enabled via the Ribbon customization options). This tab allows expanded drawing options with shape recognition that allows crudely-drawn shapes to be automatically converted into perfect squares, triangles, circles, etc.


The Draw tab is primarily intended to make working with shapes easier on tablet devices, but it can also be enabled on desktop versions of Excel.


New external data source options


This version adds several new options when connecting to external data sources, allowing Excel to connect to Sharepoint Online, Microsoft Exchange and SAP HANA.


Get & Transform improvements


This version also adds several minor improvements to Get & Transform:

  • Duration values can now be converted to years
  • White space and line feeds are now properly displayed in the Query Editor preview
  • Queries can now be renamed directly from the Queries pane
  • Jagged CSV files are now automatically detected
  • A Microsoft account can now be used when connecting to Microsoft Exchange
  • URLs are now validated to prevent incorrect URLs from being entered when connecting to Sharepoint

OLAP performance improvements


Creating, editing and refreshing OLAP pivot tables should have improved performance with this update.

Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users