By using Excel Add In, can we do only data update in Module & Lists?
Or can we update formulas as well?
Thank you for your interest. You'll find all the information on this page to get started with the add-in.
You can only update cell data in modules, not properties/lists/formulae. If you are interested in this functionality, please raise it on the idea exchange with an example scenario of how you would use it.
Thank you @MagaliP