Search

Create a Multi-Sheet Connection

In Excel Add-in version 3.4 and above, you can have multiple Excel worksheets apply to one connection.

You must have logged into Excel Add-in version 3.4 or above.

Ensure you have a blank worksheet open in Excel.

If you cannot find the module or saved view you want to connect to, check your access permissions with your Anaplan workspace administrator.

When you Pivot and Filter, or Preview your dimensions, you can create a Multi-Sheet Connection.
The data for each dimension value you select displays on separate Excel worksheets.
You can use this functionality for report bursting.
You can opt to synchronize the page dimensions in your Multi-Sheet Connection to the same dimensions in your Anaplan model, via the Sync Sheets toggle.

To create a Multi-Sheet Connection:

  1. Create a connection.
  2. For a connection to a module:
    In the Pivot and Filter dialog, on the right, toggle Multi-Sheet Connection to the right.
    Optionally, to enable Sync Sheets, select all items in each dimension in Pages.
    A Sync Sheets toggle displays.
    For a connection to a saved view:
    In the Preview dialog, on the right, toggle Multi-Sheet Connection to the right.
    A Sync Sheets toggle displays.
  3. Optionally, toggle Sync Sheets to the right.
  4. Click Finish.
    A series of Excel worksheets displays, each with the same color-coded tab that indicates the worksheets belong to the same Multi-Sheet Connection.
    The data for each dimension value you selected, separates into individual Excel worksheets.

Learn more about Sync Sheets.