Excel memory not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daria - 14 Sep 2007 17:08 GMT

My excel 2003 sheets are not automatically calculating formulas any more. I'm
not sure what happened. For example:
if I add:
200
200
200
600

And change one of the 200 to 300 the sum does not automatically calculate
(it will stay as 600).

I can't drag formulas either. The actual number rather than the formula is
copied.

Thanks for any help - I am going nuts with this!

Daria

I can't drag a formula

Reply to this Message

Peo Sjoblom - 14 Sep 2007 17:29 GMT

Tools>options>calculation and set it to automatic

Signature

Regards,

Peo Sjoblom

> My excel 2003 sheets are not automatically calculating formulas any more.
> I'm
[quoted text clipped - 16 lines]
>
> I can't drag a formula

Reply to this Message

Daria - 14 Sep 2007 19:50 GMT

Thank you Peo! You have saved me so much time as well as my sanity.

> Tools>options>calculation and set it to automatic
>
[quoted text clipped - 18 lines]
> >
> > I can't drag a formula

Reply to this Message