Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Overwrite Sheet Range Corrupting Output File

HunterH
6 - Meteoroid

Hello All - 

 

I have created a workflow that writes to a specified range of an .xlsm - however, more times than not, the file will end up corrupt. The thread below is the same exact issue I am having.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-File-Corrupt-After-Writing-to-Ex...

 

This thread mentions it was a bug that was fixed in 2020.2, but my enterprise is running 2020.4 and I am still running into the issue. I have tried with the 'skip field names' box checked and unchecked with no luck. It will run smoothly maybe 1-2 out of every 5 times. 

 

Is this still a known issue?

Thanks - Hunter

1 REPLY 1

Try to add "Block Until Done" before render/output.

 

arnel_de_guzman12_0-1636368014858.png

 

Labels
Top Solution Authors