Retaining input structure in output

[praneshsapmm]

Hello All,

I have this requirement as mentioned below . 

I have excel 'A' which contains lot of information with various formulaes & queries which is very complex . 

I have another two file B & C which will pass through certain workflow and the result of which must be updated into excel A . 

Now the final output must be excel A with updated information from B & C . But when i generate the output all the formulae & queries are lost . Teams cannot work on the file without these formulaes . 

Is there anyway to retain the original structure. 

Thanks

[PhilipMannering]

When you output the Excel File, pick a specific Range,

And select Overwrite Sheet or Range

[atcodedog05]

Hi @praneshsapmm 

Additional to what @PhilipMannering  you can also specify from where the writing should start. By configuring output filename like below.

final.xlsx|||'New_report$C2:Z2'

Hope this helps 🙂