1. Extensions
  2. Excel Add-in Series 4
  3. Connect Excel with Anaplan
  4. Solve connection issues and understand connection limits

Find the answers for common connection issues with Excel Add-in Series 4 and understand connection cell and list limits.

Solve connection problems

If you cannot find the module you want to connect to, sign out and back in to the Add-in. This clears the cache and may fix the issue. Or you can check your access permissions with your Anaplan workspace administrator.

Connect to a module with subsidiary views

You can connect to a module with subsidiary views in it, but note that the Excel Add-in does not display the contents of any subsidiary views.

Work within cell limits

There's a limit of five million cells of Anaplan data per worksheet. If you try to create a connection that would result in more than five million cells on a worksheet, the cell count displays in red and you cannot create the connection.

If you have module with a list that has more than one million items, the module is grayed out and cannot be selected. If you have a list with one million items, you can connect your module as long as your other dimensions do not take the whole module over five million cells.

You can have any combination of nested rows or columns, as long as the total cell count does not exceed five million. 

If you need to display more than five million cells, split the data into multiple views and create multiple connections in separate sheets. Or you can pivot and filter your data to reduce the number of cells that are displayed.

Although you can create a read/write connection with five million data cells, you can only send and refresh one million cells at a time.

See Excel specifications and limits for information on other maximum limitations.

Work within dimension limits

The limit for the dimension size of imported modules or views is one million items. You cannot create a connection to a module that contains a dimension with more than one million items.

Display totals

Totals display at the bottom of columns in the Excel Add-in, regardless of the Totals Position that you select in Anaplan.

OLE action message

Sometimes you might get a popup message from Excel, which states Microsoft excel is waiting for another application to complete an OLE action. This is outside of Anaplan's control and is a common Excel message. To remove the message, select the X in the top-right corner.