Check Under ToolsOptionsCalculation. 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