function updating

[Mr. Guy]

i'm using the concatenate function and i'm wondering if there is anyway go get it to auto update. if i change the value of a cell it wont update the cell with the concatenate function in it unless i click in the box and hit enter (it doesn't even work if i highlight the cell and hit enter, i have to physically click in the function bar). Any suggestions?

 

[Ian Mac]

check to see if the sheet is auto-calculating

Tool/Options/Calculation

Make sure the Automatic box is Checked

 

[Mr. Guy]

grrr i knew it was in there somewhere. thanks.