Output tool

Question

Hi,

I have used block until done tool to write multiple output into same excel file as indicated in attached snapshot. The issue is I tried renaming the sheet names instead of having it as sheet 1,2,3 but the output includes 6 tabs which is sheet 1,2,3 and exact duplicate of those sheets but named sheets. Please see attached file. Is there a way to eliminate additional sheets and just have named sheets? Thank you!

Output_tool.docx

BrandonB · Accepted Answer

Just delete the existing Excel sheet and then run the workflow again. The output tools are set up to just overwrite the sheet names that have been specified, so they won't touch the existing ones. If you delete the file and run the workflow it will create the sheets that you have specified.

DiganP · Accepted Answer

@aparna0208 If the information in the existing file is created by the workflow, I would just delete the excel file and run the workflow. Make sure in the output data tool, you have Overwrite Sheet (Drop) set for all the output data tools. This will make sure that specific sheet is updated at runtime.