Output error with Block Until Done tool

Question

Hey,

I try to write more then 4 sheets into the same excel file.

In order to avoid an error I chained multiple "block until done" tools, as show in the following screenshot:

But I still get the following error:

Output Data: Unable to open file for write: (File Path...xlsx) The process cannot access the file because it is being used by another process.

Can you think why ?

Thanks in advance! 🙂🌷

EdP · Answer

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

IraWatt · Answer

If you have any questions setting it up make sure to ask:) there are also some great interactive videos on batch macros on the community, well worth checking out.

IraWatt · Answer

Aahh okay I see the issue. In this case I would recommend a batch macro:

You pass it your sheet names then it removes empty columns for each one and updates the sheet name one at a time.

In order to get this working you will need to tell it to update the sheet part of the address:

And also format your input tool correctly

multi sheet.yxzp