Hi All,
I just wanted to understand few things about excel add-in feature in anaplan:
1. When I use pivot and filter to generate a view in excel using excel add in through anaplan and later the list which has been filtered in my excel ammends or changes in the module(e.g a new item has been added to the list or an existing item has been removed from the list) then how will the changes be reflected. Do I have to select that new list item in pivot and filter option to make it visible in excel or will it automatically start appearing. Secondly, if the list item has been removed from the list during ammendment then will it show me an error on clicking refresh button or will that list item automatically disappear?
2. When a new line item has been added to the module will it automatically start appearing in the module or will it have to be selected in the pivot and filter option to make it visible as I am filtering out the line items and showing only specific line items in the excel sheet.
3. I had created my excel worksheets using excel add in but now that model was copied and archived and currently we are using the unarchived version of that archived model. So, whenever I click on refresh button this gives me an error. So does it mean that the connection no longer exists and I will have to create new worksheets?
4. Once I have used pivot and filter and have saved my worksheet so whenever I refresh it or login and log out from anaplan through excel addin, will my format be always preserved?
5. Any kind of formula (using Vlookup) or formatting in excel applied will it be preserved always?
I'll be very thankful to you. If you could provide me the answer of the above mentioned questions.
Thanks in advance.
Solved! Go to Solution.
Most of the answers are hidden here.For Question 1,2 4 and 5 if you check all these boxes in your Excel Add in settings, it will automatically pull the list items, keep your formatting and keep your formulae intact. There is also no maintenance on deletion whether list items or line items.
For Question 3: Yes I think so. Archiving makes it lose the connection but let me loop @MagaliP to confirm it
Hope that helps
Misbah
@CommunityMember131357 It will be automatically pulled in and you dont have to do anything else apart from refreshing the sheet.
Exactly, just adding the links to the ideas: Ability to switch models in the Excel add-in - similar to this new idea