I have recently moved to Excel 2007. When I have a formula in an
existing spreadsheet, Excel 2007 recalculates my formula to what it
thinks the value should be.

For example my formula is Sum (B16:J16) - Excel will change this to
Sum(B16:K16) including column K even though it shouldn't be a part of
the formula. How can I stop Excel from doing this? THANKS