File not updated even the output shows No. Of records were written

[Parthasarathi]

Hi All,

I am facing an issue with Alteryx designer when I am writing my output to a excel workbook.

In designer output it shows No. Of records were written to the output file but file not updated, I am using a formula for the dynamic range to update the respective range alone

[Emmanuel_G]

@Parthasarathi  Do you select Overwrite File at line 3 in the Output options tool when you run the flow ?

[Kasia_Sliz]

Hi All,

I am facing the same problem. When trying to update Excel file (range specified, "Overwrite Sheet or Range", "Skip Field Names" and "Preserve Formatting.." selected), despite of receiving a message on number of records written to the specified range, the actual Excel file does not get updated. Any suggestion on how to deal with it would be appreciated. Thanks. 

[apathetichell]

1) are you also using a render tool?

2) do you have another output data which you are writing to the same sheet which overwrites the sheet

3) can provide a sample range you are using (filename|sheet range) and a screen shot of the alteryx message you are seeing when running your workflow?

basically the primary reasons this happens:

1) you are writing the data - but then you overwrite the data with another tool.

2) you are writing to a different file than you think you are.

3) you are writing to a different range than you think you are.

4) your data coming out of alteryx does not look you think it does.

5) you are writing to the correct file name and range - but in a different location.

things like that.