Hi All

I just wanted to let you know about the concatenate function which is not updated automatically if i change the values in the cell which already called in the function.

for example,

I have the row which needs to be merged using the concatenate function. I have created the function but, if i changing the value in the cell the changes has not updated in the function cell so that i have double click the function cell and put ENTER then it has updated.



Also if try to drag the function below to apply all the rows but, the same above not updated automatically and i have double click each cell and put ENTER manually.

Please anyone advise how to resolve this issue.

Thanks
Ganesan. G

Are your calculations set to Automatic?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Usually in the excel if we use the formula we need to drag and use other cells too.

But in the concatenate not like that, so that i am just drag all the values but put ENTER manually in each cell to update the corresponding values.

[quote=ganesang;135767]Usually in the excel if we use the formula we need to drag and use other cells too.

You're right Ganesang, the concatenate function/formula should return values based on the cell references, but our Moderator is asking you to check if your calculations is set to automatic. Go to the formulas tab, open calculation options, check the "automatic" option.

Thank you very much!!!

got it

Is the problem solved? Then read my signature

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post