Open multiple excel and refresh formula using F9 in parallel


I have a folder which has 8 to 10 excel files. The number of files varies for each run. I have to open all the existing number of excel files simultaneously and use the hot key Ctr+alt+shift F9 to refresh formula…

Currently I have taken the file items in a list and looping with “For Each” activity one after another which takes around 3 minutes to complete all.

Is there any workaround where i can open all excel files and use the hotkey simultaneously to reduce the time? Because for 1 transaction item it takes around 3 minutes and I have 8 transaction items which will consume close to 25 mins appx.



Check this one

Suresh J