I have one "Master" Excel file which opens/activates other 4 excel files at specific time.(using ontime). The other 4 files are wriiten to acutally get date inside them updated when they are open (by workbook_open() ). When I run the 4 files seperately,they are fine. But using this master file, ONLY one file out of 4 can be updated! only one specific file..idon't know why?? and the other 3 files are open and activated(i can see screen updating),but they don't actually get updated!!how come?

the code in Master file is like:

dim wrkbook1 as workbook
dim wrkbook2 as workbook
dim wrkbook3 as workbook
dim wrkbook4 as workbook

set wrkbook1 = workbooks.open( path of file 1)
wrkbook1.activate

set wrkbook2 = workbooks.open( path of file 1)
wrkbook1.activate

set wrkbook3 = workbooks.open( path of file 1)
wrkbook1.activate

set wrkboo4 = workbooks.open( path of file 1)
wrkbook1.activate


end sub

Thanks for any help!!!!!!!