2. Extensions
  3. Excel Add-in Series 4
  4. Excel Add-in connection
  5. Clone a connection in Excel

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's 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 on the Anaplan ribbon.
  3. On the Clone Connection dialog, select Yes.

A new worksheet is created, which contains a new, identical connection to your Anaplan data.

Disclaimer

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