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.
... View more