Save a Shortcut Query File (MDS Add-in for Excel)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
In the Master Data Services Add-in for Excel, save a shortcut query file when you frequently need to access the same set of data.
To perform this procedure:
To save a shortcut query file
In the Save and Send group, click the arrow under Save Query and click Save as Query.
Optional. To rename the query, click the arrow under Save Query and click Manage Queries. Select the query and click Rename.
Click the arrow under Save Query to view the shortcut query and open it.