Excel 2007
I opened up a spreadsheet with formulas already in it (a blank ready to use)
and none of the formulas seem to work. If I enter values the formual does
not calculate, if I then reenter the formla after the values it calculates,
but if I try to copy the formula to the next cell, it returns the same value
as the cell I've copied from, ignoring any values in the cells it relates to,
whether already there or entered afresh. The only way to work it would be to
enter the formual manually in every cell after the values it related had
already been entered.

Any one out there had this one?

ChrisSDB