For more information about Power Query, see this blog post and download this sample. To support this feature, Excel exposes the new Queries and WorkbookQuery objects, and their associated properties and methods. Excel has a new set of data import and shaping features that are based on Power Query technology and that let users query information in files, databases, Azure sites, and from other sources, and to combine queries.Several Office desktop applications have new features that are exposed in the VBA object model. Office 2016 for Windows New VBA object model features Support for web add-ins is already available in Office 20 for Windows, Office for iPad, and Outlook for Mac today, and they’ll come to the rest of Office clients over time. One thing to note, our engineering focus is Office web add-ins – web add-ins work across devices and platforms, and developers enjoy a modern web development experience. In addition to the improvements discussed there, including connecting the applications you build to the data and services available in Office 365 and creating add-ins that connect to third-party services, we continue to support developers working in VBA by adding new objects and members to the VBA object model across nearly all the Office applications.
Recently, we shared an overview of the new extensibility capabilities available for developers as part of the new Office 2016.
