It won't recalculate automatically, as there is no cell changed when you
save, and the formula doesn't reference anything, so there is nothing to
trigger it.

You could trap the save event and write to the cell.

Or, if you use this code you can force a recalculate with Alt-F9

Function last_time()
Dim all_saved As Date

Application.Volatile
all_saved = FileDateTime(ThisWorkbook.FullName)
last_time = all_saved

End Function



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bondcrash" wrote
in message ...

This is the one I am using


Function last_time()
Dim all_saved As Date

all_saved = FileDateTime("\\Your-1af8a1ea42\SharedDocs\control.xls")
last_time = all_saved

End Function


I have tried also reopening the sheet or recalculating but only way to
update the right time is to go in the cell manually and re-enter it


Cheers

BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=553997