Thread: Excel displaying formulae as constant and not calculating formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Excel displaying formulae as constant and not calculating formula
2) you have automatic calculation turned on in your options

Think Dav meant:
2) you *do not* have automatic calculation turned on in your options

To quickly check/ensure that calc mode is set to auto, via:
Click Tools Options Calculation tab Check "Automatic" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote