Copy a Query

2020-01-25 The Analytics Edge Standard Add-in has been merged into the Analytics Edge Core Add-in (Standard license option) for existing licensed users only. The Standard Add-in itself has been discontinued and is no longer available.

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.