Copy a Query

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

Copy to Another Workbook

To copy queries between workbooks, select the worksheet cell where the query is, then select Edit Query > Copy from the Analytics Edge ribbon.

edit-copy

Then select the new workbook location for the copy, and select Edit Query > Paste from the Analytics Edge ribbon.