Block Until Done tool not respecting order of operations within macro?

[Frndly]

So I have a macro that I created, it's basically a block until done tool with an additional input, it waits for this additional input before processing the records from the main input(M anchor) further. It worked before, but for some reason doesn't work now, as output tool can't write a sheet due to file being open. What could've changed and what could cause this? Macro is supposed to work regardless of how both of the inputs look. Macro and screenshot of the workflow attached.

[PhilipMannering · Accepted solution]

The Block Until Done Tool has always been a bit temperamental. I don't know if sticking it in a macro might obscure the passing back of metadata to tell the Block Until Done to continue ¯\_(ツ)_/¯ (and it may have been working before simply because the number of rows were small enough that you didn't get a conflict writing to the same Excel. I would definitely try appending a count with block until done (i.e. not using a macro) or, better still, use control containers.

[Frndly]

Sad to hear that, well, thank you anyway! It does work properly without being a macro.