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

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?

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.