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.

Facebook LinkedIn Email
SUBSCRIBE RSS FEEDS

Need more help?

Want more options?

Discover Community

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

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

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

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders