Formulas in excel 2007

D

donna

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
 
D

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?
 
D

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.
 
Top