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

Hi,

I suspect calculation has been changed to manual.

On the Ribbon click the 'Formulas' tab and then 'Calculation options' and
change back to automatic.

If it is this and your wondering how it happened it's because Excel
remembers the caluclation method of the first workbook opened in a session.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ChrisSDB" wrote:

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

Hi,

Absolutely brilliant. I would never have found it. And it did it for all
the spreadsheets I had open. No idea how I got on to manual calculation
though. Thanks.

"Mike H" wrote:

Hi,

I suspect calculation has been changed to manual.

On the Ribbon click the 'Formulas' tab and then 'Calculation options' and
change back to automatic.

If it is this and your wondering how it happened it's because Excel
remembers the caluclation method of the first workbook opened in a session.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ChrisSDB" wrote:

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