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

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 😊

Workflow

Accepted answers

RolandSchubert

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

All comments

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

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😀

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703