View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wvc wvc is offline
external usenet poster
 
Posts: 1
Default How do I fix: cell won't calculate because it is a constant?

When I export a table from a third party application into an Excel file,
formulae are not calculated. The formulae are displayed instead of the value
of the formula. I do not have this option selected (to display formulae
instead of values). When I "evaluate formula" the message says that "The
cell currently being evaluated contains a constant."