View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CC CC is offline
external usenet poster
 
Posts: 91
Default automatically update date

The formulas =now() and =today() in two of our worksheets no longer work.
They used to automatically update the date when the worksheet was opened.
The same formulas work in other worksheets. Any idea why they are no longer
working. We want the date to automatically update to that day's date
whenever the worksheet is opened.