Overwriting existing spreadsheet when no data

bkgators

I have a workflow that is parsing bad data into separate tabs in an excel workbook. The workflow runs fine, however each week I need the most recent run to overwrite ALL data within the previous file. It does appear to overwrite the data, but it doesn't actually remove all the data that was there previously. If the prior report had 8 rows of data and the new report only has 3, the report shows 8 rows of data, with the first 3 being the new ones.

How do I solve this and retain formatting?

Workflow_example.PNG

skeen503979

@bkgators 

You will likely need to select the "Overwrite File (Remove)" option so that a brand new file is created each time rather than attempting to edit the existing file.  The option you have selected (Overwrite Sheet or Range) will only update the sheet as far as the new data goes.  That is why you're experiencing the problem of today's 3 rows of data only updating and still seeing yesterday's 8 rows that remain unedited.  Changin your output option (pic below) will eliminate that problem for you.

May the data be ever in your favor.