Anaplan Excel add-in 4.3 Cloning


I am trying to copy an excel sheet with an existing Anaplan connection into another workbook. However, once the copy is done, the Anaplan connection seems to be broken and cannot be refreshed.


I understand that the cloning function currently works within a workbook only, does anyone have any workarounds with respect to cloning into another workbook?


Many thanks!


  • Hi @nicholaswzl ,

    Try to create a connection in new workbook and then copy whole area of the connection sheet in source workbook. In theory, settings of existing connection sheet would change to the desired connection sheet. I.e. after copy you can try to 'Pivot and Filter' to check if settings are changed.