Excel add-in save & refresh: possible to fill line item data with formula's in excel?




Using the Excel add-in, I am curious whether it is possible to auto-populate line item data using formula's in Excel. Can anyone tell me if it is possible to set this up and if so how? 


As an example: consider a module linked in Excel where cell A7 contains a line item with B7 a number that is editable. Is it possible to create a set-up where B7 is automatically filled by e.g. a sum of non-Anaplan related data from somewhere else in the Excel file? 


Kind regards,



  • Hi @JulianSteenman,

    Yes, it is possible, but after refresh formula will be wiped. So you might consider a macro that will add formula back after every refresh.