Extensions

Applying one Pivot Filter to multiple cloned connections with the Excel Addin
I have one Excel workbook with multiple worksheets and I want to apply one Pivot value filter (e.g. Time - May 21) to all the worksheets. Rather than updating each individual worksheet "Time Value".... When I used reference this value across worksheets it is blown away after the refresh.
Excel Extract in mail attachment
Hi, I want to attach Saved view as a mail attachment and send it to clients. We dont want to show other module data to them so excel add-in doesn't work. So do we have any solution for that. Regards, Ajinkya S
Excel Add In: remove a connection and multiple connections in one sheet
Idea 1: Currently we have the option to create Read / Read-Write Connection. But when I no longer want an active connection on a sheet, i am not able to remove it. This limits my ability to add a new connection or replace connection on the same sheet. Idea 2: Also, we cannot have more than one connection on a single sheet.…
Excel and Powerpoint add-ins for Office Online
As well as the existing Excel and Powerpoint add-ins for on premise/desktop versions of Office it would be good to have similar integrations available with Office Online which deliver the same functionality.
Excel Add-in: Add Compatibility for Apple Mac computers
Add Compatibility for Apple Mac computers. The Excel add-in for Excel only works on Windows PC's right now. Our parent company only uses Mac computers so they cannot fully utilize my reports that use the Excel add-in.
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
The Level of Statistical Product Forecast
I'm Trying a statistic forecast. And there is below statement in this site (https://community.anaplan.com/t5/Best-Practices/Statistical-Forecasting/ta-p/40359). * Multi-Level Forecast: Ability to forecast at different levels of the product hierarchy (i.e. Top Item | Customers, Item and Brand level can all have stat…
Control Weekly Seasonality
Hi. I have a question about weekly statistic forecast model. In this model, can we control the difference of weeks in another year? Suppose that, some food's demand will increase dramatically on 01/01(New Year). ・2014/01/01 - Week 1 FY14 ・2015/01/01 - Week 52 FY14 In this case, I think we cannot control the Weekly…
Addin Excel : add options like Include Empty rows
Hi, End Users want to have the possibility to include or not include Empty rows like options enable in Export. Best regards,
Excel Addin : Display Properties list
Hi, In the excel add-in, have the possibility to display the properties of the lists and not only the display name. End users need access to code or parent for exemple. Best regards
Ability to select a specific Page for entire Workbook when many Excel Add-in Data Pulls are Used
It would be great if we could set an overall workbook time period that would allow us to set the time period we or any "Page" selection for workbooks with multiple Anaplan Excel Add-in pulls. We would also still need the ability to change individual worksheet/tabs data pulls. For example, we may have a workbook where 90%…
excel add-in : Select a level without creating a view
Hi, A new idea for the excel add-in is the possibility to select a level for a hierarchy. For exemple, I have a module with the level 8 for organization, I wish have the possibility to decide to show only organization level 7 or 6 without level 8. Best regards, Carine B.
Excel Add in inheriting flow from the web UX
Does anyone know if there are plans for the Excel add in to more closely align with the web UX? For example, a few things that would be a big help in my opinion: -Allowing user to select a dashboard by name, which would then then filter down to show only the modules on that dashboard (obviously this wouldn't pull KPIs or…
Error message : Opitmizer
I tried Optimizer model and run the optimizer Action. But this error message has appeared. "This workspace is not entitled to Optimiser." We need administration?
Optimizer Pricing
Do anyone know about the cost and time it takes to enroll Optimizer functionality for a project
Not able to open Excel add in file with 4.2 version
Hi, I have installed Anaplan Excel Add-in 4.2 version. But now I am not able to open files which were prepared on Anaplan Excel Add-in 3.4. IF I open a file it closes down automatically. What is the workaround for this issue? Regards, Ajinkya
Anaplan Excel Add-in 3.4 Error
Hi All, A colleague of mine is working with a report in Excel using the Anaplan Add-in version 3.4 and is receiving the attached error even when opening the spreadsheet. On other occasions when she clicks on the Anaplan ribbon in Excel the spreadsheet crashes without an error message. She had issues with Excel crashing…
Excel Add-in: updating cells with Dynamic Cell Access and have a list format
Possibility to change data in cells with Dynamic Cell Access and a list format with a read/write connection in the excel addin
Excel Add-in 4.0 - Add ability to Refresh all tabs at once to the same page selector selection
Hi, I have a workbook with about 20 Anaplan-connected tabs. We have >100 properties in our portfolio. Each tab connects to a different module in the same model and all modules have the same page selector list chosen in the dimensions, being our list of properties from our hierarchical list. Right now, if I want to switch…
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…
Excel Add-in: drag and drop dimensions, view line item formula, keep only/exclude
Please add the following features into the Anaplan Excel Addin - 1) Ability to pivot by dragging and dropping members within the spreadsheet rather than clicking on pivot and filter. 2) Ability to drill down a hierarchy by double-clicking in the spreadsheet 3) Ability to extract just one data intersection using some…
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 😞 :

Extensions

Discussion List