Hello yet again.

This time I am experimenting with a complex Microsoft Excel document, its basically a calculation file that contains quite a lot of sheets, macros, references and formulas. Idea is that instead of sharing the excel document with the people that need to use it that I would just host it on our Flow, people would then have an option to fill out some published parameters in a flow app and then get a single excel sheet returned with their results (cutting out all the underlying datasheets and formulas and macros etc).

Or to sum it up: I have a complex excel with formulas, read that excel in FME, change values in cells in FME, write out an excel from FME that would then recalibrate/recalculate based on those changed values.

So I have figured out how to single out cells in the excel table where (basically using counter, and tester for that single number, link to attribute manager where the new value can be inserted to replace the old one, back to a FeatureMerger to put the new value into the whole sheet). That works fine and dandy.

My problem is when I want to write out the excel with the new value then it comes out all wrong, even if I just do an update it still changes the document in a way that all the formulas loose their references and the whole thing becomes unusable. The original file is 5.124KB but the updated one is 4.961KB and gives this warning when opened in Excel:

Any ideas if this is generally possible to achieve and if so what I’m doing wrong? Or maybe this is just a task that should be Solved with Power BI…?

With regards, Hlynur