Really weird problem... software glitch?

So I have several lines of data and I am creating a concatenation statement. I enter the statement in row 1 and copy it down. The formula that shows in the formula bar correctly updates the row numbers as you go down but the data in the formula continues to be that of row 1. However, if, for any given row, I click into the formula bar and hit enter the data updates to that of the row. i.e. row 5 then would be correct. This would be fine to do except that there are 5000+ lines.

Any thoughts?

Looks like your calculation is set to Manual, hit F9 to check, then go to Tools/Option/Calculation and select Automatic.

Regards
JG

That did it... sure is a nice bit of info to know.

Thanks!!