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.