Hi. I'm using Excel 2007 and all of a sudden this problem is happening...
I have a simple data table set up to calculate totals of columns.

I put the "SUM" function in the bottom row of column A and then drag it
across columns B-D to use the same function. What is happening is that the
SUM results of column A are being copied over into the other columns (B-D),
BUT when you click on those cells (B-D), the correct SUM function is there.
Here's an example:

5 6 8 5
2 3 4 1
7 7 7 7