Chapter 38: Introducing Power Query
38
Managing existing queries
As you add various queries to a workbook, you will need a way to manage them. Excel
accommodates this need by offering the Queries & Connections pane, which enables you to
edit, duplicate, refresh, and generally manage all of the existing queries in the workbook.
Activate the Queries & Connections pane by selecting the Queries & Connections command
on the Data tab of the Excel Ribbon.
You need to find the query on which you want to work and then right-click it to take any
one of the following actions (see Figure 38.13):
FIGURE 38.13
Right-click any query in the Queries & Connections pane to see the available management
options.
Edit Open the Power Query Editor, where you can modify the query steps.
Delete Delete the selected query.