0

I'm trying to automate a routine task that involves opening a few Excel files in separate instances and refresh them simultaneously. If I use RefreshAll(), it will process each workbook one by one. Is there a way to refresh multiple Excel workbooks in parallel using PowerShell? Any help is highly appreciated.

Vincent Hu
  • 1
  • 2
    have you tried searching around for running tasks in parallel using powershell? https://stackoverflow.com/questions/4016451/can-powershell-run-commands-in-parallel may answer your question? – JoSSte Dec 16 '17 at 11:03
  • @JoSSte -- _neat_ - I didn't know PowerShell could do that. – ashleedawg Dec 16 '17 at 11:39
  • @Vincent -- why would you have multiple instances of the same workbook open and have a need to refresh them simulataneously? – ashleedawg Dec 16 '17 at 11:43
  • @ashleedawg -- I need to refresh multiple workbooks and open each of them in a separate instance – Vincent Hu Dec 16 '17 at 11:58
  • @Vincent -- Why separate instances? Why do they need to be refreshed simultaneously? Is there linked data to outside sources? Where from? I'm just trying understand more so that I or others can help you. – ashleedawg Dec 16 '17 at 12:00
  • @Vincent - Also please check out [mcve] as well as [ask] for some good tips. – ashleedawg Dec 16 '17 at 12:01
  • You could open different excel instances (Applications). The Application will not see the workbooks that are open in the other excel Applications – Peter Pesch Dec 16 '17 at 14:02

0 Answers0