Replacing Data in Excel Table

[pvell322]

Hi Community,

I have a report that I need to generate using Alteryx. There is an Excel table to which I want to replace the existing information with the data I generated in Alteryx. Every time I go to output it to that sheet Alteryx just creates a duplicate sheet and appends the new data there, leaving the current data in its place.

Does anyone have a solution as to how I can replace the existing data with the new data?

Thank you!

[Luke_C]

@pvell322 

Can you share a screenshot of your output tool configs?

[davidskaife]

Hi @pvell322 

The default setting for outputting to Excel is 'Create New Sheet', change this to 'Overwrite Sheet or Range', or 'Overwrite File' if needed