1. Extensions
  2. Excel Add-in Series 4
  3. FAQs

Excel Add-in frequently asked questions:

Questions related to limitations

What is the cell limit for a worksheet?

There's a limit of 1,000,000 cells per worksheet. However, there's no limit to the number of worksheets you can use to display Anaplan data in a workbook.

What is the limit for list size?

Excel has a maximum limit of 10,000 items displayed in filter drop-down lists. See Excel specifications and limits for information on other maximum limitations.

Where do totals (sums) display for columns? 

 Totals only display at the bottom of columns in the Excel Add-in.

How many Excel worksheets can I use with a Multi-Sheet Connection?

To optimize performance we recommend you use a limit of 20 Excel worksheets for each Multi-Sheet Connection

Questions related to connections

Can I access subsidiary views?

Subsidiary views are not available. You can connect to a module with subsidiary views in it, but the Excel Add-in will detect these and filter them out.

My connection did not refresh properly, why? 
In order to include a cell range in a Refresh, keep the cell range together at all times, rather than break or split it. You can insert columns and rows in a worksheet and you can rename columns and rows in a worksheet. If you've inserted data or modified cells in other ways, you might have broken the cell range. If you break a cell range, your connection may not refresh properly. Revert your changes to keep the cell ranges intact.

Why does the connection or refresh speed seem slow?

The first new connection or refresh of data from Anaplan into the Add-in may take a few seconds. Once the data loads into memory, future refreshes of the same connection will be quicker.

When I extract data to a grid location, why can't I move it?

The location of extracted data is determined by the starting cell you select when you make a connection. If you try to move the grid or copy data to another worksheet (or another location within the same worksheet), the connection to Anaplan breaks. You can however insert columns and rows in a worksheet, in a way that does not break the cell range.

What happens when I refresh my Brought-Forward line item configuration?

When a Brought-Forward configuration for a line item that is changed in a module, and you click Refresh: 

  • The change displays in the Excel Add-in after you sign out and sign in again. 
  • If you do not interact with the Excel Add-in for more than 30 minutes you're automatically signed out. Next time you sign in, the change is applied.
Questions related to compatibility 

What other languages does my Excel Add-in feature?

The Excel Add-in only supports English.

Does the Excel Add-in work with other Add-ins on the market?

The Anaplan Excel Add-in is built to meet the Microsoft standard. We cannot guarantee it will work with other add-ins.

Is there an issue with page dimensions and the drop-down lists?

Users that use Excel 2010 may occasionally experience issues with drop-down lists in the Pivot and Filter dialog. Once you select a dimension to include on a Page, you're unable to use the drop-down list again to select or deselect another item. If the ribbon becomes unresponsive, sign out then sign in again. 

Can I use multiple Add-in versions on the same machine?
No. You cannot use multiple versions on the same machine.

Can I use my colleague's workbook if this person is using another version of the add-in?
Yes. 

  • If you and your colleague both use Excel Add-in series 4.0+, workbooks and files are compatible. 
  • You can also use your colleague's workbook as long as you've the same or a higher version. 
  • Workbooks can be converted from Series 3 to Series 4 (a back-up of the file from before conversion is available). For more information, see Workbook Conversion.

Can I apply Anaplan style settings to my worksheets?

Yes. Click Settings and then select Apply Anaplan styling to your worksheet (cell borders, cell colors, font colors).

Why is my Anaplan ribbon disabled?

Your workbook requires a conversion to be compatible with your current version of the Excel Add-in. See Workbook Conversion.
Once you convert the workbook, the ribbon is enabled.

What if I can't find the module I want to connect to?

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