After you install May 3, 2016, update for Excel 2016 (KB3115090), the following Data Connectivity features are available in theĀ Get & Transform section of the Data ribbon in Excel 2016:

  • Supports command time-out for user experience.

  • Settings to disable Privacy Level prompts at the computer level (including the GlobalPrivacyLevel registry key).

  • Query group management:

    • Expand or collapse all

    • Keep query group expansion states

  • New transformations:

    • Delete blanks on the Column Filter menu

    • Convert duration values to Years

    • Keep duplicates

  • Supports white space and line feeds in the Query Editor preview.

  • Includes hints for sample input values in the Change Type with Locale dialog box.

  • Navigator improvements:

    • Ability to disable preview from the navigator

    • Technical name support

  • Renames queries directly from the Queries pane.

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!