Formula displays as formula, not as result

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

Bernard Liengme

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

Formulas do not generate result until formula edited 3
formula displays as a formula, not as its result 1
corrupted formula in protected worksheet 21
Formulas saving as values 3
Cell displays formula, not result? 4
How to show all formulas of cells in cells (and not the calculated result) ? 10
cell displays formula 3
Excel 2007 Formula Display 5

Top