Excel Named Range Overwrite Problem

Question

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 · Answer

Yes, in the output tool something like this:

FileName.xlsx|||TabNamel$A7:AA10000

DustinBettler · Answer

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 · Answer

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.