Version 1704 (Build 16.0.8067.2115)
Released to Current Channel on May 18, 2017
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
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.