Extensions

Excel Add-in to highlight header mismatch if user changes it by mistake
Once we import a view in excel using excel add-in and let's say there are 4 rows in the view City-A City-B City-C City-D Keeping the order same, if the user renames City-A to City-ABC by mistake and then tries to push data to Anaplan then instead of showing no changes, Anaplan should show header mismatch. This can further…
Excel Add-in Data sync to generate Log in Anaplan History
Anaplan to generate detailed log of Excel add-in sync in history. A cell level change log as we see for any Anaplan cell in any of the modules.Ex: 1. Value of one cell in excel add-in got change from 1000 to 80. 2. We do refresh and sync data. 3. Anaplan generates a log in history for this line item value against that cell…
HELP! Anaplan not working
I'm having issues using Anaplan through excel. I log into Anaplan through excel and I then click on New to open a new pivot table. At this point, a message appears just below which says "This worksheet does not have a connection to Anaplan." A second window opens but the window is grey and nothing seems to happen. Has…
Excel add-in German Localisation
As an end user I would like the Excel add-in to be localised for the Standard German language.
Excel Add In User Security Read/Write
Hi, does anyone know if User Read/Write definitions from an Anaplan Model translate to Excel Add In? If a user only has read access to an input module, that user then creates a connection to that input module with the Excel Add In, if they chose to create a read/write connection, would they have only read access, or would…
Excel Add-in 3.2 vs. 3.3 vs. 3.4
Dear everyone, I am part of the IT organization at my company, and I am responsible for the Anaplan environment from am IT perspective. We are currently using the Excel add-in v. 3.2, which meets our organization's requirement to control the data in Anaplan (read only, not write-back). My organization wants to keep the…
User Permissions in Excel add in
Hi, I am an admin and I want to create an excel file for users that have different list permissions. When another user opens the file they can still see the data for all the list. Is there a way to restrict this? Thank you
Anaplan Connect Batch File - Windows Task Scheduler
Hi team, I have Anaplan Connect batch file which runs an Export process that runs perfectly when executed manually (double clicking on the Batch file) but when I run the Batch file through Windows Task Scheduler I receive the below error Any ideas? Thanks
Anaplan Excel Add-In ( Reset Format)
Anaplan Excel Add-In 3.3 (Read/Write Query) Ability to reset any formatting as currently any changes made to Excel, Anaplan tries to over lay the difference than try to wipe out changes and replace with default view. Currently, we have the reset option in Dashboard, need the same in Excel.
Anaplan Excel AddIn 3.3
Hi All, We have MS Office 365 ProPlus, version below Excel tends to crash on various machines with the AddIn 3.3 installed. A MS Office quick repair tends to resolve crashes but it is a pain to repair every couple of days. Has anyone had the same experienced and what can be done to resolve this? Thanks, Alvin
Your help is needed! Excel and PowerPoint add-ins: best practices
Hi all, I am reaching out to the Community to get your input about best practices for the Excel and PowerPoint add-ins. Please share your tips and tricks to make the use of the add-ins as efficient as possible! The suggested themes are: * Governance of the add-in: upgrade process, version control, COE management of the…
Anaplan Excel Add-In 3.3 (Read/Write Query)
Hi all, I understand the ability to create a read/write connection with Anaplan was reintroduced in v3.3 of the Excel add-in. Where does this feature reside? I am using v3.3.44.0 and below is a screenshot of my toolbar; I have full access and workspace admin permissions, I also have write access enabled on the version and…
Excel Add In Filtering for Base Members Only
Hi All, Has anyone come across the ability to filter only for base members against a hierarchy in the Anaplan excel plugin instead of having to manually deselect all the parents them each time? The alternative is that I can think of is creating a saved view that only shows base members of the list, however the downside…
High Charts or D3 Charts in Anaplan Dashboards or Anaplan Pages?
High Charts or D3 Charts in Anaplan Dashboards? Is it possible to embed or incorporate a charting library like High Charts or D3 Charts in Anaplan Dashboards especially after the introduction of new User Interface which runs on top of the latest and greatest in HTML5? I am not sure about its validity or feasibility from an…
Optimiser
Hi Problem Statement: we are trying to minimise the fuel requirement to provide a given amount of energy. As all the input datas are in month wise for all the fuel except the demand in which month wise aggregated demand of all fuel has been taken. Error: We will be able to run the process sucessfully. But we are not…
Anaplan Excel Add-in
In our Org, we have not yet authorized the use of Anaplan Excel-AddIn so far, even though some users use it. In the past we had experienced some issues such as the model being locked during export of data by users while using the AddIn. Now that there is a new version of Excel AddIn, i am reaching out to folks to get some…
Error during registering/ upload the certificate into the anaplan
We have procured the certificate from Sectigo and followed the step given in this link (https://community.anaplan.com/t5/Releases/How-to-Use-Third-Party-Certificates-With-Anaplan/ba-p/49116) but while we are trying to upload the certificate into the anaplan (with only public certificate) we are getting an error like "email…
Excel Add-In Licensing
Hi All, We would like end users to be able to use the Excel Add-In to access Anaplan modules, so they can build formatted reports using that data. Am I right in assuming that these users do not need to be Workspace Admins with a Model Builder license, as long as they are simply accessing the data in pre-built modules (i.e.…
Excel Add in
We have a reports pack in excel which used the excel add in to link to various Anaplan modules. I recently created a copy of the model to run a scenario in but am not able to change my reports pack to link to this model rather than the usual live one. Does anyone have any experience of how to change which Anaplan model a…
Does the Anaplan styling in the excel add-in work?
Hello, Does the Anaplan styling in the excel add-in work? I have connected to the same module twice: first with 'Apply Anaplan Styling' option selected and second time with this option de-selected. I do not see any difference with the table display. Anaplan styles do not seem to be showing:
Updating Anaplan Connect 1.4.2 documentation to align with example batch files
Hi all, I recently updated to version 1.4.2 of the Anaplan Connect Client. I noticed that the format of the examples listed in the documentation is different to that of the example batch files provided in the download. I was having difficulty getting the script to work when following the documentation instructions, but as…
Add In for Microsoft Visio
Hi Anaplan, It would be very useful to have a Microsoft Visio Add-In to populate diagram and reports. Thanks, Usman
Excel Add-In 3.2 Log in Issues
We are experiencing access issues with the new Anaplan Excel Add-in Version 3.2. When trying to log into the Excel Add-in (regardless of whether a browser window is open), we are receiving the following error message: "Your session has been logged out. It is recommended that you close your browser to complete the…
Anaplan Architecture
Today I appeared for an interview, they asked me:- What is an Architecture of Anaplan? I wasn't able to reply. Someone please help me with this question.
Password protection to Excel Add-ins
hi, we've got users who have been asked to increase the security of the data they hold. They currently use Excel Add-ins, and tried putting password protection onto their spreadsheet. However, the data uploads failed with password protection activated (even though they'd already opened the spreadsheet with the password).…
Excel Add-in v3.2 - Boolean values
Hi all, I am having an issue that seems to be a result of the new v3.2 add-in update. Previously, where boolean values were being pulled from the excel add-in, excel would automatically recognise them as general formatting and they would be activated and process the cell as a boolean. Now it seems the values are being…
User Access Creation Control
Hi, How can we restrict the users having modeler access so that they should not be able to add users to the workspace except a few ? The user addition access should be given to few users and restricted for others. Is there a way to do it ?
Case Study 299 HR planning costs
So for the HR Planning Costs dashboard there is a module where you can input social security, pay raise % and pay raise date and that module affects the details of each employee module. Is there a way where the social security, pay raise % and pay raise date module does not affect every employee, whereas I can choose which…
Cannot Install Anaplan Excel Add-In - Misleading Error Message Displayed
Hello, * We are struggling to download the Microsoft Excel Add In - when trying to do so we get the following message:* The Anaplan Excel Add-in requires Microsoft Excel 2016 or 2013 or 2010 (32-bit of 64-bit) to be installed. * This is misleading - the documentation states that Office 365 is supported…
New UX option not visible
HI, even with page builder access/workspace admin access I am not able to see the new UX option in menu Is there anything i am missing?

Extensions

Discussion List