November 8, 2016, update adds some new Get & Transform features in Excel 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?

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

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×