One of the biggest Issue that the Alteryx Community Users face is that when we provide a Excel File as an input and Run it through a Workflow in Alteryx, and save the output into a new Excel File, then the existing Formulas which were present in the cells of the Original Excel File are LOST/ NOT RETAINED and only the Values are copied to the New Excel File.
So Here I have created a Workflow which will help you to understand how you use the XML Properties of the Excel File and retain the Existing Formulas in your newly created Excel File.
Here I have used a Demo Input File but I have provide Documentation for each step which give you guidance to Tweak the workflow as per your input data and needs.
Open to Feedback.
Do Like & Share if this Content was helpful.
Regards.