Formulas saving as values

  • Thread starter Thread starter Fun Dan
  • Start date Start date
F

Fun Dan

Since I switched to Excel 2007, when I open a workbook that had formulas in
it, they are displaying as values instead. I want to keep the formulas. I've
looked for an option for this in Excel Options, but haven't found one. Does
anyone know what's causing this to happen and how I can stop it?
 
Your problem is not clear...

Are you losing the formulas which are getting replaced by values?

Pl. give an example...
 
Yes. Exactly. Workbooks that had formulas previously now show just values
when I open them in Excel 2007. It's as if I copied the values over the
formulas, but I didn't.
 
I have not faced this problem. You should be getting a prompt at the time of
opening the file...

Can you send the file to me? id to_sheelo add @hotmail.com
 

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

Formula displays as formula, not as result 2
Formatting Cells 3
Formula bar question 3
Deactivating an Excel Warning 2
Mixed cell displays--values and formulas showing on same worksheet 3
v07 cell shows formula string literal not value returned from formula 1
Excel 2010 not allowing me to paste as formula 5
Paste Special Formula Multiply feature doesn't work anymore 2

Back
Top