Excel
Excel
Discussion List
- Hi All, do you know why I receive this error when connecting a view through Excel Add-in? Thank you, Joana
- Hi, Is anybody else experiencing issues with the Excel Add -in when using Single Sign in? I can only access it when using the old sign in method.
- Hi everyone, I have 2 questions about excel add in Refresh Multiple Connections function: Does the refresh multiple connections functionality refresh only the dimension selected on the selector (for e…
- I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally w…
- I have a saved view which applies a sort-order format to the list dimension in the rows. The view also filters out items which have a zero balance. The sort order and values change depending on the di…
- Hi all - hoping for some guidance here… I'm looking to roll out the use of Anaplan Excel Add In's so people can retrieve information from the data hub without having any write access. I was wondering …
- Hi all - hoping for some guidance here… I'm looking to roll out the use of Anaplan Excel Add In's so people can retrieve information from the data hub without having any write access. I was wondering …
- More information about versions can be found here. Version Information for Excel Add-in
- Hi Anaplan Community, I have a question regarding the Excel add-in. I was reading about refresh conflicts on this Anapedia page. If you break a connection's cell range, it may not refresh properly. To…
- Allow user to specify which browser to use as an option in Authentication settings for facilitating SSO sign on — even if default is embedded browser, having the flexibility to select a different opti…
- Using the latest Excel Add-in, it appears this is using an embedded version of Edge browser (version 95.x). Our organization has blocked this browser being used due to the age of the version. Is there…
- Hi, We are not allowed to import data from a saved custom view and we are never allowed to pivot a template from saved view. So when are we allowed to pivot a card? Thanks.
- Hello! I'm using the excel add-in and, unlike when I export from the model, I am unable to flatten my data and retain all the row labels (A below). Instead they get grouped like they do in the module …
- Hello guys! Can anyone solve this? I have a module with 60 pages, and I need to export each one of those pages into a different excel file. Does anybody know a way of automate this process? I mean, fa…
- Please could you create a new button/feature in the Excel Add in to allow switching to design view. Excel is a great tool for presenting and autosizing column widths and for working on Module layouts …
- Hello, I am using the Anaplan Excel Add-In to organize my data in Excel. The issue is that when I reorder the columns and then change the context selectors, the columns that were moved no longer updat…
- 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 …
- 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 proble…
- 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 …
- 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…
- 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…
- 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
- 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
- Do not change the module name in Anaplan as this may break the connection. Best Practices article Best Practices About Excel Add-In