Hi all,

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

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

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

Many thanks

BC