Moving a Query

To move an Analytics Edge query, first make sure the Edit Mode is ON — that places Excel comments (little red triangles) in the cells with queries and cell references. Then simply move the comment to another location in the same worksheet, or another worksheet in the same workbook. Click on a worksheet cell to synchronize the queries with the new comment locations.

Move to Another Workbook – Cut and Paste

To copy queries between workbooks, select the worksheet cell where the query is, then select Edit Query > Cut from the Analytics Edge ribbon. Select the new location and select Edit Query > Paste from the Analytics Edge ribbon.

remove-a-query