Rendered Excel Output Not Reading Formulas.

[tnkii]

Hi everyone,

When I output Excel formulas using a regular Output tool, Excel was able to read and convert the formulas into values. However, when using the Render tool to output to a rendered Excel, Excel was not able to convert the formulas into values and show the formulas as text (please see screenshot below) until I double click on the cell and press Enter.

Is there anyway for Excel to recognize and convert the formulas to values when output using the Render tool? I hope am just missing something.

Appreciate any help given. Thanks!

[DavidP]

Hi @tnkii 

As far as I know, you can't do that with the Render tool