Forum Discussion
samory
Mar 20, 2021Copper Contributor
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 ther...
- Mar 20, 20214 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
tboulden
Mar 20, 2021Iron Contributor
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
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