I have a slightly absurd but real need to run 25+ instances of excel fast

[Trident1000]

So as the title reads, I need to work with 25+ instances of excel with tons of formulas and data in each instance.

 

I have a powerful setup with an AMD 3970x Threadripper, 80GB+ of TridentZ RAM, Samsung EVO SSD, etc.  But even with this setup it just cant process everything quickly.

 

Now here is also something worth mentioning...I have assigned via python script each instance of excel to a different processing core on my CPU (32 cores), but still no luck, its agonizingly slow.  Oddly the CPU is not even above 15% utility when calculating.  So I dont quite get how it can be slow but not using all the CPU power or even close to max.  I'm curious where the bottleneck is.  Its also not the memory which is below 10GB utility.

 

Anyone have any suggestions on how to make this work?  Is there some setting, code, hardware set up that could get this running?

 

Thanks in advance.

[Shimejii]

Im pretty sure you dont need 25 instances of excel open. your are being limited by windows.

[Dedayog]

Your supposed system can handle 25 instances of Excel easily, even with formulas and data,. even macros.  

 

Are you having trouble moving thru the instances, as in no GPU power to show graphs or charts?

 

For reference, I am Controller for a real estate developer and I run schedule for pref returns, pro formas for acquisitions, amidst having numerous Quickbook companies, YouTube running, Word, pdfs by the dozens (I rarely close anything) and I have no issues at all with a 9700 + 1050Ti (I think it is).

[Trident1000]

3 minutes ago, Dedayog said:

Your supposed system can handle 25 instances of Excel easily, even with formulas and data,. even macros.  

 

Are you having trouble moving thru the instances, as in no GPU power to show graphs or charts?

 

For reference, I am Controller for a real estate developer and I run schedule for pref returns, pro formas for acquisitions, amidst having numerous Quickbook companies, YouTube running, Word, pdfs by the dozens (I rarely close anything) and I have no issues at all with a 9700 + 1050Ti (I think it is).

If I turn "automatic calculation" to off, it can handle it with no problem.  If I turn it to automatic (which is needed) it cant handle it.  Its a lot of data and formulas....like 10k rows and 135 columns.  All together (x 25) thats like 35 million.  Just odd that it says 64 threads calculating but the CPU utility is so low.

[Dedayog]

3 minutes ago, Trident1000 said:

If I turn "automatic calculation" to off, it can handle it with no problem.  If I turn it to automatic (which is needed) it cant handle it.  Its a lot of data and formulas....like 10k rows and 135 columns.  All together thats like 35 million.

That is still within the bounds of your system, or most desktop systems.  Are all the Excel files on your local machine or are you trying to access thru the internet (Google Drive, etc)?

 

Do you need graphical power?  

[Trident1000]

2 minutes ago, Dedayog said:

That is still within the bounds of your system, or most desktop systems.  Are all the Excel files on your local machine or are you trying to access thru the internet (Google Drive, etc)?

 

Do you need graphical power?  

All on my local machine.  I wouldnt think graphical power would be in play here but regardless I have a 1080TI so more than plenty.  I have a feeling there is some sort of bottleneck with windows but Im not sure.

[Dedayog]

10 minutes ago, Trident1000 said:

All on my local machine.  I wouldnt think graphical power would be in play here but regardless I have a 1080TI so more than plenty.  I have a feeling there is some sort of bottleneck with windows but Im not sure.

That's the only explanation I could see, it being Windows. 

 

Your machine should barely be waking up under that load.

[LogicalDrm]

-> Moved to Programs, Apps and Websites

***

 

Gonna assume you are already on 64bit Excel. At which point it might be just Excel not being capable to handle things.

[steelo]

I know this is a half-answer, but have you tried openoffice? I have worked projects requiring 15-20 spreadsheet to be open (with calculations and macros enabled) and had no issues with a quad core cpu.