You cant stop TODAY() updating itself unless you paste special values it.
Try using this code in This Workbook, hit Alt and F11 to open the VB editor,
click 'This Workbook' on the top left, copy and paste the code into the
empty window and save the file.
Alter the sheet and range to suit,
Regards,
Alan.

Private Sub Workbook_Open()
Sheet1.Range("A1") = Date
End Sub
"PWS" wrote in message
ups.com...
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