Retaining input structure in output

Question

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

atcodedog05 · Answer

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 🙂

philipmannering · Answer

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

And select Overwrite Sheet or Range