Formulas in excel 2007
 

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

Formulas in excel 2007
 

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

Formulas in excel 2007
 

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

Formulas in excel 2007
 

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

Formulas in excel 2007
 

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