1. Extensions
  2. Excel Add-in Series 4
  3. Connect Excel with Anaplan
  4. Clone (duplicate your connection)

In series 4 of 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: In version 4.3 of the Excel Add-in, 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. Click Clone from the Anaplan ribbon.
    The Clone Connection dialog displays.
Clone on ribbon and dialog.
  1. Click Yes.
    A new worksheet is created, which contains a new, identical connection to your Anaplan data.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.