Applies ToExcel 2016

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.