Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable in
EXCEL? Help!!!

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable
in
EXCEL? Help!!!

THANK YOU SO MUCH!! THAT JUST SAVED ME DOUBLE TIME ON THE SPREADSHEET.
THANK YOU AGAIN


"Bernard Liengme" wrote:

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable
in
EXCEL? Help!!!

You are very welcome.
But please turn down the volume - caps in email is considered to be
shouting.
all the best
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
THANK YOU SO MUCH!! THAT JUST SAVED ME DOUBLE TIME ON THE SPREADSHEET.
THANK YOU AGAIN


"Bernard Liengme" wrote:

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the
value
doesn't chg. I have to go to the formula line and click on it and then
on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the
cell
copied appears in the cell. Is there something I need to
disable/enable
in
EXCEL? Help!!!

"Bernard Liengme" wrote:

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable
in
EXCEL? Help!!!


Thanks! I was searching for the same answer Sherberg. Someone at my office had been using a spreadsheet I created and she somehow got into that option and set it for manual calc and didn't know what she had done. Thanks again - most helpful!