Looking to export numeric formulas into an existing Excel File.

[ebentrup]

I need to append to an existing excel worksheet, I have created a few formulas that need to be exported as numeric data and not string.  The string does preserve the formulas that are created but we need them to be numeric in excel so we can get the totals and sum of the columns.  When we export the formulas with numeric data only the value appends to the sheet and the formulas are lost.  The sheet will be modified using the formulas as multiple sheets are being read off of these formulas with sumifs and vlookups.  Any help would be greatly appreciated.

[ebentrup]

Thank you for the response back.  For now we are going to just use an excel macro to fill down the rows with the existing formulas.  Alteryx did mention that it doesnt work the way I was thinking of with the formulas being numeric and not a string value.