Microsoft KB Archive Search

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.

  1. Home
  2. November 8, 2016, update adds some new Get & Transform features in Excel 2016

November 8, 2016, update adds some new Get & Transform features in Excel 2016

View products that this article applies to.

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.

↑ Back to the top

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

↑ Back to the top

Article Info
Article ID : 3127896
Revision : 1
Created on : 1/7/2017
Published on : 11/8/2016
Exists online : False
Views : 294