Hi all,

Have a shared workbook with three worksheets - I am trying to see in
cell the last of them that has been changed (and saved) so for th
others to catch up, without waiting the minumum 5 mins allowed in th
tabs.

I am using a FileDateTime function to show the last time/date of th
file in the shared directory.

It works fine the first time. However, to see the latest updated valu
I need to go in the cell and retype the function manually (i.e. is no
automatic). Is there a way to go around it?

Many thanks

B

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=55399