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.
My workflow produces 4 outputs to 4 sheets in the same Excel file. They all have the same set up. 3 of them worked as expected except for the "Archive" output. Though the message said that records were written. The tab was missing in the Excel file.
If I deleted any one of other output connections, the "Archive" sheet would show up. That tells me the setup for the "Archive" output should be fine. Yet, when I reconnect all 4 connections, the "Archive" is missing again.
Is there any way I can resolve this issue? Thank you!
Just to close this thread out, we talked about this and the problem appears to have been with the sequencing of the blocking tools used to control when sheets are written to the various files. We implemented the blocking technique used in the Parallel Block Until Done CReW macro and that appears to have fixed the problem.