Excel Named Range Overwrite Problem

[DustinBettler]

I am trying to solve a problem exporting a file from Alteryx to a named range. I have the whole process going but the issue is that I want to write over the same file all the time and appending, just adds the new data to the existing file. I would like to overwrite it all beginning in row 2. So keep the headers and every time I output to the named range, overwrite what's in the worksheet leaving nothing but my new data. Any suggestions would be great!

[Luke_C]

Could you share the configuration of the output tool? I think the below configuration should work for this but tough to say for certain without a little more context.

[DustinBettler]

Is there a way to set Alteryx to begin entering data at a certain row on a sheet, rather than in a named range?

[Luke_C]

Yes, in the output tool something like this:

FileName.xlsx|||TabNamel$A7:AA10000