Functions not re calculating automatically

[cjv]

i've lost all my automatic re-calculation ability in ALL of my spreadsheets
if i change a number it will not re calculate automatically - i have to go
to the function line, put my cursor at the end of the formula and hit enter
for it to re-calculate. What have I done?
I'm using Excel 2002.
Thank you

[Paul B]

cjv, tools. options, calculation, check automatic
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"cjv" <cjv@discussions.microsoft.com> wrote in message
news:F4A722CE-1BC2-4E8F-B26F-23299B0E2CC8@microsoft.com...
> i've lost all my automatic re-calculation ability in ALL of my
> spreadsheets
> if i change a number it will not re calculate automatically - i have to go
> to the function line, put my cursor at the end of the formula and hit
> enter
> for it to re-calculate. What have I done?
> I'm using Excel 2002.
> Thank you

[cjv]

"cjv" wrote:

> i've lost all my automatic re-calculation ability in ALL of my spreadsheets
> if i change a number it will not re calculate automatically - i have to go
> to the function line, put my cursor at the end of the formula and hit enter
> for it to re-calculate. What have I done?
> I'm using Excel 2002.
> Thank you

THANK YOU - DUH HAVING A BLONDE DAY!

[Paul B]

Your Welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"cjv" <cjv@discussions.microsoft.com> wrote in message
news:692E1D3C-359D-47A7-8602-15D42C993061@microsoft.com...
>
>
> "cjv" wrote:
>
>> i've lost all my automatic re-calculation ability in ALL of my
>> spreadsheets
>> if i change a number it will not re calculate automatically - i have to
>> go
>> to the function line, put my cursor at the end of the formula and hit
>> enter
>> for it to re-calculate. What have I done?
>> I'm using Excel 2002.
>> Thank you
>
> THANK YOU - DUH HAVING A BLONDE DAY!