Excel 2007 not calculating correctly
 

When I copy the formula (eg) V1 + V2 + V3 to the W column, the formula shows
as W1 + W2 + W3; but the result is incorrect; rather it shows the same result
as V1 + V2 + V3. This has only happened today. I don't know what caused it -
if I reboot, the problem disappears initially and then happens all over again.

Excel 2007 not calculating correctly
 

Hi,

Thos sound to me like calculation has been switched to manual. In Excel 2003
you would use

Tools|Options - Calculation tab and select automatic.

I don't know hw you change to automatic in 2007 but if you type 'Manual
calculation' into help you should get an answer.

Mike

"SLINGO" wrote:

When I copy the formula (eg) V1 + V2 + V3 to the W column, the formula shows
as W1 + W2 + W3; but the result is incorrect; rather it shows the same result
as V1 + V2 + V3. This has only happened today. I don't know what caused it -
if I reboot, the problem disappears initially and then happens all over again.

Excel 2007 not calculating correctly
 

Excel OptionsFormulascalculationset to automatic

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H" wrote in message
...
Hi,

Thos sound to me like calculation has been switched to manual. In Excel
2003
you would use

Tools|Options - Calculation tab and select automatic.

I don't know hw you change to automatic in 2007 but if you type 'Manual
calculation' into help you should get an answer.

Mike

"SLINGO" wrote:

When I copy the formula (eg) V1 + V2 + V3 to the W column, the formula
shows
as W1 + W2 + W3; but the result is incorrect; rather it shows the same
result
as V1 + V2 + V3. This has only happened today. I don't know what caused
it -
if I reboot, the problem disappears initially and then happens all over
again.

Excel 2007 not calculating correctly
 

Thanks Don,

I've got all this to learn (again) when; if, I upgrade to 2007.

Mike

"Don Guillett" wrote:

Excel OptionsFormulascalculationset to automatic

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H" wrote in message
...
Hi,

Thos sound to me like calculation has been switched to manual. In Excel
2003
you would use

Tools|Options - Calculation tab and select automatic.

I don't know hw you change to automatic in 2007 but if you type 'Manual
calculation' into help you should get an answer.

Mike

"SLINGO" wrote:

When I copy the formula (eg) V1 + V2 + V3 to the W column, the formula
shows
as W1 + W2 + W3; but the result is incorrect; rather it shows the same
result
as V1 + V2 + V3. This has only happened today. I don't know what caused
it -
if I reboot, the problem disappears initially and then happens all over
again.

Excel 2007 not calculating correctly
 

Mike,
This site has an interactive guide that I found useful when I fist made the
3/7 transition
http://office.microsoft.com/en-us/ex...491511033.aspx
best wishes
-
Bernard

"Mike H" wrote in message
...
Thanks Don,

I've got all this to learn (again) when; if, I upgrade to 2007.

Mike

"Don Guillett" wrote:

Excel OptionsFormulascalculationset to automatic

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H" wrote in message
...
Hi,

Thos sound to me like calculation has been switched to manual. In Excel
2003
you would use

Tools|Options - Calculation tab and select automatic.

I don't know hw you change to automatic in 2007 but if you type
'Manual
calculation' into help you should get an answer.

Mike

"SLINGO" wrote:

When I copy the formula (eg) V1 + V2 + V3 to the W column, the
formula
shows
as W1 + W2 + W3; but the result is incorrect; rather it shows the same
result
as V1 + V2 + V3. This has only happened today. I don't know what
caused
it -
if I reboot, the problem disappears initially and then happens all
over
again.

Excel 2007 not calculating correctly
 

Mike

Just upgraded a couple weeks ago.

Not as bad as I had been led to believe.

Commands and functions are basically same as 2003, just takes a short while
to learn the Ribbon and where all the ToolsOptions stuff is by using the
"Office Button"


Gord

On Sun, 15 Feb 2009 07:49:00 -0800, Mike H
wrote:

Thanks Don,

I've got all this to learn (again) when; if, I upgrade to 2007.

Mike

"Don Guillett" wrote:

Excel OptionsFormulascalculationset to automatic

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H" wrote in message
...
Hi,

Thos sound to me like calculation has been switched to manual. In Excel
2003
you would use

Tools|Options - Calculation tab and select automatic.

I don't know hw you change to automatic in 2007 but if you type 'Manual
calculation' into help you should get an answer.

Mike

"SLINGO" wrote:

When I copy the formula (eg) V1 + V2 + V3 to the W column, the formula
shows
as W1 + W2 + W3; but the result is incorrect; rather it shows the same
result
as V1 + V2 + V3. This has only happened today. I don't know what caused
it -
if I reboot, the problem disappears initially and then happens all over
again.