Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Update adds and improves data connectivity and transformation features in Excel 2016


View products that this article applies to.

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.
Third-party information disclaimer

↑ Back to the top


Keywords: kbqfe, kbsurveynew, kbexpertisebeginner, kbbug, kbfix, kbhowto, kb

↑ Back to the top

Article Info
Article ID : 3115250
Revision : 1
Created on : 1/7/2017
Published on : 1/20/2017
Exists online : False
Views : 296