1. Extensions
  2. Excel Add-in Series 4
  3. Work with Anaplan model data in Excel
  4. Use the toolbar

In series 4 of the Excel Add-in, the toolbar displays useful information about your connection and enables you to change what items display for the Pages dimension. You can also show or hide the toolbar as needed.

Use the toolbar

The left side of the toolbar contains details about your current connection such as the workspace, model, module, and view.

You can also change what items display for the Pages dimension:

  1. Click the context selector for a dimension to the right of the connection information in the toolbar.
    A drop-down list displays.
  2. Select the item to display for the dimension.
  3. Repeat steps one and two for each dimension to change.
  4. Click Refresh.
    The connection updates to display the items you selected.

Show or hide the toolbar

Based on how you use the Excel Add-in, you might not require the toolbar. By default the toolbar displays, but you can show or hide it:

  1. To hide the toolbar, click Hide Toolbar in the Excel ribbon.
    The toolbar no longer displays, and the button changes to Show Toolbar.
Hide Toolbar button.
  1. To show the toolbar again, click Show Toolbar.
    The toolbar displays.
The toolbar enables you to change your context selection for your connection. Click Refresh each time you make a change.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.