Hello All,
I have a excel file on the network which acts as parent to multiple child files. I want the current time to be pushed by the parent file to all child files.
I am using NOW() function in the parent file in one of the cells (say "A1"). Now A1 is being referenced in all child files so that all files get the same value and there are no inconsistencies.
The problem is NOW() function gets evaluated only when the file is opened and not everytime A1 is referenced by the child files. I am thus not getting the actual time but the time stamp when the master file was opened last.
Any help is welcome!
Regards,
Alok
I have a excel file on the network which acts as parent to multiple child files. I want the current time to be pushed by the parent file to all child files.
I am using NOW() function in the parent file in one of the cells (say "A1"). Now A1 is being referenced in all child files so that all files get the same value and there are no inconsistencies.
The problem is NOW() function gets evaluated only when the file is opened and not everytime A1 is referenced by the child files. I am thus not getting the actual time but the time stamp when the master file was opened last.
Any help is welcome!
Regards,
Alok