This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It sounds like you have a read write error because Alteryx is trying to write data to the same workbook at the same time. For these situations, I usually place a block until done tool somewhere in the process to ensure that Alteryx is only trying to write one worksheet at a time.
You can't write to different sheets within the same excel document because when alteryx tries to write one sheet it is locking the file whilst that process takes place, hence why you get the error when it tries to write another sheet.
I've had this issue myself before and I've written a blog about the options available.