The above description is a bit of a simplification - In actuality, i also have an iterative 'calc/paste-vales/recalc' process that runs on each of sheets 4-10 (the iteration proceeds until some required sensitivity is reached, and only then is the full sheet calculated). The slow bit appears to be excel recalculation rather than the addin speed. I wonder if there is a better way i might make use of the multiple cores and multithreading. Interestingly, if i switch off multithreading, it takes 25.8 seconds! What's more if i run it on a super fast machine (2 x Intel Xeon X5570, quad-core “Nehalem” architecture, 64bit with 64bit excel) it's slower than my laptop, taking 230seconds with multithreading or 26 seconds without. Running a subset of data on my laptop (64bit with 32bit excel, intel i7) it takes 54.6 seconds.
#Excel 2016 mac runs slow how to
Sheets 2-3 are recalculated in sequence (sheet 2, then 3)ģ) sheets 4 through 10 are recalculated in sequence, but since each independently only links to sheet 2, they could in theory recalculate in parallel - right? But how to do this?Ĥ) begin process again with calling of new data via vba addin described in 1) The sequence is driven from VBA and goes something like this:ġ) vba calls an addin (excel-dna vb.net addin, that controls a datareader and attached database)Ģ) addin returns data to sheet 1. My problem is that under the current set up the sequential calculation process i have is taking too long.
I'm wondering if there is any way to control excel calculation such that several sheets in a WB are recalculated in parallel, while the others not.
0 kommentar(er)
