Append range workbook changes =TODAY()+14 function

[MarkusI]

I have Excel file in which i collect information in a certain format.
That file is moved to another Excel file with append range.
One cell needs to have Excel function =TODAY()+14, but append range changes it to date.
This would be okay, but that another Excel collection will be processed later and it needs to have that =TODAY()+14 function.

[ashokkarale]

@MarkusI,

Append Range will write plain text values. If you want to keep the formula, you will have to use excel scope and update the cell formula accordingly.

Thanks,
Ashok

[MarkusI]

That works, but we would like to make our process without Excel activities because it makes automation process slower and we need license for our server. But if it is only way to make this process work, then we just have to live with that.

Thank you for your answer!