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