formula only works when file is saved.
 

For some strange reason my formulas do not work until I save the sheet.I am
using 2007 with a file that was in 2003. Never had a problem before. It is
in compatibility mode. when I enter the data nothing happens in the cell
where the result is suppose to go. If I close and save the result shows up.
If I open the file back up and take out the data I put in the result is
still there, where it should be a zero. Something is screwed up. Multiple
people have access to this file.

formula only works when file is saved.
 

Sorry about the post . I found the problem. Somebody changed calculations
to manual
"bob" wrote in message
...
For some strange reason my formulas do not work until I save the sheet.I
am using 2007 with a file that was in 2003. Never had a problem before.
It is in compatibility mode. when I enter the data nothing happens in the
cell where the result is suppose to go. If I close and save the result
shows up. If I open the file back up and take out the data I put in the
result is still there, where it should be a zero. Something is screwed
up. Multiple people have access to this file.