1. Extensions
  2. Excel Add-in Series 4
  3. Connect Excel with Anaplan
  4. Remap a connection to a different model

In series 4 of the Excel Add-in, remap a connection to change the Anaplan module or saved view that data is downloaded from.

Remap is an advanced function as you must ensure the dimension structures match between the current and remapped connection.

You might want to remap your connection when the original connection has changed. For example, when you copy or archive a model.

To remap a connection:

  1. Select Remap from the Anaplan ribbon.
    The Remap Connection dialog displays.
Remap on ribbon and dialog.
  1. Use the dropdown menus to choose the module or saved view to remap your connection to:
    1. Select a customer.
    2. Select a workspace.
    3. Select a model.
      Use the search field to narrow down the list of models.
    4. Select a module or saved view.
      Use the search field to narrow down the list of modules and saved views.
  2. Click Remap.
    Alternatively, click Cancel to return to your connection.

When you remap, your Excel worksheets are overwritten with data from the Anaplan module or saved view you remap to. To ensure your remap is successful, remap to a module or saved view with a similar structure.

You can clone your connection before you remap to ensure it works as expected.