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

Formula Displays Instead of Result One Column Only 1
Formula Audit mode active in one column only; cannot kill. 2
Turning off automatic calculation 0
Search multiple words and display result? 1
#VALUE error which disappears when I use F2, ENTER 1
Excel Formula displays text of formula 2
Automation of copy/pasting data and retrieving results 0
Dispaly results, rather than a formula 2

Top