Writing to existing Excel file with extra columns, corrupts file

I have an Excel spreadsheet that I want to overwrite. This spreadsheet has two extra columns at the end with formulas in them.

I'm using:

File Format: Microsoft Excel (*.xlsx)

Output Options: Overwrite Sheet (Drop)

Append Field Map: By Field Name

When I do this, and try to open the Excel file, it tells me it's been corrupted.

If I have it write to a different tab without the extra two columns, it opens fine.

Is this normal behavior?

Output

Accepted answers

Enter the column names in the Sheet exactly as the columns you're writing from Alteryx, then Select the columns and define them as a range.

Change your output option to Append existing sheet and instead of specifying the sheet name, specify the range name instead.

That's a bit strange.

Does the spreadsheet have other Sheets that you need?

If not, try Overwrite File option

If I do the Overwrite File (Remove), won't that remove the two formula columns as well? Because they aren't in the Alteryx output file.