That is probably what happened. Thank so much for your help, Dave
Donna

"Dave Peterson" wrote:

Someone could have selected the range and then used:
edit|copy
followed by
edit|paste special|values

The equivalent could have been done in a macro.



donna wrote:

No the cells are not locked. Formulas replaced by their values how does that
happen?

"Dave Peterson" wrote:

Is the worksheet protected with those cells locked (and hidden checked)?

Are you sure that the formulas haven't been replaced by their values?

donna wrote:

I was recently upgraded to 2007 version and my formulas are not deisplyaing
from old documents. I have the automatic calculation on and their is no
protection on the worksheet. The cell only has the result and no formula.
Thank you
Donna

--

Dave Peterson


--

Dave Peterson