How to add multiple sheets in single excel file

[SanjayVyas]

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

[Emil_Kos · Accepted solution]

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.

[SanjayVyas]

Hi, Thank you so much for your quick solution on this @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