I have three separate cross tab table data in a workflow. I want to export each cross tab output into each separate sheet in single excel file. So whenever I'm running this workflow those three sheets need to be overwritten.
Thanks for your answer. I have added the block tool before the report however your suggestion works.
I have mentioned my workflow below,
@troy_mech
I would suggest just adding an Output Data tool after each Cross Tab, and specify the same directory / filename for your desired Excel output, and then just configure the sheet name immediately following the ".xlsx" in your output fullpath to be "|||SheetName" (renamed to whatever sheet names you need.
Using a Block Until Done between your Cross Tabs and your Output Data tools will ensure you do not encounter any errors from trying to write multiple outputs simultaneously for the same file.
See attached for example - hope that helps!
