View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian
 
Posts: n/a
Default Greeting Function


Yes, that is correct. TODAY() and NOW() functions are volatile. They
will update when any formula in the entire workbook recalculates
regardless of cell references, or when the workbook is opened or saved.
However, they remain static until excel calculates.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555043