Thread: How do I stop my formulas from updating?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shaun Shaun is offline
external usenet poster
  
Posts: 47
Default How do I stop my formulas from updating?
How do I stop my formula =IF(D81,NOW(),) from updating every time I open
the document? I am using this formula for a form that is filled out
electronically; I am using this formula with a locked cell so that the date
and time cant be modified. If I save the document and then reopen it
refreshes every time I do. How can I stop this from happening?
Reply With QuoteReply With Quote