Thank you for the quick replies, everybody. For the record I am aware that using excel application scope works for what I am trying to achieve. The problem is that I am for each iteration of the loop excel is opened and closed in the foreground which makes the process incredibly slow. This is why I am trying to make the workbook approach work. It is much faster.
I suspect that the in some way the previous iteration in the loop is interfereing with the current iteration. Is there some kind of “Delay” or “Wait for …” I can use?
By the way the activity that causes the issue is the “write cell” activity in this “Transpose” workflow: