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:

1. Open the Smart Query worksheet that you want to copy.
2. From the Smart Query ribbon, select Copy.
3. Open a new worksheet.
4. Do one of the following:

   • To copy the entire definition to a blank worksheet, from the Smart Query Panel, select Paste.

   • To replace a Smart Query definition, from the Smart Query ribbon of the worksheet to be replaced, select Paste.