This is because saving a file does not trigger a worksheet calculation, and
it doesn't update when there is some calculation triggered by other changes,
so your function doesn't update. You can force a recalc with Ctrl-Calc-F9,
or you can add Application.Volatile to the function so that it gets
recalculated on an F9 or when some other change occurs that does trigger a
recalc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kim" wrote in message
...
I created a function in Excel to display the "Last Saved Date and Time" in
a
cell. The code is as follows:

<
Function LastSaved( )
LastSaved = ActiveWorkbook.BuiltinDocumentProperties.Item(12)
End Function


After saving the modified file, the cell displays the "Last Saved Date and
Time". I tried to modify the file another time and saved it. The cell
however
does not change to the new date and time. But this was reflected under the
File - Properties - Statistics.

How can I update the cell to continuous display the right date and time
whenever the "Save" button is clicked ?