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?

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

Was this information helpful?

What affected your experience?

Thank you for your feedback!