SOLVED

Open and run the same Excel files simultaneously

New Contributor

Hi 

I have an engineering model built in Excel 2019 which takes around 4 hours to run. 

 

I need to run it overnight twice at least, so I need to open the same model twice and run it. 

 

Is there a way I can do this? 

 

Thanks

 

2 Replies
best response confirmed by samory (New Contributor)
Solution
4 hours each time? Maybe VBA from another workbook to run them consecutively?? Or you could open workbook in two instances of Excel, but I think you'll probably run into processing bottleneck if it takes 4 hours due to really intense formula re-calculation.

https://exceloffthegrid.com/how-to-open-multiple-instances-of-excel/

https://techcommunity.microsoft.com/t5/excel/how-to-run-multiple-instances-of-excel-on-office365/m-p...

@tboulden yea 4 hours each time

 

I will try the methods you mentioned many thanks