Overwriting Formulas in Output Range

[prakash-shetty]

I have a workflow which overwrites the data in approx 250 files by using change entire path Output option. Problem is that when end user erroneously  update formula in the output range, Alteryx is not able to proceed with the updates & give an error "Unable to overwrite a cell that contains a formula".  Each time there is a formula in the range Alteryx stops & I need to manually delete the formulas from the output file and rerun the workflow. Considering the volumes of files and frequent intervention due to this error it is taking lot of time to execute Alteryx workflow. 

Do we have any option wherein Alteryx can overwrite the formulas in the data range or ignore the error & continue with data updation for rest of the files & provide with error log with list of files for data not updated due to this issue. 

I am attaching a simple workflow wherein output is getting updated to different test files. If you update formula in output range in any of the test files you should be able to see the error. 

[prakash-shetty]

Thanks @AkimasaKajitani  for all your help.  One more thing to highlight. In output files I don't see column header updated. I have tried unchecking "Skip Field Names" but still I don't see Column header updated in the output file. 

[AkimasaKajitani · Accepted solution]

Hi @prakash-shetty 

I changed the Skip Field Names option from check to uncheck, it works well.

Output of checked

Output of Unchecked

Please use attached macro.

[delrocd]

@AkimasaKajitani There are still errors. The macro does not ignore the error