SOLVED

Open and run the same Excel files simultaneously

%3CLINGO-SUB%20id%3D%22lingo-sub-2224743%22%20slang%3D%22en-US%22%3EOpen%20and%20run%20the%20same%20Excel%20files%20simultaneously%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224743%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20engineering%20model%20built%20in%20Excel%202019%20which%20takes%20around%204%20hours%20to%20run.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20run%20it%20overnight%20twice%20at%20least%2C%20so%20I%20need%20to%20open%20the%20same%20model%20twice%20and%20run%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2224743%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2224901%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20and%20run%20the%20same%20Excel%20files%20simultaneously%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224901%22%20slang%3D%22en-US%22%3E4%20hours%20each%20time%3F%20Maybe%20VBA%20from%20another%20workbook%20to%20run%20them%20consecutively%3F%3F%20Or%20you%20could%20open%20workbook%20in%20two%20instances%20of%20Excel%2C%20but%20I%20think%20you'll%20probably%20run%20into%20processing%20bottleneck%20if%20it%20takes%204%20hours%20due%20to%20really%20intense%20formula%20re-calculation.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fhow-to-open-multiple-instances-of-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fhow-to-open-multiple-instances-of-excel%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-to-run-multiple-instances-of-excel-on-office365%2Fm-p%2F1472563%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-to-run-multiple-instances-of-excel-on-office365%2Fm-p%2F1472563%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
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