After you install MS16-088: Description of the security update for Excel 2016: July 12, 2016 (KB3115272), the following data connectivity and transformation features are available in Excel 2016:
-
New SAP HANA connector.
-
New SharePoint folder connector.
-
New Online Services connectors category.
-
Improved DB2 connector that uses the Microsoft driver for IBM DB2.
-
Improved Text/CSV connector that exposes editable settings in the Preview dialog box.
-
Improved relational database connectors that display Schema information as part of the navigation hierarchy.
-
Data Source Settings improvements, including "migrate source" capability.
-
Advanced "Filter Rows" dialog mode.
-
Inline input controls for the function invocation within the Query Editor.
-
Query Steps improvements that allow to always generate Step names in English and support reordering of Query Steps through drag-and-drop gestures.
-
Date picker support for Date fields input in Conditional Columns and Filter Rows dialog boxes.
-
New shortcut menu entry to create new queries from the Queries pane.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
