After you install MS16-133: Description of the security update for Excel 2016: November 8, 2016, the following data connectivity and transformation features are available in Excel 2016:
-
Oracle Connector – Improved Navigator Previews Performance.
-
OData Connector – Support for the Select Related Tables option.
-
SAP HANA Connector – Enhancements to parameter input UX.
-
Web Connector – UX Support for specifying HTTP Request Headers.
-
OData Connector – UX Support for multipart OData URLs.
-
Query Dependencies view.
-
Query Editor Ribbon Support for Scalar Values.
-
Add Function Invocation Column.
-
Expand & Aggregate Columns – Support for Load More values.
-
New Transform – Convert Table Column to a List.
-
Keyboarding – Support for smart typing in dropdown menus.
