Append to existing sheet is not working

Question

I used "append to existing sheet" for my output and Alteryx runs without any error. However output file is not updated. May I know how I should resolve this?

image.png

Emmanuel_G · Answer

@yunjung ,

If you want the sheet of your excel file to update, you must select "Overwrite the file (delete)" so that the entire file is updated with each execution.

If you have multiple sheets and you want to update each one, in the output options of the Data Output tool, select "Overwrite a sheet or a range"

HeatherPrice · Answer

I have the same issue.

I did resolve it by deleting the original .xlsx file, taking the .bak backup file and converting it to the .xlsx original file by removing the .bak extension.

But it does seem to be an issue on append files in .xlsx

yunjung · Answer

@pedrodrfaria

I followed your instruction and it was working for the this flow. However, when I used the same approach to the other workflow (output data -> select existing file I would like to update-> Select sheet (existing) and range -> update "create a new sheet" to "append to existing sheet") I still get the same error.

Append to Existing Sheet_Test.yxmd