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!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.