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.