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.