Extensions

Synchronize filters across tables in Excel add-in
Add ability to synchronize filters across tables in Excel add-in. Working with the Excel add-in and extracting data from different modules, some of the filters across the different extracts overlap. A good example hereof is forecast cycle or specific versions. Currently, we have to change the forecast cycle in each sheet…
Integration with Google Docs
Google docs integration with Anaplan as we use Google docs like Excel.
Excel Add-in: Filtering options
Hi, The Pivot & Filter's Filter dropdown functionality does not operate how most people (generalizing) are used to dropdowns working in hierarchical list . Please see screenshots below. Here I have regions, manager names, apartment properties, and floorplans coming from anaplan in a hierarchy. When I uncheck an item at a…
Excel Add-in - Add Ability to remove connection from tab
Hi, Currently there is no button or feature to remove an Anaplan connection from an Excel tab, only to add a new one or modify an existing one. Please add a button to delete a connection. Thanks,
Excel Add-in: refresh all connections in a workbook at once
Hi It would be great if you could refresh all connections at once in one excel workbook. Currently, each sheet has to be done manually. In some of our excels we use for reporting, I have 15-20 sheets as currently you can only have 1 connection / 1 sheet. This would help a lot in efficiency. Thanks Kinga
Google Sheets/Google Slides Add In
My team at AdRoll along with many other customers that I know of spend countless man hours every month/quarter exporting our Anaplan dashboards into google sheets and then into google slides just to get data in front of our ELT. I have seen this in this forum before which I believe speaks to the level of impact it would…
Excel Add-in: remove 1m cell limitation
Hi, Anaplan connection to MS Excel is limited to 1mil cells only. This considerably limits as to what we can do with auto update of data straight from Anaplan to MS Excel. Removing the ceiling on cell count will really boost the efficiency for data analysis. At the moment, users have to either reduce the selection by…
Excel Add-in 3.2: increase cell extract count
In the current version of the Excel Add-in, it is not possible to create a connection to a saved view or module with a total cell count of the dimensions (rows x columns) greater than 1 million. Any saved views with hidden line items or filters applied will not have an effect on the view size and will therefore not…
Excel Add-in: Drill Down and Drill through to Transaction
In Order to effectively compete with Oracle, it would be beneficial to have Drill Down and Drill through to Transaction available in Excel.
Indicate the source module in a worksheet
Our users need to know the source module in a worksheet in order to be able to use the Addin Excel extension. It's possible to see it in a card on a Board, it is regrettable not to offer this information also in a worksheet. Board: Worksheet 😞 :
Excel Add-In
I have an excel sheet with multiple connections to Anaplan that run off saved views with filters on the lists I have a problem that when some sheets are refreshed it won’t allow them to be updated because it claims the "dimensions of the view has changed". It then requires you to update the pivoting, even though no…
Anaplan Powerpoint Add-in
Hi, Is there a reason why all the saved views from a deployed version do not show up to add as a connection in the Anaplan PowerPoint Add-In? I am unable to select a module that I want to export to the PowerPoint.
Power-Point addin
: Hi, Please help me out with this error while refreshing data in Anaplan Powerpoint Add-in. Exception details: level: 0 message: Sequence contains more than one matching element trace: at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) at…
PowerPoint Add-In
Hello, Is there a reason why all the saved views from a deployed version do not show up to add as a connection in the PowerPoint Add-In? I am unable to select a module that I want to export to PowerPoint.
Anaplan and Google
Hi Anaplan community, Last month, Anaplan published an interesting video about Google Cloud. I wanted to learn the study case or training materials that explain Anaplan functions in Google Cloud, AI & ML. I need advice for the Anaplan community, please. Thanks,
How to Edit Status setting in Informatica cloud under Monitor tab
My teammate can see a resume option when she hovers over the status under all jobs in the Informatica cloud. I don't want to restart my job but unfortunately, I cannot see that option.
Ability to avoid refreshing deleted rows/columns in Excel
Description of the enhancement required: option to not refresh the full view in Excel add-in An example of the enhancement: If you delete a column or row, don’t re-add that row/column when refreshing A story for why you want the enhancement (How would it help your business process?): custom view’s can be created in Excel…
Excel Add-in: pivot and filter a saved view (like we do with a module)
Hello, I'd like to suggest adding the same functionality when adding a new connection via saved view that there is when adding via the default view. Right now the functionality is very limited when adding a saved view in comparison to the default view. I'd like to understand why this is and if it can be changed so both…
Adding to a dimension in anaplan being dynamically reflected in the view for Excel add-in
Description of the enhancement required: Excel add-in be dynamic for changes in the Anaplan view. An example of the enhancement: adding to a dimension in anaplan being dynamically reflected in the view for Excel add-in. A story for why you want the enhancement, (how would it help your business process): The Excel add-in…
Ability to disable Update notifications in Excel/PPT Add-Ins
Description of the enhancement required: Allow disabling of Update notification in Excel/PPT Add-Ins. An example of the enhancement: An Administrator could determine whether End Users should receive the Update notification in the Excel/PPT Add-In. A story for why they want the enhancement, (how would it help their business…
Disable "CheckForUpdates" in Anaplan Excel Add-in 4.1
My organization would like to roll out the new Excel Add-in to a group of users that do not have administrative access to their work computers. Therefore, it is important to be able to disable the updates check during initialization of the add-in. I have determined a way to do this, but wanted to ask if there is a better…
Extensions
Hello, I am the Product Manager for the 3rd-party add-ons (Excel add-in, PowerPoint add-in, Google Sheets add-on). If you have questions about these, feel free to ask them here. All ideas for improvements can go in the Idea Exchange and you can add the link to your idea here for extra visibility. I am looking forward to…
Excel Add-in Connection -Refresh workbook fail
Hi, I created a Multi-Sheet connection (5 tabs). After reopened the file, I found Excel Add-in cannot find the module used when I try to refresh all tabs with one click. Could you kindly tell me how to solve this issue? Thanks,
Power BI connector - Invalid Credential
Hello, I followed the process "Anaplan connector Power BI Desktop" in order to see an export file in power BI. It worked the first time, but every time i reopened the file in order to see the updated export in power bi, i can't connect to Power BI because of "Invalid Credential", and i can't connect to Anaplan either. Is…
Anaplan Extensions: Building Reports in PowerPoint to Present User Stories
Recently, I interviewed Jared Dolich, a Principal Consultant at Columbus Consulting, about his clever use of Anaplan Extensions as a consultant in an Anaplan implementation project. Q: Tell us about yourself and your Anaplan journey Well, first, Magali, thank you for your interest! It means a lot to me to have the…
Send and Refresh Error After Upgrade to 3.4
After I upgraded my excel plug in to 3.4, I can no longer write back to a module. I can Refresh fine, but if I attempt to Send and Refresh, I receive a note saying "there was an error detecting changes." Has anyone else experienced this? If so, please assist.
VBA code to execute Excel Add-in toolbar commands
Hi, I am a new Anaplan user and am looking at using the Excel Add-in 3.0 to retrieve data into my excel-based reports. My preference is to automate report formatting and retrieves from Anaplan using VBA. Does anyone know if there are published Anaplan VBA commands like exist for Essbase? Thanks!
Unable to use Anaplan Add-On for Google Sheets
We are unable to use Anaplan Add-on for Google Sheets at our company (but we have been eagerly waiting for it as will be really useful for us) due to the following reasons: 1. It looks like it will not work with Classic SSO. We are not sure we have in-house knowledge to switch to & maintain Self-Service SAML. 2. Even if we…
Anaplan Power BI Connector - One Tenant?
Hi Anaplanners. I'm really enjoying the new Power BI connector but I'm having trouble accessing all the tenants I have access to. For some reason only one shows up. Does anyone know why this might be? @MagaliP I know connectors is out of the extension universe but maybe you know someone I can work with? I'm using the Power…
Releasing the Anaplan Add-in for Excel 4.0
The Anaplan Add-in for Excel is key for many Anaplan users, helping their business processes for reporting and ad-hoc analysis. We’ve made it even easier to take advantage of the Excel Add-in, with a seamless experience from installation to support. Version 4.0 makes it easier for anyone to install and upgrade the Excel…

Extensions

Discussion List