Can the excel formulae be retained if i filter and rewrite the datatable to excel?

Help
#1

Hi.

I’ve a excel sheets with columns A, B, C, D. in which formulae are embedded in the first row. the requirement is if B = “Expense”, remove the rows and for the rest of the rows the first row formula have be expanded for the rest of the rows.

Problem 'm facing is when i filter and write the datatable back, all the formulae are missing. Only values are found.

#2

Yes, but you must use Excel Application Scope activities to retain the formulae. If you write a formula in a cell using the activities used in this scope, the formulae will be retained.