Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!