Formula displays as formula, not as result

  • Thread starter Thread starter Empque
  • Start date Start date
E

Empque

A Excel 2007 workbook, converted from 2003, is displaying formulas instead of
their results when the formulas refer to a different worksheet in the same
workbook. The "Display formulas in cells instead of calculated results"
option is turned OFF for all worksheets. Does anyone know what can cause this?
 
This is not the normal experience when XL2003 files are opened in XL2007
Could it be that these cells are formatted as text?
best wishes
 

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 Audit mode active in one column only; cannot kill. 2
Dispaly results, rather than a formula 2
copying formulas-displaying results 1
Formulas saving as values 3
Excel Formula displays text of formula 2
Formulas do not generate result until formula edited 3
Formula result disappeared 5
Excel Count If Formula Question 1

Back
Top