Get rid of formula in excel and leave only its value

[Palaniyappan (Forum Leader)]

hope this would help you

Fastest way to write an excel formula into an entire column

Hello everyone, Is the Write Value activity the fastest way to write formulas in Excel sheets? I’m asking you this because as far as I know when we are using this activity, we need to iterate between the excel rows in order to fulfill each row with the proper Excel formula, which means that it takes some time if the excel sheet contains too many rows (an average of 1 second per row, to write a new formula on a specific column). If I use the Write Range activity, is there a way to accept f…

Cheers @dias97