Append to existing sheet is not working

[yunjung]

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?  

[messi007]

@yunjung,

As you selected keep formatting you have to add a rang after the sheet name:

Below an example: Start appending from cell A1:Z

Let me know if this solve the problem.

Regards

[yunjung]

@messie007,

I followed your instruction but it still doesn't work. I also unticked the "preserve formatting on overwrite" and removed the sheet range but sheet is not updated. 

[pedrodrfaria]

HI @yunjung 

Are you able to share the workflow? 

I attached an example that is working if you want to use as reference. First need to create the file and then change it to append to the existing sheet.

[yunjung]

@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. 

[HeatherPrice]

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

[Emmanuel_G]

@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"