You can clone an Anaplan connection to duplicate the connection and copy cell data into a new worksheet. If you edit the data in the new worksheet, the data in the original worksheet remains unchanged.
You must be signed in to the Google Sheets Add-on to clone a connection.
Note: if you clone a read-write connection, the new connection is also read-write. You can use the cloned read-write connection to update Anaplan. If you want to create a read-only connection with the same connection details, create a new connection in another worksheet.
To clone a connection:
- Go to the Anaplan sidebar.
- Click Clone connection.
The Anaplan connection and cell data copy into a new sheet.
The new sheet is given the same name as the original sheet, with a number at the end. For example, Sheet name (1). You can rename the cloned worksheet at any time without affecting the connection.