Thread: Weird formula block

I am getting stressed - When I copy a formula, it reads correctly but won't
compute correctly. Like is reads C1+C2 but the cell contains the results from
where I copied the formula from - like the total of A1+A2. How can I get it
back?
Carole

Sounds like you have automatic calculation turned off?
Tools-->Options-->Calculation tab.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Carole Drake" <CaroleDrake@discussions.microsoft.com> wrote in message
news:08F63962-D641-45AA-AF07-E1990C5DE06D@microsoft.com...
> I am getting stressed - When I copy a formula, it reads correctly but
won't
> compute correctly. Like is reads C1+C2 but the cell contains the results
from
> where I copied the formula from - like the total of A1+A2. How can I get
it
> back?
> Carole

aahhhhhh! Thank you SO much

"Anne Troy" wrote:

> Sounds like you have automatic calculation turned off?
> Tools-->Options-->Calculation tab.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Carole Drake" <CaroleDrake@discussions.microsoft.com> wrote in message
> news:08F63962-D641-45AA-AF07-E1990C5DE06D@microsoft.com...
> > I am getting stressed - When I copy a formula, it reads correctly but
> won't
> > compute correctly. Like is reads C1+C2 but the cell contains the results
> from
> > where I copied the formula from - like the total of A1+A2. How can I get
> it
> > back?
> > Carole
>
>
>