what the excell gone weird?

B

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
 
R

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.B

thanks found it

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

Hope this helps
Rowan
Click to expand...
 
Top