I recently upgraded to Excel 2007 and now I'm noticing this problem.

Col A Col B Col C
Code: Location: Percent:
55 Colorado =C25
25 Nebraska =C26
35 Kansas =C27
45 Texas =C28

Column C is a formula referencing a cell further down in the spreadsheet.
When I sort the above four lines by either code or location, the formula in
column C changes. Example, the Colorado location formula would now be =C28.

I thought when you sort, the formula should always reference the same cell.
I have not used $ in my formula. I've used this spreadsheet in Excel 2003 and
I don't remember having this problem, but I can't go back and check it since
I have upgraded to 2007. I can fix the problem by adding $ in the formula,
but I'm curious if anyone else has experienced this or has any wisdom?

Thanks, Stefanie