Move Excel Worksheet with Anaplan connection to new workbook - Excel Add in

Options

Hi, is it possible to move a worksheet with an existing Anaplan connection to a new workbook without the connection disappearing.

Thank you

Answers

  • Hi @SamDepari22, so far I haven't seen such functionality in excel add-in, it is the same reason why you can't simply copy the sheet (i.e. have to use 'Clone' functionality not to loose connectivity). As suggestion, you can create a saved view in Anaplan and use it as a new connection in a new worksheet or create a copy of the excel of the initial connection and delete all the sheets and keep only sheet with a connection.

  • Hi @samval, thank you for the response!!