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:
- Open the Excel worksheet that contains the connection to clone.
- Select Clone on the Anaplan ribbon.
- On the Clone Connection dialog, select Yes.
A new worksheet is created, which contains a new, identical connection to your Anaplan data.