1. Extensions
  2. Excel Add-in Series 3
  3. Settings
  4. Show or hide connection details

In series 3 of the Excel Add-in, your connection details display by default, when you connect to an Anaplan model to an Excel worksheet.
You can hide these details through the Settings dialog. 

You can hide the connection details in the Excel Add-in when you make a connection to an Anaplan model. 

The connection details are located above the data you've imported into your Excel worksheet. They show:

  • when the connection was last refreshed,
  • the model name,
  • the module name,
  • any page filters that are currently applied to the data,
  • the view name.

To hide the connection details on a worksheet:

  1. In Excel, click the Anaplan tab.
  2. Click Settings.
    The Anaplan Excel Add-in Settings dialog displays.
To display the connection details on your Excel spreadsheet, select the Display connection details checkmark box in the Anaplan Excel Add-in Settings and click OK. To remove the details from your worksheet, deselect the checkmark box and click OK.


  1. Deselect the Show connection details checkbox.
  2. Click OK.
    The connection details no longer display. 

To show the connection details again:

  1. Repeat Steps 1 - 2 above. 
  2. Select Show connection details. 
  3. Click OK.
    The connection details display.

Learn how to: