Forum Discussion
Solved
Open and run the same Excel files simultaneously
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
- 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/1472563
2 Replies
- 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/1472563
