Copying Smart Query Definitions in Excel
You can copy a Smart Query definition to a different worksheet in the current workbook or in another workbook. If the worksheet into which you want to paste the definition already contains a Smart Query definition, it will be replaced by the pasted definition.
To copy a Smart Query definition from one worksheet to another: