Stop Updating Today() On opening
 

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

Stop Updating Today() On opening
 

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

Stop Updating Today() On opening
 

hi,
=now() will always show the current date.
if you want to enter todays date and have it stay that way, use the keyboard
shortcut Ctrl+;

Regards
FSt1

"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

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

Stop Updating Today() On opening
 

The problem is that a workbook contains a Today() function in a cell.
I want to be able to re-open that workbook as it was when it was
saved. But when the workbook is re-opened, all the cells that are
dependant on the Today() cell recalculate, even though recalculation
is turned off.

I appreciate the other advice, but can anyone suggest a way to solve
my issue?

PWS

Stop Updating Today() On opening
 

today() is volitile
a workaround is for you to use a macro to change the today() to the date
asat close of file
If A1 has your main =today() entry
enter in the workbook page in visual basic
Private Sub Workbook_BeforeClose(Cancel As Boolean)
cells(1,1)=date
End Sub

then use another macro to reestablish the = today() in the cell.

depending on what you want to do before you put in the new =today() would
influence what type of macro you would wwant to use


"PWS" wrote:

The problem is that a workbook contains a Today() function in a cell.
I want to be able to re-open that workbook as it was when it was
saved. But when the workbook is re-opened, all the cells that are
dependant on the Today() cell recalculate, even though recalculation
is turned off.

I appreciate the other advice, but can anyone suggest a way to solve
my issue?

PWS