Write Range activity removes cell formula in Excel file and if i use write cell it will take too time to update as data is more

[chuan_ming_foo_from.tp]

In my automation, I made use of the Read Range activity to read some columns in my Excel file, update these columns and then write them back to the same sheet in the same Excel file using the Write Range activity. The update is successful but all the cell formula are removed after the update. Is there a way that I can retain all cell formula?

[Lak_Ui (Lakshmi)]

you may to use write cell activity instead of writing back the whole datatable using write range

[chuan_ming_foo_from.tp]

I used Write Cell activity instead and it worked. Thank you!