what the excell gone weird?

[B.B]

when I open any excel file (or create new files) it wont update any formula
unless I save the document. example cell A1 = B1
I input 2 in cell B1
cell A1 will not show the value 2 untill I save the changes.
any idea what going on?
Excel 2000 9.0

Thanks

[mudraker]

Check under Tools > Options > Calculation and Calculation set to automatic

[Rowan]

Check Under Tools>Options>Calculation. It sounds like it is set to Manual
with Recalculate Before Save. Select Automatic instead.

Hope this helps
Rowan

"B.B" wrote:

> when I open any excel file (or create new files) it wont update any formula
> unless I save the document. example cell A1 = B1
> I input 2 in cell B1
> cell A1 will not show the value 2 untill I save the changes.
> any idea what going on?
> Excel 2000 9.0
>
> Thanks
>
>
>

[B.B]

thanks found it

"Rowan" <rowanzsa at hotmailNOSPAM dot com> wrote in message
news:[email protected]...
> Check Under Tools>Options>Calculation. It sounds like it is set to Manual
> with Recalculate Before Save. Select Automatic instead.
>
> Hope this helps
> Rowan
>
> "B.B" wrote:
>
>> when I open any excel file (or create new files) it wont update any
>> formula
>> unless I save the document. example cell A1 = B1
>> I input 2 in cell B1
>> cell A1 will not show the value 2 untill I save the changes.
>> any idea what going on?
>> Excel 2000 9.0
>>
>> Thanks
>>
>>
>>