Hello everyone,
I’m currently facing an issue with my Alteryx workflow. I’m trying to input different files and send them to the same Excel file but in different sheets using the ‘overwrite sheet/range’ option. However, it doesn’t seem to be working as expected.
The challenge here is that I can’t use the ‘block until done’ tool because these are different flows, but I still want them on the same workflow. I was hoping to use this workflow with OneDrive output, but it doesn’t seem to work, even when I try locally.
Does Alteryx not support this functionality, or am I missing something? Any guidance or suggestions would be greatly appreciated.
Thank you in advance for your help!
Error: Output Data (11): Can't open file: C:\Users\.......................xlsx: The process cannot access the file because it is being used by another process. (32)
ps: (no other process is using the file, no user is connected nor excel open)
