Check Tools/Options/Calculation and make sure that Automatic calculation
is selected.

In article ,
scottnshelly wrote:

This
worked great for about two weeks. now it seems like the concatenate
isn't concatenating anymore. when i erase and then re-type the
concatenate formula is works fine, but then stays the same when i erase
the other cells.
any suggestions?