In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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