How to add multiple sheets in single excel file

Hi, I'm getting an error while trying to insert my filtered data in different sheets of same single excel file. Can someone please help me to resolve this error message. Error msg is: "Error: Output Data (24): Unable to open file for write: C:\Users\X01319157\Documents\SanjayV\Operations\Trade Substansiation\1st Rec Pune Discovery\Discovery DD MMMM YYYY - Modified.xlsx Error Opening file: C:\Users\X01319157\Documents\SanjayV\Operations\Trade Substansiation\1st Rec Pune Discovery\Discovery DD MMMM YYYY - Modified.xlsx
: The process cannot access the file because it is being used by another process. (32)" Attached is my code so far. Wanted to segregate data in 3 different sheets. Thanks

Discovery Rec.yxmd

Accepted answers

Emil_Kos

Hi @SanjayVyas,

You need to use block until done tool.
I have updated the workflow. Please let me know if this solution worked for you.

Discovery Recv2.yxmd

All comments

Emil_Kos

Hi @SanjayVyas,

You need to use block until done tool.
I have updated the workflow. Please let me know if this solution worked for you.

Discovery Recv2.yxmd

SanjayVyas

Emil_Kos . I'm new to Alteryx and this forum as well and I might have asked simple questions. However, 1 thing is for sure here is, you will get the absolute solution within very short span of time. Thanks a lot for such a quick resolutions you guys provide. Really appreciated !!

EdP

Additional suggestions can be found here: https://knowledge.alteryx.com/index/s/article/Error-writing-Excel-file-to-Shared-Drive

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703