Formulas in excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Is the worksheet protected with those cells locked (and hidden checked)?

Are you sure that the formulas haven't been replaced by their values?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dragging/Copying Formulas in Excel 2007 3
Formula displays as formula, not as result 2
Cell display in 2007 1
Protecting Formulas in Tables 2
Excel VBA 1
protecting formulas without protecting sheet so grouping still wor 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
v07 cell shows formula string literal not value returned from formula 1

Back
Top