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" <(E-Mail Removed)> wrote in message
news:425D6F62-FC8E-45F8-8BC6-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:425D6F62-FC8E-45F8-8BC6-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
newsA8C986B-705D-4D51-BA71-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:425D6F62-FC8E-45F8-8BC6-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
> news:425D6F62-FC8E-45F8-8BC6-(E-Mail Removed)...
> > 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!