-
Dropdown menu in Excel AddIn
Hello, We currently have a dropdown menu in the line items when selecting items from a list - as per image below: However, when we create the connection with Excel, there is no dropdown nor anyway of knowing the names of the list which have to be manually inputted - please see image below: Is there any way of giving the…
-
Excel Format Issues - Copy and Paste
Hi all, I am having an issue when it comes to copying and pasting data from Anaplan to Excel. In fact, the data format changes from number to general or scientific. I don't know how to fix this problem, may anyone help me? Thanks in advance, Luca
-
Conversion tool to automatically create card templates for Anaplan for Microsoft 365
Hi, Currently, the Anaplan for Microsoft 365 extension requires card templates in the UX in order to pull in data into the extension into Excel. This suggestion is to create a card conversion tool to automatically create card templates based on grid and other published cards in the UX. This approach would be similar to the…
-
Clubbing multiple excel exports
Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…
-
Xlookup in Anaplan
Background: have a strange 2-level hierarchy where items are at the top level if they have any children, and they are at the 2nd level if they have any parents. I have many items that exist at both the top level and lower level of the hierarchy, up to 5 levels deep (but only 2 levels ever show up in the parent to child…
-
Excel Upload Limitation?
Hi Team. Just wondering if there's a known issue with how many cells can be uploaded at once. I have a spreadsheet that can potentially upload 20,000 cells. Works great with 100 or so change but at 20,000 it crashes Excel. I'm using Version 4.1.2.295, the latest version. The previous version worked fine.
-
7.01-04 Version Informartion
More information about versions can be found here. Version Information for Excel Add-in
-
7.01-03 Versions Control
It is best to upgrade to the latest version after it has been fully tested by the business Best Practice article Governance for the Office Add-Ins
-
7.01-02 Use Named Ranges in your formula
It is best to use Named Ranges rather than relying on formula references. Best Practices article Best Practices About Microsoft Office for the Add-Ins
-
7.01-01 Naming Conventions
Do not change the module name in Anaplan as this may break the connection. Best Practices article Best Practices About Excel Add-In
