I have a report consisting of multiple tables (created with the Table tool) unioned together and made into a single excel worksheet (Layout and Render Tools). This is successful, but only when there are no other sheets in the destination xlsx file. If there are I receive the message "Excel found unreadable content in... Do you want to recover the contents of this workbook?..." When it is repaired the Report tables tab is still ok, but some of the other tabs are missing.
Block Until Done tools don't seem to be helping, so not sure was the cause is.