Formulas in excel 2007

[Guest]

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]

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

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

 

[Guest]

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

 

[Dave Peterson]

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.

 

[Guest]

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