In the Excel Add-in, use Clone to duplicate a connection, and its data, into a new Excel worksheet. If you just copy an Excel worksheet, the new worksheet does not contain a connection.

You must be signed into the Add-in to clone a connection.

It is not possible to clone a multi-sheet connection.

Note: You can copy a workbook and its associated connections will be kept.

To clone a connection:

  1. Open the Excel worksheet that contains the connection to clone.
  2. Select Clone from the Anaplan ribbon.
  3. Select Yes on the Clone Connection dialog.
    A new worksheet is created, which contains a new, identical connection to your Anaplan data.


We update Anapedia regularly to provide the most up-to-date instructions.