Writing multiple sheets simultaneously in same excel workbook

[234abhishek]

I have an alteryx workflow wherein I'm doing some data processing and trying to write into multiple sheets of an excel workbook. Now, I get the error that writing is not possible as the file is being used by another program.

How to avoid this error and make sure all sheets are written in the excel workbook simultaneously.

Thanks in advance! 

[aatalai]

Have you got the file path including file name and sheetname in one of the fields? If so use one data output tool with get file path from field, or is that what you've already been trying?

[apathetichell]

You cannot write to different sheets (or use mutliple output tools to write to the same sheet) in excel at the same time. Execl is not a database which supports concurrent transactions. You get around this by timing your outputs using block until done - and making sure that output 2) occurs after output 1) is done.

[Raj]

@234abhishek use block until done tool to first write data into your first sheet and then in next sheet .or look for a wait a second tool if you have access to it.

[cjaneczko]

As other have mentioned you can use the Block Until Done on each of the outputs. If your paths are not part of the same flow you can also use Control Containers in place of the BUD's.