I am doing something obviously stupid but can't see what
In a spreadsheet I have data in cols A and B
In cell B1 I have =(a1-0.375)
I have copied this to b2.b14 with the result shown:
1 0.625
2 0.625
3 0.625
4 0.625
5 0.625
6 0.625
7 0.625
8 0.625
9 0.625
10 0.625
11 0.625
12 0.625
13 0.625
14 0.625


If I go to cell b2 and then left click in the formula bar then hit enter, b2
evaluates to 1.625. Same with b3, b4 etc.
What have I done to stop the formula evaluating correctly after I have
copied it?

Thanks Chris

Sorry for wasting space but somehow (I have no idea how) the option for
calculation had changed from Automatic to Manual.

Is it possible that I imported a spreadshet with calculation set to manual
and this over-rode my automatic setting and it stayed that way?


"inquirer" wrote in message
...

I am doing something obviously stupid but can't see what
In a spreadsheet I have data in cols A and B
In cell B1 I have =(a1-0.375)
I have copied this to b2.b14 with the result shown:
1 0.625
2 0.625
3 0.625
4 0.625
5 0.625
6 0.625
7 0.625
8 0.625
9 0.625
10 0.625
11 0.625
12 0.625
13 0.625
14 0.625


If I go to cell b2 and then left click in the formula bar then hit enter,
b2
evaluates to 1.625. Same with b3, b4 etc.
What have I done to stop the formula evaluating correctly after I have
copied it?

Thanks Chris

Think the calculation mode of each Excel session
is dictated by the calc mode of the first book opened
within the session.

For example, if the first book's calculation mode is "Manual",
then the mode for all subsequent books opened in the same
Excel session (i.e. until / unless Excel is exited) will
be "Manual", irregardless of their earlier saved modes.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"inquirer" wrote in message
...
Sorry for wasting space but somehow (I have no idea how) the option for
calculation had changed from Automatic to Manual.

Is it possible that I imported a spreadshet with calculation set to manual
and this over-rode my automatic setting and it stayed that way?

Thanks Max, that must have been what happened
CHris
"Max" wrote in message
...
Think the calculation mode of each Excel session
is dictated by the calc mode of the first book opened
within the session.

For example, if the first book's calculation mode is "Manual",
then the mode for all subsequent books opened in the same
Excel session (i.e. until / unless Excel is exited) will
be "Manual", irregardless of their earlier saved modes.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"inquirer" wrote in message
...
Sorry for wasting space but somehow (I have no idea how) the option for
calculation had changed from Automatic to Manual.

Is it possible that I imported a spreadshet with calculation set to
manual
and this over-rode my automatic setting and it stayed that way?

You're welcome, Chris.
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"inquirer" wrote in message
...
Thanks Max, that must have been what happened
CHris