On many of my workflows, I keep getting the "Unable to open for write [...] The process cannot access the file because it is being used by another process (32)." when I try to write multiple tabs to the same Excel workbook.
I've tried strategically dropping my tools so that they all have sequential IDs, using the block until done tool (which I clearly don't know how to use properly), and even a parallel block on another workflow. What am I doing wrong?
Solved! Go to Solution.
Additional suggestions can be found here: https://knowledge.alteryx.com/index/s/article/Error-writing-Excel-file-to-Shared-Drive