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

JulianSteenman
JulianSteenman
in Integrations and extensibility

Hi, 

 

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,

Julian 

Tagged:

Answers

  • SAMVAL
    SAMVAL

    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.

Categories