Output tool

[aparna0208]

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!

[BrandonB · Accepted solution]

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 solution]

@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. 

[aparna0208]

When I delete the file and run the workflow then it works. And yes, I already have Overwrite Sheet (Drop) set for all the output data tools. Thank you so much for the quick response:) @BrandonB @DiganP