Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!