Hi I’m having a problem using MS Excel 2003

Hi,
I’m having a problem using MS Excel 2003. When I open a file by double clicking, the formulas are not getting updated when the information is changed.
The calculate function is shown at lower left side corner. The function key F9 is also not updating the formula. But when I use the open file option in the file menu, everything is working fine. What could be the reason?
Do you have any answers?
Please help me.
