Open and run the same Excel files simultaneously

[samory]

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 · Accepted 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...

[#3]

@tboulden yea 4 hours each time

I will try the methods you mentioned many thanks