dynamic updating the excel

[adarsh2608]

I have excel which is containing multiple formulas and filters and to which there is a last column "status" , when workflow run it will update a value in status column . usually it overwrites the entire excel which will kill the filters and formula instead of that i have added range now it fails as it throws error "unable to overwrite the cell contains formula ". 

[hellyars]

If all else fails, why not output from Alteryx to a separate sheet and have the Excel formula refer to it?

[hellyars]

Check to make sure your range is correct.  

...does Alteryx output the Excel formula?  If not, see if that works.

[trung2403]

Hi,

You should output to Status column only. For example, I will output Status value to column B starting from cell B3. The rest of the excel file will remain unchanged. By doing this, you will not overwrite those columns having embedded formulas. Please refer to the below for detailed configurations.

[adarsh2608]

Hello @trung2403 and @hellyars 

I have attached excel and workflow and did same as mentioned, didn't work, can you help

[Felipe_Ribeir0]

Hi @adarsh2608 

Please try again with the attached workflow.

[adarsh2608]

Hello @Felipe_Ribeir0 ,

After running the workflow though it is getting updated but in the wrong column , i have filtered to update in last 2 month in the workflow it is showing correctly but in the excel it is not updating correctly.

[Felipe_Ribeir0]

Hi @adarsh2608 

You want to update just the I column, right? 

Try again please, i made one change

[trung2403 · Accepted solution]

Hi @adarsh2608,

I have changed a bit. Actually you dont need to create a new field for file path. The idea is that you get the value for Status column, reorder it to make sure it in the same order of your original dataset (that why i had record ID tool at the beginning and Sort it by ascending order at the end). Then, only select the Status column to write to the output file in column I, starting from cell I2. Please refer to the Output configuration as below. You can notice that in the file name, i write down Sheet1$I1:I.

The final output will look like this:

The whole WF. (Sorry, I'm using company's laptop and not allowed to upload any file. So cannot attach the WF here. But if you still need it, do let me know, i will upload when i get back home)

[adarsh2608]

@trung2403 , this was helpful, thank you