View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Stop Updating Today() On opening

It depends how you did it. If you used VBA then use use the DATE function
with no brackets. If you did it directly in a cell then enter a static date
with CTRL;

Mike

"PWS" wrote:

Is there a way to have a workbook open, and have the Today() function
in a cell not update itself.

I have tried setting recalculation to manual prior to opening the
workbook and this does not achieve what I am looking for.

PWS