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,