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


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.

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.