updating cell in excel

[adarsh2608]

in my workflow when i try to update a column to an excel which is already having lot of filters by using output tool . it is writing whole data instead of just updating a cell .

i tried all the option from the output tool

[grazitti_sapna]

Hi @adarsh2608 , Please try using the below configuration in output tool. And also change the range and file location as per your requirement. Let me know if it works.

[adarsh2608]

Hello @grazitti_sapna ,

Thank you for the response , but range starts from D1 and end is dynamic based on the entry

[grazitti_sapna]

@adarsh2608 , Can you please try out the below workflow, in this we can use formula tool to set the range based on record count.

[adarsh2608]

@grazitti_sapna , it worked in getting range but since excel contains filters and formula it throws error " column contain formula unable to write" . One which it need to update doesn't have the formula 

[grazitti_sapna]

@adarsh2608 , Can you please share the screenshot of the error you are getting because I am not getting any error even if my excel contains a formula in some different column. And it would be great if you can share the workflow along with the file for which you are getting the error then i might be able to resolve it.

[adarsh2608]

Hello @grazitti_sapna ,

I have attached sample  workflow