-
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…
-
Refresh failed due to an unexpected error - Excel Add in reports for some of the users.
Hi, There are some Financial reports that has been created using Excel add in functionality. Some users are having issues while refreshing it and getting error message. Whereas others are fine with it. A few users are getting this error for some of the reports, but they are able to refresh other add in reports. Could…
-
Google sheets add on is live!
Delighted to see the latest addition to our Extensions family is now live. For full details of our Google Sheets Add On check out https://community.anaplan.com/t5/Extensions-Knowledge-Base/Version-Information-for-Google-Sheets-Add-on/ta-p/91919
-
PowerPoint Add-in: Installation requires elevated privileges
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…
-
Image Link on share folder
Hello everybody, I would like to insert a picture on a page. For that I created a text link Line Item. This link is connected to a picture on our MS Teams share folder. Even though I do have the access to this Teams folder, the image on the Anaplan page will not be shown. Can somebody help me? Many thanks
-
Anaplan and Power BI - It's here!
Finally! It's here. For those of you that use Power BI to supplement your visualizations, you're in luck! https://community.anaplan.com/t5/Releases/Announcing-the-Anaplan-Connector-for-Power-BI/ba-p/89942 Brilliant! Nice job @MagaliP Personally, I give you the most improved aspect of Anaplan award for 2020. Am I allowed to…
-
Refresh Function in Excel Add-in should provide option to submit changes
Description: If a user changes data in a read/write view of data in Excel via the Anaplan Excel Add-in and then subsequently clicks on the "refresh" button, the Anaplan interface does not inform the user of any changes that have been made to the data before the view is refreshed. This results in any changes being cleared…
-
Excel add-in, Date time settings
Excel Add-In error: Refresh failed due to unexpected error. Found out that when the Excel template is created with Regional settings [ ex. decimal symbol as Dot / . ] is different from your system settings [ ex. Decimal symbol Comma / , ] then the refresh fails and shows up unexpected error. This is solved as soon as the…
-
Gather 4 Clues to Find the Mystery Roadmap Item
The end of the year is fast approaching, and in the UK this usually means lots of quizzes (now done virtually, as opposed to at the pub). In June, I did a quiz about the Extensions, but many things have changed since then—so here is a new one for you to polish your knowledge about those products, as well as to discover an…
-
Disclosure Management Tools
Colleagues, hi! I was wondering if you can share your experience with different Disclosure Management tools that you've used so far in your organizations for the purpose of IFRS / US GAAP full pack preparation. I've heard from my colleagues that there is expected to be delivered a new type of page but, personally, I doubt…
-
Excel Add Ins
Our Extensions provide a powerful way to connect your Anaplan environment to MS Office and so share Anaplan data across your wider business community. Details of the latest version information around our Excel Add In can be found here;…