See Gord's response for an explanation of why it happened.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"just me" wrote:

Thank you SOOO much..I have know idea how or why it is doing that! But I
will write down this solution so when it does it again I will know what is
wrong...thank you thank you thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"Dave F" wrote:

You may have calculation set to manual. Go to Tools--Options--Calculations
and select the Automatic box.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"just me" wrote:

then it works. It has done this many times before and I have no idea what I
am doing wrong or how to fix it.

For further clairification... I have two cells D:2 and E:2 I wish to muliply
and have the total on F:2 So in the cell of F:2 I have the function...
=PRODUCT(D2*E2) .
When I first saved it and opened and used it for several weeks it works fine
and does what I want it to do, but then one day it stops working and now it
will only multiply the problem if I double click on F:2 cell and then push
enter, then I will get the total. Why is it doing that??? I have had to
recreate this spread sheet twice and it takes two hours to do so, so I am
hoping to avoid that. I have checked to see that if it is the locked postion
that is doing it but it does not make a difference.

Can anyone help??
Thanks
Kim.