Thread: Formula displays as formula, not as result
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default Formula displays as formula, not as result
Hi,
Go to View, Formula Auditing, and click on Show Formulas

"Empque" wrote:

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?
Reply With QuoteReply With Quote