Jump to content


Version 1704 - May 18, 2017 - Recent hyperlinks, default PivotTable layout, Get & Transform changes, add-in deployment, Quick Access Toolb...

  • Please log in to reply
No replies to this topic

#1 Jonathan


    Forums Administrator

  • Administrators
  • 888 posts

Posted 05 June 2017 - 11:13 PM

Version 1704 (Build 16.0.8067.2115)


Released to Current Channel on May 18, 2017


Recent hyperlinks


The hyperlink interface has been overhauled, adding a new Links drop-down to the Insert > Links area on the Ribbon. This contains a repository of recently-used hyperlinks, allowing you to quickly apply hyperlinks that you use often.


Default PivotTable layout


The default layout of PivotTables can now be set using the File > Options menu, making it easier to create standardized PivotTables without needing to reconfigure them every time.


Get & Transform changes


The Data Ribbon tab has been completely rearranged in this version, completely removing the Get External Data and Connections groups and adding new Get & Transform Data and Queries & Connections groups. This removes the old system of accessing external data completely and moves the Get & Transform tool to the forefront as Excel's means of accessing external data sources.


This version also includes some new improvements to Get & Transform:

  • Columns can now be created by example
  • Table columns can now be split into rows
  • SAP HANA parameters and grouping have been improved
  • Queries can now be saved as ODC files

Add-in deployment


Excel add-ins can now be deployed to entire user groups via Office 365. This allows you to ensure that all of your users have access to the same add-ins.


Quick Access Toolbar improvements


This version allows the Superscript and Subscript options to be added to the Quick Access Toolbar.

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