Alteryx Excel ranged output deleting first formula column

[Shahbaz_Chase]

I am trying to populate values from columns A2:F in an existing Excel file from Alteryx and the remaining columns(G:I) are formula columns:

A	B	C	D	E	F	G	H	I
20/01/2022	2	Text1	20/01/2022	10.02	12.10	A vLookup formula	Another vLookup Formula	=E+F

In above, Alteryx runs successfully but when I open it throws "We found a problem with some content.." error. Upon clicking 'Yes' and opening the repaired file, I notice the First formula column (G) is blank while the rest are fine. If I remove G column and rerun Alteryx, it shows same error and whichever is the first formula column, it becomes blank.

Adding additional blank column between columns F & G also didn't work.

Can anyone help me in identifying the reason for this and resolving this issue?

Note: Unable to attach anything due to system restrictions.

[taylor_butler · Accepted solution]

Hi @Shahbaz_Chase, 

When outputting to Excel, you can specify the range of columns within the spreadsheet that you want populated and set the Output Option to "Overwrite Sheet or Range". This will only overwrite the data within the range you've specified, but will keep the formulas in the additional columns intact. 

Hope this helps!

Taylor