1. Extensions
  2. Excel Add-in Series 4
  3. Connections
  4. Multi-Sheet Connection

A Multi-Sheet Connection creates multiple Excel worksheets that apply to one connection. 

You must be signed in to the Add-in.

Use Multi-Sheet Connections to burst a report (distribute contents to various recipients).
Use the Sync Sheets toggle to synchronize the page dimensions in your Multi-Sheet Connection to those in your Anaplan model.

To create a Multi-Sheet Connection:

  1. Create a New connection. 
  2. For a connection to a module:
    In the Pivot and Filter dialog, on the right, toggle Multi-Sheet Connection to the right.
    For a connection to a saved view:
    In the Preview dialog, on the right, toggle Multi-Sheet Connection to the right.   
Toggle buttons for a Multi-Sheet Connection and Sync Sheets.
  1. Option: Toggle Sync Sheets to the right.
  2. 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. 

Related links: