Update the value in Excel output without changing the Column's in between

[Vishal_95]

Hello,

I am designing the workflow and the output of it is "Excel" file. The Excel sheet has multiple column's which have linked with formula in the workbook & I would like the Alteryx output to not alter these column's but paste the output only in particular column's only which are not together. 

Can someone suggest a way to paste output in particular column's without making any changes in the formula.

Thank you in advance 😊

[davidskaife]

Hi @Vishal_95 

In the Output Data tool there is an option to 'Specify a range (cells, rows or columns) when outputting to excel, you will be able to update a column, or cell range using this option - remember to change the output option to 'overwrite Sheet or Range' if that is what you need.

Hope this helps!

[RolandSchubert · Accepted solution]

Hi @Vishal_95 ,

in the Output Data tool you have the option to specify a range the data is written to. You have to exclude the range containing formula cells and maybe it is necessary to have multiple output ranges.

Let me know if it works for you.

Best,

Roland

[Vishal_95]

Thanks Roland, It worked😀